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: Oracle Lite database and JDBC driver

Re: Oracle Lite database and JDBC driver

From: Raphael LEMAITRE <raphael_at_e-deal.com>
Date: Mon, 12 Nov 2001 16:03:13 GMT
Message-ID: <5pSH7.108$m7.1610@nreader3.kpnqwest.net>


"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

Original text of this message

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