Re: Oracle Lite database and JDBC driver

From: Roger Lindsjö <roger.lindsjo_at_drutt.com>
Date: Mon, 12 Nov 2001 16:37:42 +0100
Message-ID: <3BEFECC6.F09480BA@drutt.com>

Raphael LEMAITRE wrote:
>
> Hi all,
>
> I have a problem with Oracle9i Lite database. When i'm using Type 2 JDBC
> Driver provided with oracle Lite (oracle.lite.poljdbc.POLJDBCDriver in
> olite40.jar), i cannot access multiples times a same column in a ResultSet
> (the second call to rs.getString() returns null whereas the first call
> returns the real value (which is not null))
> Is this a limitation of this driver ?

I think it a JDBS driver can pass the sets even if only allowing you to read each column once and only read them from left to right. Maybe this driver uses this. So to be safe with any driver, only read from left to right and only read ech value once.

Roger Lindsjö Received on Mon Nov 12 2001 - 09:37:42 CST