db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mark kummerer" <mkumme...@airtransportit.com>
Subject RE: Sequence names
Date Tue, 04 Mar 2003 13:22:45 GMT
I have found using the statement 
 <id-method-parameter value = "TROUBLE_NUM" /> 
forces torque to use the sequence named "TROUBLE_NUM"  instead of
"TROUBLE_SEQ" for an Oracle database.

    </table>
    <table name="TROUBLE"
    idMethod = "native">
        <column name="TROUBLE_ID" primaryKey="true" required="true"
            size="38" type="DECIMAL"/>
        <id-method-parameter value = "TROUBLE_NUM" />

Mark 

-----Original Message-----
From: Phil R Lawrence [mailto:prlawrence@Lehigh.EDU] 
Sent: Monday, March 03, 2003 9:03 AM
To: Turbine Torque Users List
Subject: Re: Sequence names


Quinton McCombs wrote:
 > Alexander Rau wrote:
 >>does anyone know who Torque finds out the name of the sequence for a
>>primary key in a table?  >
> It uses the table name and apends "_SEQ" to the end.

Is this supposition configurable or overrideable?  I know our ERP does 
not follow this "table_name_SEQ" naming convention...

Thanks,
Phil R Lawrence


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org



Mime
View raw message