ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject RE: Fetching ids from oracle and postgresql sequences
Date Thu, 23 Aug 2007 20:12:12 GMT
BTW: That goes for pretty much any vendor specific SQL.

JDBC does a great job keeping stored proc calls consistent.  So hiding your
Oracle CONNECT BY and friends in a proc makes it easier to recreate in
another database without having to change your Java code or iBATIS SQL Maps.


-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf Of
Larry Meadors
Sent: August-23-07 1:44 PM
To: user-java@ibatis.apache.org
Subject: Re: Fetching ids from oracle and postgresql sequences

I dunno, I think I like that better than my way - that's pretty tidy.

Heh, I may have a new way to do this. :-)


On 8/23/07, Koka Kiknadze <226057@gmail.com> wrote:
> Here is an ugly way:
> Wrap sequence selects in database procedures with out param returning
> sequence value. Calling procedures have same syntax in both database
> flavours...

View raw message