db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a.wahh...@free.fr
Subject primary key of 3 columns
Date Wed, 22 Sep 2004 14:03:14 GMT
Hi

I have a primary key of 3 columns, and one of these column is sequence
my problem is how to insert explicitly data in sequence without auto generation
it's no problem with insertion by auto generation

my schema :
        <column javaName="col1" name="col1"
        required="true" size="10" type="DECIMAL"/>
        <column javaName="col2" name="col2" primaryKey="true"
            required="true" size="10" type="DECIMAL"/>
        <column javaName="col3" name="col3"
        required="true" type="TIMESTAMP" />
    <id-method-parameter name="SEQ" value="SEQ"/>

		<unique name="PK">
			<unique-column name="col1"/>
			<unique-column name="col2"/>
			<unique-column name="col3"/>
		</unique>

thanks

---------------------------------------------------------------------
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