There was a bug in multiple database support that existed from the time that we switched to using the commons connection pool until I fixed it a week or so ago. I am using Torque CVS HEAD with multiple databases successfully.
-Kurt On Mon, 19 Aug 2002, Humberto Hernandez Torres wrote: > I was looking at this problem a couple of weeks ago. It seems to me that the > ant/buld.xml/build.properties method limits torque functionality and it is > very complex. One of the constrains is that you can only have one database > with one database type. I feel it would be needed a more flexible > configuration scheme. > > I would imagine a torque.xml like this. May be something similary to what > they did in Maven with jelly would be great. Sincerly, every time I look at > build-torque.xml I get a headache. And now is much better than it used to > be. > > <torque> > <database-model> > <xml-file>app1-schema.xml</xml-file> > <sql-file>../src/sql/app1-schema.sql</sql-file> > <sqldata-file>../src/sql/app1-data.sql</sqldata-file> > <database>db1</database> > </database-model> > <database-model> > <xml-file>app2-schema.xml</xml-file> > <sql-file>../src/sql/app2-schema.sql</sql-file> > <sqldata-file>../src/sql/app2-data.sql</sqldata-file> > <database>db2</database> > </database-model> > <database name="db1"> > <user>user1</user> > <password>secret</password> > <adapter>DBMM</adapter> > <dbtype>mysql</dbtype> > <sql-idtable>../src/sql/db1-idtable.sql</sql-idtable> > </database> > <database name="db2"> > <user>user2</user> > <password>secret</password> > <adapter>DBMSSQL</adapter> > <dbtype>mssql</dbtype> > <sql-idtable>../src/sql/db2-idtable.sql</sql-idtable> > </database> > </torque> > > If somebody is interested on pursuing something like this, I would be glad > to lend a hand. > > -- > Humberto > > > -----Original Message----- > From: Stephen Haberman [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 2:44 AM > To: 'Turbine Users List' > Subject: RE: how to config tdk2.2 webapp base on multiple database > > > Read the reply I gave you on torque-user list earlier today. Use two > schema files. This will give you two different runtime databases, set > via the TurbineResources.properties. Say dbA and dbB. > > However, as you point out, the build.properties does not have support > for multiple databases (at least not off the top of my head), so instead > do some manual switching of build.properties files or create another > directory so one dir as the dbA build.properties and schema and the > other has the dbB build.properties and schema. > > If all else fails (in my best Jon Stevens impression) "submit a patch." > > :-) > > - Stephen > > > -----Original Message----- > > From: liujie liujie [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 19, 2002 2:37 AM > > To: [EMAIL PROTECTED] > > Subject: how to config tdk2.2 webapp base on multiple database > > > > how to write webapp's build.property sperate om object to multiple > database > > > > > > > > _________________________________________________________________ > > �����������ѽ��н�������ʹ�� MSN Messenger: > > http://messenger.microsoft.com/cn/ > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
