Hi Michael,
Cayenne will detect the database type automatically on startup and use
the right adapter. So yes, use JNDI to abstract connection
information, beyond that no need for any extra tricks. You generic
Cayenne mapping will just work regardless of the db type.
Andrus
On Oct 20, 2008, at 11:42 AM, Michael Shea wrote:
> Hi guys,
>
> I am working on a project in which I have to support multiple
> database types. They do not have to be supported simultaneously - I
> need my program to be able to run whether I am using an Oracle
> database or a MySQL database (the databases will have the same
> schema), but the database type does not change at runtime.
>
> I am wondering if there are any best practices or recommendations
> for how to approach this problem. Currently, I am planning on simply
> creating two sets of cayenne configuration files in different
> directories (ie, a map.xml and a cayenne.xml file), and just adding
> one or the other of these directories to the classpath, depending on
> some initial configuration parameters that tell me what type of
> database I'm accessing. The datasource is defined via JNDI.
>
> Does anyone think that this is a good idea or a bad idea, or have a
> better way of doing this? =) I am using Cayenne 2.0.4.
>
> Thanks!
>
>
> Mike Shea.
>
This archive was generated by hypermail 2.0.0 : Mon Oct 20 2008 - 11:47:21 EDT