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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
