You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by George Sexton <gs...@mhsoftware.com> on 2006/02/13 19:00:49 UTC
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.
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: Example of Flaky Problems with Microsoft Products
Posted by George Sexton <gs...@mhsoftware.com>.
> -----Original Message-----
> From: Len Popp [mailto:len.popp@gmail.com]
> Sent: Monday, February 13, 2006 2:32 PM
> To: Tomcat Users List; hwadechandler-apache@yahoo.com
> Subject: Re: Example of Flaky Problems with Microsoft Products
>
> >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.
Reminds me of C Programming days. The standard library said that the
gettime() function had to return the best possible representation of the
current time since the OS started. A lot of libraries just returned 0
(especially in the embedded arena). It was their best approximation, and it
met the spec, but it still sucked.
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Example of Flaky Problems with Microsoft Products
Posted by Len Popp <le...@gmail.com>.
On 2/13/06, Wade Chandler <hw...@yahoo.com> wrote:
> --- Rhino <rh...@sympatico.ca> wrote:
>
> >
> > ----- Original Message -----
> > From: "George Sexton" <gs...@mhsoftware.com>
> > To: "'Tomcat Users List'" <us...@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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Example of Flaky Problems with Microsoft Products
Posted by Wade Chandler <hw...@yahoo.com>.
--- Rhino <rh...@sympatico.ca> wrote:
>
> ----- Original Message -----
> From: "George Sexton" <gs...@mhsoftware.com>
> To: "'Tomcat Users List'" <us...@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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Example of Flaky Problems with Microsoft Products
Posted by Rhino <rh...@sympatico.ca>.
----- Original Message -----
From: "George Sexton" <gs...@mhsoftware.com>
To: "'Tomcat Users List'" <us...@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
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.6/258 - Release Date: 13/02/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: Example of Flaky Problems with Microsoft Products
Posted by George Sexton <gs...@mhsoftware.com>.
I've never ran into this problem in PostgreSQL. Note that its also dependent
upon the presence of a BLOB.
So, if someone adds a field to your table, BANG! Your application will start
dying.
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
> -----Original Message-----
> From: George Sexton [mailto:gsexton@mhsoftware.com]
> Sent: Monday, February 13, 2006 11:01 AM
> To: 'Tomcat Users List'
> 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.
>
> George Sexton
> MH Software, Inc.
> http://www.mhsoftware.com/
> Voice: 303 438 9585
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org