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: How to optimize sequence retrieval in Oracle and Java

Re: How to optimize sequence retrieval in Oracle and Java

From: AV <avek_nospam__at_videotron.ca>
Date: Wed, 10 Oct 2001 21:37:27 -0400
Message-ID: <oV6x7.50617$ft.3219927@wagner.videotron.net>


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

Original text of this message

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