Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 543
  • Last Modified:

JDBC - ODBC Driver

I am trying to evaluate a product developed in Java that needs the jdbc or jdbc-odbc driver
which is implementing full features sepcified for the drivers. For example it is using functions
like isLast, previous on result set.

I have tried to link this product with oracale using the jdbc driver that comes with oracle but
I am getting following error:
java.sql.SQLException:Invalid operation for forward only resultset: isLast

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)

at oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:268)

If any of you know a jdbc or jdbc-odbc driver for oracle that you think can work in this
scenario please do let me know.

The product spec is explicitly stating that the drivers provided by sun are not supporting the
functionality needed by this product.

I will appreciate any info and help in this regard.

0
arooj_aftab
Asked:
arooj_aftab
  • 2
1 Solution
 
Jim CakalicSenior Developer/ArchitectCommented:
Which versions of the Oracle driver have you tried? The Oracle drivers have been JDBC 2.0 compliant for quite some time now but you have to get the classes12.zip distribution, not classes111.zip. The URL to download the drivers is http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html. You'll have to register for a free OTN account if you don't already have one.

The SQLException you are getting is usually a programming error. To be scrollable, the Statement producing the ResultSet must have been created using one of Connection's Statement factory methods (createStatement or prepareStatement) that takes resultSetType and resultSetConcurrency parameters. Without specifying these parameters, the Connection will by default create Statement objects that have forward-only type and read-only concurrency.

It is my recollection that you'll usually get a different SQLException when the driver doesn't support the requested operation.

Best regards,
Jim Cakalic
0
 
Venci75Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
PAQ'd and pts removed
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Venci75
EE Cleanup Volunteer
0
 
Jim CakalicSenior Developer/ArchitectCommented:
OK.
0
 
NetminderCommented:
Per recommendation, points NOT refunded and question closed.

Netminder
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now