I'm trying to pick up an existing database schema using
TorqueJDBCTransformTask, but I and having problems.
Firstly there is no ant task to do this (I seem to remember there used to be
one somewhere), so I'm having to reverse engineer this and maybe haven't got
it quite right. I've added the following taskdef
<taskdef name="jdbc-xml"
classname="org.apache.turbine.torque.TorqueJDBCTransformTask">
<classpath refid="classpath"/>
</taskdef>
and the following target
<target name="jdbc2xml" depends="init-tasks">
<jdbc-xml
dbDriver="${databaseDriver}"
dbUrl="${databaseUrl}"
dbUser="${databaseUser}"
dbPassword="${databasePassword}"
outputFile="schema/schema.xml"
/>
</target>
These seem to work and give me schema.xml output file.
However this file seems to have two problems. Firstly the column types are
missing e.g.
<table name="MD$DICTVER">
<column name="MD_DICTIONARY_VERSION_C" size="30" type=""/>
<column name="MD_DICTIONARY_VERSION_N" type=""/>
</table>
This happens when connecting to Oracle or MySQL.
And secondly, when connecting to Oracle (which has foreign keys, MySQL
doesn't so not relevent here), Foreign key constraits are not picked up and
added to schema.xml.
Am I doing something wrong here, or is Torque?
I'm using the Torque-2.1 binary release.
Many thanks
Tim
--------------------------------------------
Dr. Tim Dudgeon
OSI Pharmaceuticals, Watlington Road, Oxford, OX4 6LT, UK
Tel: +44 (01865) 780800
email: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
