There is not one way to support multiple databases with ibatis. There are several options to manage multiple database support.
Examples (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. Brandon On 6/8/05, Emiliano Armellin <[EMAIL PROTECTED]> 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 > > @_ [EMAIL PROTECTED] > > T_ +39 0422 452101 > >
