Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of tom.schindl@bestsolution.at
 designates 81.16.98.99 as permitted sender)
Message-ID: <48A181D9.3020304@bestsolution.at>
Date: Tue, 12 Aug 2008 14:28:09 +0200
From: Tom Schindl <tom.schindl@bestsolution.at>
User-Agent: Thunderbird 2.0.0.16 (Macintosh/20080707)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: sealectKey database abstraction
References: <1cdc72bd0808120130v656322e3u81c18b0cf44e7e09@mail.gmail.com>
 <34D5F7AF-6839-4154-85B7-E35F0DAFE9A9@ezabel.com>
In-Reply-To: <34D5F7AF-6839-4154-85B7-E35F0DAFE9A9@ezabel.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Why not using an XML-Entity and load different DTDs, this way you have 
your standard mapping files and only the small Entity thing is switched 
by including this or that DTD.

Tom

Ian Zabel schrieb:
> I'd suggest that you do your development against an Oracle 10g database. 
> This really is the best solution.
> 
> But, if that's not really an option, I guess you could maintain a 
> separate set of sql maps for each DB. Or, maybe use Ant replacement 
> variables for your build to swap out the correct sql map...
> 
> Or, maybe an alternative would be to try to come up with some sql that 
> works on both databases. Not sure if SQLite supports functions, but 
> maybe something like that would work.
> 
> You're really fighting the tool here.
> 
> Ian.
> 
> On Aug 12, 2008, at 4:30 AM, Perl fromSpain wrote:
> 
>> 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
> 


-- 
B e s t S o l u t i o n . a t                        EDV Systemhaus GmbH
------------------------------------------------------------------------
tom schindl                               leiter softwareentwicklung/CSO
------------------------------------------------------------------------
eduard-bodem-gasse 8/3    A-6020 innsbruck      phone    ++43 512 935834