Multiple database mappings in one EAR file

[gzus]

Hello

As it is now we build one ear file to support each database (MySQL, PostgreSQL, MSSQL) we support. This is done because we have three different jbosscmp-jdbc.xml file, for each of these database.

Now I wish to make one ear file which support all three database connections. But how do I handle these jbosscmp-jdbc.xml files ?

Please help

/Morten Nielsen

[yong_jiao]

I didn't do such a deployment before. However based on my understanding, you can have 2 options:
(1)make 3 ejb jar files each of which has its own jbosscmp-jdbc.xml.
(2)Or if all your ejb are in one jar file, you need to specify the "datesource" for each in the only jbosscmp-jdbc.xml

[gzus]

It is the same EJB, just with support for different databases.

In the three jbosscmp-jdbc I have different mappings for each of the databases. This is for the different datatypes, i.e. TEXT/MEDIUMTEXT etc.

There are no way use several of these CMP mappings for each datasource ?