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
