You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by Hebeisen Andy <an...@softline-intra.ch> on 2001/04/19 22:58:32 UTC

Fw: Torque from CVS and Oracle Sequences

Hi again

I posted following email few days ago and I didn't got an answer.
Therefore I try it now on the dev-list.
Maybe my english is too bad, sorry...

I tried the same scenario today and nothing changed. With the
same input files and torque from the latest TDK it is OK.
But the current CVS-build seems not to be... I just want
to make shure, that you miss nothing for the next TDK-build
or Turbine-release.

Thanks 
Andy


Andy Hebeisen
softline intra
CH-8472 Seuzach
andy.hebeisen@softline-intra.ch

----- Original Message ----- 
From: "Hebeisen Andy" <an...@softline-intra.ch>
To: "Turbine User List" <tu...@jakarta.apache.org>
Sent: Tuesday, April 10, 2001 10:56 PM
Subject: Torque from CVS and Oracle Sequences


> 
> Hi there
> 
> First of all I have to say that Turbine is just great.
> Thank you all for your great job.
> 
> Today I checked out the actual CVS-tree and build
> turbine and torque. After some changes everything
> works fine. Then I rebuild my OM with torque for
> my Oracle-DB and this is the result:
> 
> Every "TableNameMapBuilder.java" file has not
> set the following line correctly:
> >>> tMap.setPrimaryKeyMethodInfo("$imp.Value");
>     instead of this it should be
> >>> tMap.setPrimaryKeyMethodInfo("SEQ_Company");
> 
> My project-schema.XML looks like this, which worked fine yet:
> 
> <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
> <!DOCTYPE database SYSTEM "dtd/database.dtd">
> <!--
>   <!DOCTYPE database SYSTEM
> "http://java.apache.org/turbine/dtd/database.dtd">
> -->
> <database>
> <table idMethod="sequence" name="T_Company">
>     <column name="Company_ID" primaryKey="true" required="true"
> type="INTEGER"/>
>     <column name="Country_FK" required="true" type="VARCHAR"/>
>     <column name="Company" required="true" type="VARCHAR"/>
>     <column name="Address1" required="false" type="VARCHAR"/>
>     <column name="Address2" required="false" type="VARCHAR"/>
>     <column name="ZipCode" required="false" type="VARCHAR"/>
>     <column name="Location" required="true" type="VARCHAR"/>
>     <column name="CompanyURL" required="false" type="VARCHAR"/>
>     <column name="Fax" required="false" type="VARCHAR"/>
>     <column name="Telefon" required="false" type="VARCHAR"/>
>     <column name="Email" required="false" type="VARCHAR"/>
>     <foreign-key foreignTable="T_Country">
>         <reference local="Country_FK" foreign="CO_A2"/>
>     </foreign-key>
>     <id-method-parameter value="SEQ_Company"/>
> </table>
> </database>
> 
> I switched to local DTD like you can see above, but that changed nothing.
> 
> Maybe it's a bug or a change in Torque that I miss?
> Thanks in advance for your help.
> 
> 
> Andy Hebeisen
> softline intra
> CH-8472 Seuzach
> andy.hebeisen@softline-intra.ch
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org


Re: Fw: Torque from CVS and Oracle Sequences

Posted by John McNally <jm...@collab.net>.
fixed (just now) in cvs.

Hebeisen Andy wrote:
> 
> Hi again
> 
> I posted following email few days ago and I didn't got an answer.
> Therefore I try it now on the dev-list.
> Maybe my english is too bad, sorry...
> 
> I tried the same scenario today and nothing changed. With the
> same input files and torque from the latest TDK it is OK.
> But the current CVS-build seems not to be... I just want
> to make shure, that you miss nothing for the next TDK-build
> or Turbine-release.
> 
> Thanks
> Andy
> 
> Andy Hebeisen
> softline intra
> CH-8472 Seuzach
> andy.hebeisen@softline-intra.ch
> 
> ----- Original Message -----
> From: "Hebeisen Andy" <an...@softline-intra.ch>
> To: "Turbine User List" <tu...@jakarta.apache.org>
> Sent: Tuesday, April 10, 2001 10:56 PM
> Subject: Torque from CVS and Oracle Sequences
> 
> >
> > Hi there
> >
> > First of all I have to say that Turbine is just great.
> > Thank you all for your great job.
> >
> > Today I checked out the actual CVS-tree and build
> > turbine and torque. After some changes everything
> > works fine. Then I rebuild my OM with torque for
> > my Oracle-DB and this is the result:
> >
> > Every "TableNameMapBuilder.java" file has not
> > set the following line correctly:
> > >>> tMap.setPrimaryKeyMethodInfo("$imp.Value");
> >     instead of this it should be
> > >>> tMap.setPrimaryKeyMethodInfo("SEQ_Company");
> >
> > My project-schema.XML looks like this, which worked fine yet:
> >
> > <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
> > <!DOCTYPE database SYSTEM "dtd/database.dtd">
> > <!--
> >   <!DOCTYPE database SYSTEM
> > "http://java.apache.org/turbine/dtd/database.dtd">
> > -->
> > <database>
> > <table idMethod="sequence" name="T_Company">
> >     <column name="Company_ID" primaryKey="true" required="true"
> > type="INTEGER"/>
> >     <column name="Country_FK" required="true" type="VARCHAR"/>
> >     <column name="Company" required="true" type="VARCHAR"/>
> >     <column name="Address1" required="false" type="VARCHAR"/>
> >     <column name="Address2" required="false" type="VARCHAR"/>
> >     <column name="ZipCode" required="false" type="VARCHAR"/>
> >     <column name="Location" required="true" type="VARCHAR"/>
> >     <column name="CompanyURL" required="false" type="VARCHAR"/>
> >     <column name="Fax" required="false" type="VARCHAR"/>
> >     <column name="Telefon" required="false" type="VARCHAR"/>
> >     <column name="Email" required="false" type="VARCHAR"/>
> >     <foreign-key foreignTable="T_Country">
> >         <reference local="Country_FK" foreign="CO_A2"/>
> >     </foreign-key>
> >     <id-method-parameter value="SEQ_Company"/>
> > </table>
> > </database>
> >
> > I switched to local DTD like you can see above, but that changed nothing.
> >
> > Maybe it's a bug or a change in Torque that I miss?
> > Thanks in advance for your help.
> >
> >
> > Andy Hebeisen
> > softline intra
> > CH-8472 Seuzach
> > andy.hebeisen@softline-intra.ch
> >
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-dev-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org