Connecting to multiple DataBase

I am developing struts application which it has to support to connect multiple databases with out changing the code.

For example, client has his own choice to select a data base(Oracle,SQL Server,My SQL...) code has to support.

please provide the code or any link or clue for this

bye.

This doesn't really have anything to do with Struts, but with how you're accessing the database in the first place.

Unless you're using an ORM, you're going to have issues.

Without using DAO or ORM tools is it possible. like can we go using Resource Properties file

I do not know if you've considered the possibility of using and combining spring with hibernate to use multiple datasource

How are you doing your queries? Do you need to generate new database rows that would need a unique ID? How would you overcome SQL differences?

I'm moving this to JDBC.

How would you overcome SQL differences?

Yep. That is an important question - that.

Depending on whether you are dealing with the same tables / queries the answers vary.

V. Chenna, please do not crosspost:

Crosspost of this Question