Thread: ava.lang.ClassNotFoundException: jdbc:odbc:ABCODBC1

I'm trying to test out certain coding and I'm receiving the following error.

Database - MsAccess.

I've double check on the ODBC DataSource Administrator that I've set things correctly but yet been getting the error again and again. Hope someone advise me how to resolve the problem.

Caused by: java.lang.ClassNotFoundException: jdbcdbc:ABCODBC1
at java.net.URLClassLoader$1.run(URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 07)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 52)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDataSource.java:1130)

Hello.
When using JDBC, first we have to load the driver class.
Then we have to get Connection object by passing url, username and password (if available).
I believe when loading class you are not passing the driver class but the url.
Check and let us know.

Syed.

Originally Posted by syedbhai

Hello.
When using JDBC, first we have to load the driver class.
Then we have to get Connection object by passing url, username and password (if available).
I believe when loading class you are not passing the driver class but the url.
Check and let us know.

Syed.

Hi Syed,

Thank you so much for your reply.

Am now reverting to my old code without the JNDI stuff anymore. And now facing another problem which I believe I have to post on a separate thread.

Just want to clarify do you mean adding the line below when you said passing the driver class?

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:ABCODBC1");


Hope to hear from you soon.

Tks again.

Hi,
In the second statement pass the db username and password as second and third parameters resp.
If password is not available atleast provide just the username.
Also, did you already create the DSN before running the program?

Syed.