Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to optimize sequence retrieval in Oracle and Java
Unfortunately, Oracle's jdbc driver (classes12_XX.zip)
did not support sql RETURNING (at least till recently).
JDBC3.0 is supposed to force then do it. If you
do NOT care about inserted ids right-away,
than returning or pre-reading of sequence in NOT
necessary at all.
AlexV
"Marko Hantula" <marko_at_coriolisnet.com> wrote in message
news:d1c2ab88.0110101320.1d7bc626_at_posting.google.com...
> "ek" <nirkeen_at_saber.net> wrote in message
news:<ts89uqamv8qi24_at_corp.supernews.com>...
>
> > - Retrieve it for your program from the INSERT ( ss.NEXTVAL,....)
RETURNING
> > id INTO ? " clause
>
>
> I've never used this before, are there any code samples on how to do
> this in Java?
>
> Thanks,
> Marko
Received on Wed Oct 10 2001 - 20:37:27 CDT