You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by a....@free.fr on 2004/09/22 16:03:14 UTC

primary key of 3 columns

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