Hi
all,
my company is
starting a new data-centric application that should be
database-indipendent (e.g. work with MySql, Oracle, SQL-Server, DB2
ecc.).
We don't want to use
Hibernate because we used it in the past e we dont' like it.
I've found iBATIS,
read the documentation and I like it because it's a very practical and flexible
framework!
Now I need to
understand how implement the database-independent
requirement...
I think that
some sqlMap files could be in common (for example if the SQL used in them is
compatible with all the databases) and some other sqlMap files could be specific
of a single database.
The perfect for us
is if we could put all the sqlMap files (commons and database-specific) in
the project, an then have a flag that switch all the application to
use the correct sqlMap files for the underlined database.
Is there a pattern
to achieve it?
Thanks in advance
(and sorry for my english)
Davide.