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]>
