oops bad advice. Forget option (1). Mapped statements do not have extend... only resultMap.
Sorry Brandon On 6/8/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > 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 > > > > >
