problem connecting to oracle database
I'm having a really basic problem with connecting to oracle.
I've made sure that the driver is being found by the program, but it always errors when trying to connect.
CLASSPATH=C:\oracle\product\10.2.0\db_1\jdbc\lib;C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar;C:\Program Files\Oracle\jre\1.1.8\bin;C:\j2sdk1.4.1_05\bin;C:\jakarta-tomcat-4.1.29\bin;C:\jakarta-tomcat-4.1.29\common\lib\servlet.jar;
I'm running Oracle 10.2, and have j2sdk1.4.1_05
code is as follows:
package studyC;
import java.io.*;
import java.sql.*;
publicclass test
{
publicstaticvoid main (String[] args)
{
Connection con =null;
PreparedStatement s =null;
ResultSet res =null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("driver loaded");
String url ="jdbc:oracle:thin:@192.168.2.252:1521:ORCL2";
String username ="system";
String password ="manager";
con = DriverManager.getConnection(url, username, password);
System.out.println("database connected");
s = con.prepareStatement("SELECT * FROM C_2;");
System.out.println("got here");
res = s.executeQuery();
while (res.next())
{
System.out.println(res.getString("code") +"\t" + res.getString("name"));
}
}
catch (Exception e)
{
C12_Log.write(1, e.toString());
}
finally
{
try
{
if (s !=null)
{
s.close();
}
if (con !=null)
{
con.close();
}
}
catch (Exception es)
{
C12_Log.write(1, es.toString() + es.getMessage());
}
}
}
}
and I get the following output when I run 'java studyC.test' from the folder above my package folder.
driver loaded
Exception in thread "main" java.lang.NoClassDefFoundError: java/sql/Savepoint
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at studyC.test.main(test.java:28)
and line 28 is the one with the connect, I took out comments for readability.
If anyone could help out with this I'd be grateful.
