ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

[Shrikumar Vadivelu]

Hi,

I am getting following exception:

"java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver".

This is my CODE:
----------------

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc dbc:gsoe", "gsoe", "gsoe");
pstmt = con.prepareStatement("insert into tmp_order (id, order_qty) values (?, ?)");
pstmt.setLong(1, dpci_id);
pstmt.setLong(2, two);
pstmt.execute();

Kindly let me know ur suggestions asap.

Thanks & Regards,
--Sri.

[Sripathi Krishnamurthy]

1)check whether you have the jar file(rt.jar) in classpath accessable to jre.
2)also check whether you are using SUN JRE. If you are using other jre, ODBC bridge driver might not exist.

[David O'Meara]

...for example it is not included in the IBM JDK which is installed and enabled by default in WebSphere.

[Pankaj Shirke]

Hi,
If you are using Sun JRE ,then just put rt.jar in your jre\lib\ext directory or add JAVA_HOME/lib folder in your classpath.
It depends on JVM vendor.If you use jvm other than Sun you won't get JdbcOdbcDriver.