ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Perl fromSpain" <nicep...@gmail.com>
Subject sealectKey database abstraction
Date Tue, 12 Aug 2008 08:30:10 GMT
Hi,

I'm using the "selectKey" with insert commands. It works great.
We are using a development database based in SQLite, and the select is like
this: select max(id)+1 from TABLE
Now, we are moving our project to the production enviroment, a Oracle 10g
database, and in this scenario we'll use a sequence: Select
theSequence.nextval from dual

The problem: in each scenario, the selectKey statement must be different.
How can I avoid this, or minimize?

Thanks in advance

Mime
View raw message