Re: AW: Multiple Databases within the same application

I'm not sure that c-jdbc does what you're wanting.  Isn't it more of a 
load-balancer?

It's a pretty neat piece of software though! 




Please respond to user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]
Sent by:        user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org
To:     <user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]>
cc:      

Subject:        AW: [Keel User] 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 
_______________________________________________
User mailing list
[email protected]
http://lists.keelframework.org/listinfo.cgi/user-keelframework.org