Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ResultSet getXXXX Behavior

Re: ResultSet getXXXX Behavior

From: Lee Fesperman <firstsql_at_ix.netcom.com>
Date: Thu, 28 Oct 1999 22:18:02 -0700
Message-ID: <38192E0A.708E@ix.netcom.com>


JV wrote:
>
> We are not sure if this is the correct behavior for a result set.
> ----------------------------------------------------------------------------
> --------
>
> It seems that if the rs.getXXX( “whatever” ) are not in the same order as
> the columns in the select statement it won’t work. After experimenting it
> seems that once you have retrieved the value from a specific column, you can
> ’t go backwards. It behaves the same way if we use column index instead of
> column name on the getXXXX. If the columns are accessed in order,
> everything works.
>
> Are we missing something or do the getXXXs need to be in the same order as
> the columns in order to retreive data out of the result set?

This depends on the JDBC driver. Some drivers require that you 'get' columns in order. I believe this is the case with the JDBC/ODBC driver.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com) Received on Fri Oct 29 1999 - 00:18:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US