Best practice to support multiple database vendors (DB2 or MSSQL Server)

[Francois Eyl]

Hi guys,

I'm using Cayenne on my project in order to interface it with a third 
party application through its database. Until now, the database was a 
DB2 (AS400), but the application now supports MS SQL Server as well. So, 
I need to support both DB2 and MSSQL Server of course. The databases 
schemas are stricly the same.

I wonder what is the best way to achieve this, knowing that I already 
have my datamap & datanode ready for DB2. I'd like to avoid redefining 
ObjectEntities by implementation (one set of data for DB2 and another 
for SQLServer). How do you recommand me to proceed?

Do I need to create an other DataDomain, and "duplicate" the definition 
stuff?

Thanks in advance,
Francois