Re: Problems with JDBC

Michael Gruetzner <Michael_Gruetzner_at_gmx.de> wrote in message news:<3E59CAE3.3090105_at_gmx.de>...
> Hello,
>
> I try to make a jdbc connection to an Oracle 9iR2.
> In my Java programm I use the following lines to
> connect:
> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> Connection conn =
> DriverManager.getConnection("jdbc:oracle:thin:myuser/mypass_at_localhost:1521:mydb");
>
> When I run my Program I always get this exception:
>
> Exception in thread "main" java.lang.NoClassDefFoundError:
> java/sql/Savepoint
> at java.lang.ClassLoader.defineClass0(Native Method)
> at java.lang.ClassLoader.defineClass(ClassLoader.java:493)
> at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)
> at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)
> at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
> at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
> at
> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at mypackage1.Class1.<init>(Class1.java:13)
> at mypackage1.Class1.main(Class1.java:23)
>
> I also tried to create a database connection with JDeveloper an I
> entered the same connection string as above. When I Test the connection
> I get "Success", so I think the String is ok. The DB is also up and running.
>
> I hope, someone can help me.
> Thank you in advance...Michael

Build your connection url like this and then try again,

("jdbc:oracle:thin:@localhost:1521:mydb", "myuser", "mypass");

Regards
/Rauf Sarwar Received on Mon Feb 24 2003 - 12:43:10 CST