Re: Switching databases

2010-03-24 Thread Michael Gentry
l my own generator?  Is there more detailed documentation on > that (don't see it on the website)? > > Thanks again. > -Mike > > > > > From: > Andrus Adamchik > To: > user@cayenne.apache.org > Date: > 03/24/2010 08:16 AM > Subject: > Re: Switching

Re: Switching databases

2010-03-24 Thread MGargano
ndrus Adamchik To: user@cayenne.apache.org Date: 03/24/2010 08:16 AM Subject: Re: Switching databases Cayenne project mapping is close to a 100% portable between different DB's as long as the DB's themselves are compatible. I guess the only piece that will need to change is DataNode

Re: Switching databases

2010-03-24 Thread Andrus Adamchik
Cayenne project mapping is close to a 100% portable between different DB's as long as the DB's themselves are compatible. I guess the only piece that will need to change is DataNode connection info (and this can be delegated to container by using JNDI node). Now specific items: 1. DbAdapte

Re: Switching databases

2010-03-23 Thread Michael Gentry
You probably have a few options. The DataMap part of the model could mostly be reused. You could programatically create a DataNode (for your DB connection) and attach it to the DataMap or you could create the DataNode in the modeler and programatically adjust the settings in it. As for the PKs,

Switching databases

2010-03-23 Thread MGargano
Hi, I'm looking into using Cayenne as a backend ORM technology replacing hibernate. Currently our product supports multiple DBMSes (SQL Server, Oracle, DB2) depending on what the client already has installed. In hibernate when switching between oracle and sql server, for example, is j