We have a product used by two customers. One of them is using MySQL and the other is using SQL Server.

We deliver them a all included war file for each new version of our application.

At the moment we need to build 2 wars. One for each database type. The only different in both is the xml description of the database type and other connection settings. (other dataSource) . There is a dataSource bean created with Spring.

Is it possoble to create a single war what we can use on both application servers? How do we do that?

Maybe it is possible to put a database connection descriptor (XML) outside the WAR project en put them manually on the root of the application servers shared dir?

Any examples?

Thanks!

-----------------------------------------

I've found a solution by myself. You can define a xml location in the web.xml outside the framework.

You could easily do this, and just have the appropriate dialect loaded based on a property file configuration, or heck, even a catch block!