# DatabaseDriverLoader : "WORKFLOW NAME" : 0 : Could not load JDBC ODBC driver class 'sun.jdbc.odbc.JdbcOdbcDriver'. Class has been removed in Java 8.

**URL:** <https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870>\
**Category:** KNIME Analytics Platform\
**Tags:** batch\
**Created:** [April 26, 2018, 8:04pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870 "2018-04-26T20:04:27Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![MohsenV](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/dec6dc/32.png) [@MohsenV](https://forum.knime.com/u/MohsenV)\
**Post date:** [April 26, 2018, 8:04pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/1 "2018-04-26T20:04:27Z")

</div>

I am getting the error below running a workflow (through batch file) that used to run fine before.  
No Change was made to the workflow since the last successful run:

DatabaseDriverLoader : : 0 : Could not load JDBC ODBC driver class ‘sun.jdbc.odbc.JdbcOdbcDriver’. Class has been removed in Java 8.

P.S. It runs fine through the GUI, but fails in the batch file run

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [April 30, 2018, 12:08pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/2 "2018-04-30T12:08:17Z")

</div>

Hi,  
please see the following [thread](https://forum.knime.com/t/no-connection-to-ms-access-database/6801/5) for information.  
Bye  
Tobias

---

<div class="post-metadata">

**Author:** ![MohsenV](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/dec6dc/32.png) [@MohsenV](https://forum.knime.com/u/MohsenV)\
**Post date:** [May 10, 2018, 2:20pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/3 "2018-05-10T14:20:59Z")

</div>

Hi Tobias,

The workflow runs fine in the GUI, but fails to run in the batch file.

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [May 10, 2018, 7:23pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/4 "2018-05-10T19:23:22Z")

</div>

Do you use the same version for GUI and batch execution? Which database do you connect to? What driver do you use to connect to it and do you use the same connection settings or even the same workflow in GUI and batch execution?

---

<div class="post-metadata">

**Author:** ![MohsenV](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/dec6dc/32.png) [@MohsenV](https://forum.knime.com/u/MohsenV)\
**Post date:** [March 28, 2019, 4:32pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/6 "2019-03-28T16:32:37Z")

</div>

I was using the same version in both GUI and Batch.  
The issue was resolved by adding a parameter to the batch script specifying the preference file:  
-preferences="\…\Batch\Pref.epf"

---

<div class="post-metadata">

**Author:** ![gbprakash](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/e9c0ed/32.png) [@gbprakash](https://forum.knime.com/u/gbprakash)\
**Post date:** [January 28, 2022, 4:33pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/7 "2022-01-28T16:33:28Z")

</div>

hi tobias,  
do we have to set up jdbc ( or odbc) on server if the workflow is scheduled to run on the server ? I would think so right ? my existing workflow with oracle and teradata drivers using jar runs fine on local machine but complains about the drivers / database ( obvious).

Is there a way to push even the jar files to the server specific to the workflow ?  
how do we set them up on server ?

---

<div class="post-metadata">

**Author:** ![ScottF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/scottf/32/61316_2.png) [@ScottF](https://forum.knime.com/u/ScottF)\
**Post date:** [January 28, 2022, 6:56pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/8 "2022-01-28T18:56:56Z")

</div>

Hi @gbprakash and welcome the the forum.

I think this video will be helpful to you:

[![](https://img.youtube.com/vi/ngyh3rhuonY/maxresdefault.jpg "KNIME Server Client Profiles") ](https://www.youtube.com/watch?v=ngyh3rhuonY)

I saw you posted something similar in the KNIME Server forum, so I will reply there as well. But generally there is no need to post your issue twice in different threads - someone will definitely see it. Since this is a 3 year old thread, I will go ahead and close it.

---

<div class="post-metadata">

**Author:** ![ScottF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/scottf/32/61316_2.png) [@ScottF](https://forum.knime.com/u/ScottF)\
**Post date:** [January 28, 2022, 6:57pm UTC](https://forum.knime.com/t/databasedriverloader-workflow-name-0-could-not-load-jdbc-odbc-driver-class-sun-jdbc-odbc-jdbcodbcdriver-class-has-been-removed-in-java-8/10870/9 "2022-01-28T18:57:02Z")

</div>


