This one time, at band camp, Laurent Vanzeune said:
LV>
LV>JDK 1.3.1 - JDBC 2.0
LV>MS SQL Server Driver for JDBC
LV>
LV>When using Castor and asking for the size of a QueryResults instance I
LV>receive a SQLException. Checking the Castor code I noticed that in the
LV>size() method resultSet.last() method is used. According to the JavaDoc,
LV>calling the last method on a TYPE_FORWARD_ONLY resultset should throw a
LV>SQLException ...
LV>
LV>In Castor statements are created using con.createStatement() without
LV>specifying any arguments (meaning TYPE_FORWARD_ONLY and CONCUR_READ_ONLY -
LV>default values).
Laurent,
Nowhere does Castor use java.sql.Statement other than in the JDO tests. It
only uses java.sql.PreparedStatements.
There is an execute method exposed by OQLQueryImpl to pass a boolean
into the execute() method specifying whether the ResultSet should be
scrollable. This is then passed on to SQLEngine. See line #1643 of
SQLEngine in CVS.
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
