On 2/13/06, Wade Chandler <[EMAIL PROTECTED]> wrote: > --- Rhino <[EMAIL PROTECTED]> wrote: > > > > > ----- Original Message ----- > > From: "George Sexton" <[EMAIL PROTECTED]> > > To: "'Tomcat Users List'" <users@tomcat.apache.org> > > Sent: Monday, February 13, 2006 1:00 PM > > Subject: OT: Example of Flaky Problems with > > Microsoft Products > > > > > > > In another thread I commented on strange behaviors > > when dealing with MS > > > Products, and the time that they eat in projects. > > Here is an example: > > > > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;824106 > > > > > > "For any row in the ResultSet, you can read any > > column from left to right, > > > and each column should be read only one time. If > > you try to read columns > > > out > > > of order, or if you re-read a column from the > > ResultSet, you may receive > > > the > > > error message that the "Symptoms" section > > describes." > > > > > > Pretty much the same issue was present in ADO 6-8 > > years ago. > > > > > Maybe this wasn't the best example; I'm pretty sure > > you'll have that problem > > with JDBC in _any_ environment. It's JDBC that wants > > you to read columns > > from left to right and once only, not Microsoft. > > > > -- > > Rhino > Are you using the same JDBC I've been using for years? > I've not experienced this as common to JDBC. I've > also not had the same issue with MS SQL. I have had > issues like this when using JDBC-ODBC bridge, but not > the MS SQL JDBC Driver itself. I've experienced this > with Access and FoxPro using JDBC-ODBC as well. > > Wade > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
>From the documentation of the ResultSet interface: "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." http://java.sun.com/j2se/1.5.0/docs/api/java/sql/ResultSet.html The same is true in ODBC (and the associated SQL/CLI standard). Some JDBC and ODBC drivers let you access the columns in any order, but some do not. -- Len --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]