ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: iBatis and multiple databases
Date Wed, 08 Jun 2005 14:35:20 GMT
There is not one way to support multiple databases with ibatis. There
are several options to manage multiple database support.

(1) Use the extends functionality to override particular statements
that are specific to your database while leaving cross database sql
statements alone.
(2) separate your sqlmap files into slqmaps that can be standard sql
and others that are non-standard and customize them for the particular
database you are working against.
(3) you could have a couple sets of sqlmap files. One for support
Sybase SQL and one for supporting Oracle SQL.


On 6/8/05, Emiliano Armellin <earmellin@ateikon.com> wrote:
>  Hello,
>  I've got this problem: my application (spring+ibatis) works good on a
> Sybase DB but now I have to make it work on Oracle DB. 
>  Oracle uses a different syntax for left/right join so I have to change
> sql-maps files. Well it's not so difficult but I'm asking: which is the best
> way to manage this kind of problem with ibatis? Which is the best way to
> make sql-maps db independent? Is there a simple way to do it?
>  any suggestion?
> -- 
> Emiliano Armellin 
> W_ www.ateikon.com 
> @_ earmellin@ateikon.com 
> T_ +39 0422 452101 

View raw message