How do you specify you want only the tables for a given user? When I ran it I got the whole instance, a somewhat slow operation!
Regards, Glen Stampoultzis [EMAIL PROTECTED] Phone: +61 3 9753 6850 Mobile: 0402 835 458 ICQ: 62722370 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 10:32 PM To: Turbine Users List Subject: Re: TorqueJDBCTransformTask problems please grab jakarta-turbine-torque from cvs and give it a try (the generated xml is compatible to 2.1 so you can use torque-3.0dev for the Transform job) in 3.0dev you can define a schema for oracle ;-) martin Quoting "Dudgeon, Tim" <[EMAIL PROTECTED]>: > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
