ClassNotFoundException

[Arun raghvan]

 import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
//import java.sql.SQLFeatureNotSupportedException;
import java.sql.Statement;

public class UpdatableResultSetDemo {
    public static void main(String[] args)  {
        
        Connection connection=null;
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
            
            //getting a updatable resultset
            statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
            resultSet = statement.executeQuery("SELECT * FROM EMP");
            
            //before updating
            System.out.println("Before updating.......");
ResultSetMetaData rsmd=resultSet.getMetaData();
System.out.println(rsmd.getColumnLabel(1));
System.out.println(rsmd.getColumnLabel(2));

            while(resultSet.next()){
                System.out.print(resultSet.getInt(1)+"\t");
                System.out.print(resultSet.getString(2)+"\t");
                //System.out.println(resultSet.getInt("sal"));
            }
            
            //updating a row
            resultSet.absolute(4);
            resultSet.updateString(2, "DDDD");
            resultSet.updateInt("sal", 4444);
            resultSet.updateRow();
//if(resultSet .rowUpdated()) {System.out.print("Updating a row:");System.out.println("Current Row Updated");}
            //deleting a row
            resultSet.absolute(7);
            resultSet.deleteRow();
//if(resultSet.rowDeleted()) {System.out.print("Deleting a row:");System.out.println("Current Row Deleted");}        
            //inserting a row
            resultSet.moveToInsertRow();
            resultSet.updateInt(1, 108);
            resultSet.updateString("ename","cluster");
            //resultSet.updateInt("sal", 8888);
            resultSet.insertRow();
            resultSet.beforeFirst();
            
            System.out.println("After updating.......");
            while(resultSet.next()){
                System.out.print(resultSet.getInt(1)+"\t");
                System.out.print(resultSet.getString(2)+"\t");
                //System.out.println(resultSet.getInt("sal"));
            }
                        
        } catch (ClassNotFoundException cnfe) {
            System.out.println(cnfe);
            cnfe.printStackTrace();
            
        }
        catch (SQLException sqle) {
            System.out.println(sqle);
            sqle.printStackTrace();
        }
        
        finally{
            try {
            if(resultSet != null){
                resultSet.close();
            }
            if(statement != null){
                statement.close();
            }
            if(connection != null){
                connection.close();
            }
            }
            catch(SQLException sqle)
            {
                System.out.println(sqle);
                sqle.printStackTrace();
                System.out.println("Error in closing resources");
            }
            }
        }
    }

   

On the Executing above code i get the following error

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
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.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.cluster.UpdatableResultSetDemo.main(UpdatableResultSetDemo.java:28)

and Can anyone specify a good book for jdbc !?

[David Newton]

I'd say the JDBC driver isn't on your class path. And please post only the code necessary to reproduce the problem... It makes things easier :)

[Arun raghvan]

Oh! i found classes12.jar file is not in folder .. i included now it's working. but i get the following error.(ok David Newton).

java.sql.SQLException: Invalid operation for read only resultset: updateString
java.sql.SQLException: Invalid operation for read only resultset: updateString
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.driver.BaseResultSet.updateString(BaseResultSet.java:353)
at com.cluster.UpdatableResultSetDemo.main(UpdatableResultSetDemo.java:49)

but

   statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );