Hi Ilan, I'm not sure (I've never done it) but theoretically it's yes to all 3.
- You would create the XML file for each of your databases (the XML root being <database name="newappx">). - Then edit your build-torque.xml to call each of the newappx-schema.xml files (by changing the 'sql', 'om', and 'insert-sql' [and maybe other?] targets). You'll can either hardcode the database & server names in your build-torque.xml or create new attributes in the build.properties. - Then run 'ant project-om', 'ant schema-sql', and 'ant insert-sql'. This should create your object model using the appropriate database, the SQL files that will be used to generate your database, and then insert them into the appropriate db. Theoretically that should be it ;) Good luck, David -----Original Message----- From: Ilan Azbel [mailto:[EMAIL PROTECTED] Sent: Friday May 21, 2004 7:54 AM To: Turbine Users List Subject: RE: Multiple DB connections ah, right, got it. thanks. One more question though: Would it be possible to get torque to somehow create an object model for more than one database by somehow configuring the appropriate schema file? If I define multiple schema files it seems to generate all the schema files in one database only. How can I tell it to create different schemas inside different databases? Also, if the above is possible, would it be necessary to explicitly tell torque which database to use when making use of the object model? Ilan > -----Original Message----- > From: David Demner [mailto:[EMAIL PROTECTED] > Sent: 19 May 2004 04:36 > To: 'Turbine Users List' > Subject: RE: Multiple DB connections > > > Sorry for not being clearer. Then all you would do is in your java is: > > java.sql.Connection connNewapp = Torque.getConnection("newapp"); > (or connNewapp = Torque.getConnection() since newapp is the default > connection) > java.sql.Connection connNewapp2 = Torque.getConnection("newapp2"); > java.sql.Connection connNewapp3 = Torque.getConnection("newapp3"); > > This will get a standard java.sql.Connection to the databases > configured in > your Torque.properties (for your one application) even though they are > pointing to 3 different databases. > > David > > -----Original Message----- > From: Ilan Azbel [mailto:[EMAIL PROTECTED] > Sent: Wednesday May 19, 2004 1:26 AM > To: Turbine Users List > Subject: RE: Multiple DB connections > > > 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] > > > --------------------------------------------------------------------- > 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]
