In JBossCMP I only ready each column once left-to-right.  If I remember 
correctly, the JAWS read ahead code reads the pk columns twice.  It 
should be easy to fix.

-dain

Scott M Stark wrote:

> There are 3 bugs/patches related to the MSSQL driver requirement that
> the result set columns be read in the order that matches the sql query.
> Unbelievably this appears to be allowed by the JDBC docs:
> 
> <ResultSet javadoc>
> The ResultSet interface provides getXXX methods for retrieving column values
> from the current row. Values can be retrieved using either the index number
> of the column or the name of the column. In general, using the column index
> will be more efficient. Columns are numbered from 1. For maximum
> portability, result set columns within each row should be read in
> left-to-right order, and each column should be read only once.
> </ResultSet javadoc>
> 
> Is this something we should be supporting at the cmp engine layer?
> 
> xxxxxxxxxxxxxxxxxxxxxxxx
> Scott Stark
> Chief Technology Officer
> JBoss Group, LLC
> xxxxxxxxxxxxxxxxxxxxxxxx
> 
> 
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-development
> 



_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to