for an oracle user? in oracle the user is generally tied to the
schema... or maybe the other way around :) but jdbc does not work that
way, so for oracle you need to specify the schema when you get meta
data.


as maritn said: the torque in CVS uses schema...

On Wed, 2001-12-12 at 18:15, Glen Stampoultzis wrote:
> 
> 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]>



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to