package sun.jdbc does not exist

[javed iqbal]

I have tried to set the connection with my database (oracle) but every time I run the code I get the following error.

Error: package sun.jdbc does not exist

even though I have set the environment variables

the code is :



Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);
conn=DriverManager.getConnection("jdbc dbc:newdsn","scott","tiger");

stmt=conn.createStatement();
rs=stmt.executeQuery("select * from emp");




newdsn is my dsn name

please help

[Campbell Ritchie]

Welcome to the Ranch.

You are not trying to get a class from sun.jdbc. You are trying to get a class from sun.jdbc.odbc.
Suggest you edit your post and click on "disable smilies in this post" at the bottom left. That will get rid of the !

[Rob Spoor]

Class.forName requires a String, not a class name itself.

So change

Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);

into

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

and all should be fine.

[David O'Meara]

...Unless you're not using a Sun JRE (eg IBM, HP etc) in which case the sun packages do not exist.

The extended lesson here is that the JdbcOdbc bridge is a dog and you're better connecting with a Type-4 (native Java) driver than relying on the bridge which isn't really supported and definitely not meant for production.