Connecting to multiple DataBase

[v chenna]

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.

[David Newton]

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.

[v chenna]

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

[Ernesto Chicas]

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

[David Newton]

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.

[Deepak Bala]

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.

[Cameron Wallace McKenzie]

V. Chenna, please do not crosspost:

Crosspost of this Question