How are you connecting to the databases? For the default from the tdk it would be (in Torque.properties):
torque.database.default=newapp torque.database.newapp.adapter=mysql ## Using torque's old pool torque.dsfactory.newapp.factory=org.apache.torque.dsfactory.TorqueDataSource Factory torque.dsfactory.newapp.pool.defaultMaxConnections=10 torque.dsfactory.newapp.pool.maxExpiryTime=3600 torque.dsfactory.newapp.pool.connectionWaitTimeout=10 torque.dsfactory.newapp.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.newapp.connection.url = jdbc:mysql://host1/newapp torque.dsfactory.newapp.connection.user = root1 torque.dsfactory.newapp.connection.password = root1 torque.database.newapp2=newapp2 torque.database.newapp.adapter=mysql ## Using torque's old pool torque.dsfactory.newapp2.factory=org.apache.torque.dsfactory.TorqueDataSourc eFactory torque.dsfactory.newapp2.pool.defaultMaxConnections=10 torque.dsfactory.newapp2.pool.maxExpiryTime=3600 torque.dsfactory.newapp2.pool.connectionWaitTimeout=10 torque.dsfactory.newapp2.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.newapp2.connection.url = jdbc:mysql://host2/newapp torque.dsfactory.newapp2.connection.user = root2 torque.dsfactory.newapp2.connection.password = root2 torque.database.newapp3=newapp3 torque.database.newapp3.adapter=mysql ## Using torque's old pool torque.dsfactory.newapp3.factory=org.apache.torque.dsfactory.TorqueDataSourc eFactory torque.dsfactory.newapp3.pool.defaultMaxConnections=10 torque.dsfactory.newapp3.pool.maxExpiryTime=3600 torque.dsfactory.newapp3.pool.connectionWaitTimeout=10 torque.dsfactory.newapp3.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.newapp3.connection.url = jdbc:mysql://host3/newapp torque.dsfactory.newapp3.connection.user = root3 torque.dsfactory.newapp3.connection.password = root3 Of course this changes depending on your choice of connection method. Good luck, David -----Original Message----- From: Ilan Azbel [mailto:[EMAIL PROTECTED] Sent: Tuesday May 18, 2004 6:58 AM To: Turbine Users List Subject: Multiple DB connections Hello, I have a requirement that my web app connects to 3 different databases, all residing on different servers. How can this be achieved? Ilan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
