RE: Multiple Databases.

[Thiharie Rajesh <Ra...@churchill.com>]

It is best to use the application server connection pool.
Do not use the Jakarta Struts connection pool.

Rajesh

 


-----Original Message-----
If you are using tomcat, then I believe you can use dbcp. (I think that's
what Riyad Kalla was talking about too..) We use dbcp but only for
connecting to one pool (and this turned out to be quite simple: just
configure the server.xml), but I think I read that you can create multiple
pools, which seems to be what you need. (My guess is you add more <Resource
elements in your particular context in the server.xml and give all the db
info in the corresponding ResourceParams.. Like I said, i haven't doene this
with multiple databases, but seems like the machinery is there..

This article contains a link with an example and a "How to tell tomcat to
use dbcp" piece: http://www.midrangeserver.com/mpo/mpo081502-story04.html
And here's a detailed how-to:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html


> -----Original Message-----
> well  that not the problem  but my problem is that i want to
> connect to
> different databases  in my application and i m using 
> datasource object  and
> in my xml file i have given the details of my database
> url,username,password  etc etc. but now i want to connect to another
> database and if in struts-config.xml i give information abt 
> other database
> .but when in my controller when i will give call to my 
> datasource object to
> which database the connection will be made and how can i handle
> it..like if i want to make connection to Database A and after 
> sometime in
> the same file if i want to make connection to DatabaseB how 
> will it work and
> what all changes i will have to make.and where. Pleaseif 
> anybody can provide
> an example it will be very helpfull.

___________________________________________________________________________ 


This email and any attached to it are confidential and intended only for the
individual or entity to which it is addressed.  If you are not the intended
recipient, please let us know by telephoning or emailing the sender.  You
should also delete the email and any attachment from your systems and should
not copy the email or any attachment or disclose their content to any other
person or entity.  The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 

Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org

Struts tiles and html frames.

[br...@tcs.com]

What are advantages of tiles over html frames?

Brati Sankar Ghosh
Tata Consultancy Services
Mailto: brati.sankarghosh@tcs.com
Website: http://www.tcs.com