Four Stars

tCreateTable ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver with both JDK1.7 and JDK 1.8

I'm trying to use tCreateTable to create table but get below error. I tried use JDK 1.7 and UCanAccess, but still get the same error. Please help!

[statistics] connected
Exception in component tCreateTable_1
java.lang.RuntimeException: Creating table failed
at local_project.test_0_1.test.tCreateTable_1Process(test.java:348)
at local_project.test_0_1.test.runJobInTOS(test.java:590)
at local_project.test_0_1.test.main(test.java:447)
Caused by: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at local_project.test_0_1.test.tCreateTable_1Process(test.java:320)
... 2 more

  • Data Integration
1 REPLY
Moderator

Re: tCreateTable ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver with both JDK1.7 and JDK 1.8

Hi,

Which DB are you using? Does your table name already exist in this database?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.