Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Lite database and JDBC driver
"Roger Lindsjö" <roger.lindsjo_at_drutt.com> a écrit dans le message news:
3BEFECC6.F09480BA_at_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ö
I read somewhere this is a limitation of the ODBC driver. That's why i wonder if there is a pure-java JDBC driver (not using ODBC). Received on Mon Nov 12 2001 - 10:03:13 CST