db error or servlet error
This is code that I am using for db connection. If i execute this code on command prompt, it works fine, but it doesn't work on jsp or servlet. I got an error message like this.
-
[4/6/05 23:07:06:031 EDT] 53fd788b WebGroupE SRVE0020E: [Servlet Error]-[action]: Failed to load servlet: java.lang.NoClassDefFoundError: java/sql/Savepoint
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:543)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at testConnection(MessageCategoryDAO.java:62)
-
line 62 is
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@samson:1521:ORCL","test", "test");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from CONFG_PARAM");
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
con.close();
Please help.
