error while using java thin drivers to connect to Oracle scott.emp table
I am using the below code to connect to scott.emp table using jdbc tyoe 4 driver and getting the error posted below please help...
thanx in advance.
import java.sql.*;
public class TestJdbc
{
public static void main(String[] args)
{
try{
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Driver Loaded");
//Connection con = DriverManager.getConnection("jdbc:odbc:mats","scott","tiger");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle","scott","tiger");
System.out.println("after con");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from emp");
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
con.close();
}catch(Exception ex){System.out.println("SERROR:"+ex);}
}
}
C:\MATS1.0\ora>java TestJdbc
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.OracleDriver.getConnectionInstance(OracleDriver.ja
va:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestJdbc.main(TestJdbc.java:15)
i had installed JDK 5.0 and running JRE1.5.0_06 and I am getting the following error for the same code
any idea pls help
C:\MATS1.0\ora>java TestJdbc
Exception in thread "main" java.lang.UnsupportedClassVersionError: TestJdbc (Uns
upported major.minor version 49.0)
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)
Hi
When ever run the following code
public static void main(String s[])throws Exception
{
DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@tech4:1521:test" ,"scott","tiger");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from emp");
System.out.println("EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO");
while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString("ENAME")+" "+rs.getString("JOB")+""+rs.getInt("MGR")+"
"+rs.getInt("HIREDATE")+" "+rs.getInt("SAL")+" "+rs.getInt("COMM")+" "+rs.getInt("DEPTNO"));
}
rs.close();
st.close();
con.close();
}
}
I face an error as below
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.OracleDriver.getConnectionInstance(OracleDriver.ja
va:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DbProg.main(DbProg.java:7)
kindly help in this regard,
Thanks®ards
Ramana
