I'd like to get some ideas on best object design for using multiple dbs
e.e. Oracle and Sybase. In the past I've only done some re-writing of
apps to point at either DB and just did some and then use a case
statement, looked at the JDBC driver class name. If it had the word
Sybase in it I did one thing and if it had Oracle in it I did another.
When I start the app I use parameters which tell it the URL for the DB
and which driver to use.
I could use one DB object for each database but I think that would get
unweildy with at lesat 2 methods for each object with whose data is
inthe db, e.g. customer, invoice, line item.
I could write one object for each database so I'd have a sybaseCustomer,
Then were do you make the decision? Do I use and object factory that
knows about which of the two to use?
Just looking for advice fromthose that have been down the road before.