Batch SELECT
843854Sep 30 2004 — edited Oct 7 2004Batch 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.