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!

Batch SELECT

843854Sep 30 2004 — edited Oct 7 2004
Batch inserting did wonders for my app's performance, so I figured I'd do the same to improve my selections. That's when I hit:

sun.jdbc.odbc.JdbcOdbcBatchUpdateException: SQL Attempt to produce a ResultSet from executeBatch

In reading the lists I've seen precursery claims I can't batch select, but I'd like more of an explaination. The javadoc seems to claim it's possible, yes? So is the functionality based on some driver or something else I can swap out with one that can handle batch selects? I'm using Java 1.4 with MS SQL Server.

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2004
Added on Sep 30 2004
45 comments
1,041 views