Hi, One pool = one database. It's not a Tomcat limitation per se, it's a limitation of the connection pool implementation (I'm guessing you use DBCP), which in turn comes from the way javax.sql is designed.
However, you can define as many pools as you want in Tomcat, so just define one for each DB. Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Michael J. Makunas [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 16, 2004 2:25 AM >To: [EMAIL PROTECTED] >Subject: Connection pooling and multiple dbs > >I currently have a system where we're using Tomcat's db connection >pooling (with MySql). We're still having db performance issues so we're >considering having multiple instances of our db. Is there a way to set >up Tomcat to use a pool that connects to multiple dbs (assuming, for >now, that keeping db instances in sync isn't a problem)? > >-Michael > >-- >** Michael J. Makunas ** http://www.makunas.com/ ** > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
