Hi
I am trying to use scrollable result set, but i m getting following exception
Exception in thread "main" java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.prepareStatement(Ljava/lang/String;II)Ljava/sql/PreparedStatement;
at com.interactcrm.connector.dbconnector.InboundUtil.readMessage(InboundUtil.java:28)
at com.interactcrm.connector.dbconnector.InboundUtil.main(InboundUtil.java:17)
Source Code
connectionPool = ConnectionPool.getConnectionBean();
connection = connectionPool.getDBConnection();
PreparedStatement ps = connection.prepareStatement("SELECT MSG_ID,DNIS FROM SMS_INBOUND WHERE MSG_ID=1",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = ps.executeQuery();
//PreparedStatement ps = connection.prepareStatement("SELECT * FROM SMS_INBOUND WHERE MSG_ID=1");
//ResultSet rs = ps.executeQuery();
rs.updateInt("READ_FLAG", 1);
rs.updateRow();
System.out.println("Rows Updated...");
I am not able to trace the error.
please help me for the same.
Thanks and Regards,
Amie....