AW: Multiple Databases within the same application

Salut,

I'm also interested in this scenario and it could be done with keel.

Though, another solution would be to use c-jdbc by objectweb. It's a jdbc driver that hides multiple databases behind a single (virtual) database.

Pro:
- it's only jdbc...

Con:
- I think with the persistence service you can only handle ONE database TYPE, i. e. several Oracle instances, but no mix of different database products... BUT: might be possible with a "generic sql" configuration.

I'm going to explore this in the next days... maybe I'll be able to say more about it...

Aleks

-----Ursprüngliche Nachricht-----
Von: Hagerty, Timothy CIV NAVSAFECEN, 52D [mailto:[email protected]]
Gesendet: Dienstag, 23. März 2004 15:52
An: user-keelframework.org-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org
Betreff: [Keel User] Multiple Databases within the same application




Hello All, 
I have a question about multiple database connections. 
I have 3 separate database connections going to 3 different databases. 
When I use the following code: 
PersistentFactory pf = (PersistentFactory) request.getService(PersistentFactory.ROLE, 
                                                request.getDomain());   
I get a connection to the first jdbc connection listed within the merged.config file. 
How do I set one of those connections apart from the other 2 as the default connection when I use the code: request.getDomain()?
Thanks, 
Tim