Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.prepareS

843859Jul 31 2008 — edited Aug 1 2008
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....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2008
Added on Jul 31 2008
4 comments
1,883 views