Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!wesley.videotron.net!wagner.videotron.net.POSTED!not-for-mail
From: "AV" <avek_nospam_@videotron.ca>
Newsgroups: comp.databases.oracle.server,comp.lang.java.databases
References: <d1c2ab88.0110091006.7795d98e@posting.google.com> <ts89uqamv8qi24@corp.supernews.com> <d1c2ab88.0110101320.1d7bc626@posting.google.com>
Subject: Re: How to optimize sequence retrieval in Oracle and Java
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <oV6x7.50617$ft.3219927@wagner.videotron.net>
Date: Wed, 10 Oct 2001 21:37:27 -0400
NNTP-Posting-Host: 207.253.208.191
X-Complaints-To: abuse@videotron.ca
X-Trace: wagner.videotron.net 1002765012 207.253.208.191 (Wed, 10 Oct 2001 21:50:12 EDT)
NNTP-Posting-Date: Wed, 10 Oct 2001 21:50:12 EDT
Xref: easynews comp.databases.oracle.server:120886 comp.lang.java.databases:31960
X-Received-Date: Wed, 10 Oct 2001 19:41:25 MST (news.easynews.com)

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@coriolisnet.com> wrote in message
news:d1c2ab88.0110101320.1d7bc626@posting.google.com...
> "ek" <nirkeen@saber.net> wrote in message
news:<ts89uqamv8qi24@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