I see that you have configured 3 different application?!?! Can all three connections be used from one application?
How would I get ant to generate the class files necessary for accessing the three different database from one application? > -----Original Message----- > From: David Demner [mailto:[EMAIL PROTECTED] > Sent: 18 May 2004 05:37 > To: 'Turbine Users List' > Subject: RE: Multiple DB connections > > > 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.Torque > DataSource > 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.Torqu > eDataSourc > 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.Torqu > eDataSourc > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
