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

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-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org