oracle jdbc driver not found

[2001 JI Open Discussion]

By: Keith Berman - bobbassen

oracle jdbc driver not found

2002-07-05 06:52

I am getting an error when trying to run an ant fill on my report:

 

[java] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

[java] at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

 

Here is my code:

 

private static Connection getConnection() throws ClassNotFoundException, SQLException

{

//Change these settings according to your local configuration

String driver = "oracle.jdbc.driver.OracleDriver";

String connectString = "jdbc:oracle:thin:@172.20.128.94:1521:INTRPTP";

String user = "fnihb_rpt";

String password = "fnihb_rpt";

 

 

Class.forName(driver);

Connection conn = DriverManager.getConnection(connectString, user, password);

return conn;

}

 

I have copied both zip files (nls_charset12 and classes12) in my lib directory.

 

Any help would be appreciated!

 

 

By: Teodor Danciu - teodord

RE: oracle jdbc driver not found

2002-07-05 07:29

 

Hi,

 

If you are using a sample "build.xml" file, make

sure that not only the .jar files from the lib directory

are added to the classpath.

I think that the Oracle driver is in classes12.ZIP

and not classes12.JAR and this is why it is not

present in the classpath.

 

Modify the "fill" target in you "build.xml" file to

include also the .zip files into the classpath.

 

I hope this helps.

Teodor

 

 

 

By: Keith Berman - bobbassen

RE: oracle jdbc driver not found

2002-07-05 13:24

Thanks, that fixed it, you are good!