JDBC CONNECTION TO ORACLE9i DB USING JDBC THIN DRIVER 9.2.0

Hi everyone,

I have have set my classpath:

set classpath=.;c:/oracle/ora92/jdbc/lib/ojdbc14.jar;c:/oracle/ora92/jdbc/lib/nls_charset11.zip;c:/oracle/ora92/jdbc/lib/nls_charset12.zip

i have also specified the jdbc url:

String url = "jdbc:oracle:thin:@//chuksnb/javanb;

where chuksnb is the oracle server host and javanb is my oracle service name

somewhere in the code i have specified the driver class:

class.forName("ojdbc14.jar")

please what are the things that i have not done correctly because when i compile my program, i get 31 errors.

thanks

[608 byte] By [sunJavaa] at [2007-10-2 7:56:22]
# 1
> somewhere in the code i have specified the driver> class:> > class.forName("ojdbc14.jar")You need to specify the actual driver class, not the JAR.Refer to the JDBC tutorial
aniseeda at 2007-7-16 21:46:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

"I have have set my classpath:

set classpath=.;c:/oracle/ora92/jdbc/lib/ojdbc14.jar;c:/oracle/ora92/jdbc/lib/nls_charset11.zip;c:/oracle/ora92/jdbc/lib/nls_charset12.zip"

This is probably wrong or not going to help you one bit. This isn't the best way to deal with CLASSPATH.

I don't have an environment variable named CLASSPATH on any machine that I work on. It's not the way to do things, IMO.

%

duffymoa at 2007-7-16 21:46:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
I have read the tutorial, infarct, i'm only trying to run the CreateCoffees.java demo, but i have to modify the JDBC url and the forname parameters, i'm trying to connect via jdbc thin driver 9.2.0, how must i specify the full classname?
sunJavaa at 2007-7-16 21:46:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_01
aniseeda at 2007-7-16 21:46:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...