On 12/19/05, Vamsi Atluri <[EMAIL PROTECTED]> wrote: > CREATE TABLE A ( > A_ID INTEGER NOT NULL, > B_ID INTEGER, > X_ID INTEGER, > Y_ID INTEGER, > A_NAME VARCHAR (40), > CONSTRAINT A_PK PRIMARY KEY (A_ID), > CONSTRAINT A_FK1 FOREIGN KEY (B_ID, X_ID, Y_ID) > REFERENCES B (B_ID, X_ID, Y_ID) > ); > > CREATE TABLE B ( > B_ID INTEGER INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY( START > WITH 1, > INCREMENT BY 1, NO CACHE), > X_ID NOT NULL, > Y_ID NOT NULL, > B_NAME VARCHAR (40), > CONSTRAINT B_PK PRIMARY KEY (B_ID, X_ID, Y_ID) > )
<snip> > <jdbc-connection-descriptor > jcd-alias="OJBDb" > default-connection="true" > platform="Db2" > jdbc-level="1.0" > jndi-datasource-name="jdbc/ojbDataSource" > username="uid" > password="pwd" > batch-mode="false" > useAutoCommit="0" > ignoreAutoCommitExceptions="false"> > <sequence-manager > className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl"> > <attribute attribute-name="grabSize" > attribute-value="1"></attribute> > </sequence-manager> > </jdbc-connection-descriptor> > > <class-descriptor class="A" table="A"> > <field-descriptor name="aId" column="A_ID" primarykey="true" > jdbc-type="INTEGER" /> > <field-descriptor name="bId" column="b_ID" jdbc-type="INTEGER" /> > <field-descriptor name="xId" column="X_ID" jdbc-type="INTEGER" /> > <field-descriptor name="yId" column="Y_ID" jdbc-type="INTEGER" /> > <field-descriptor name="aName" column="A_NAME" jdbc-type="VARCHAR" > length="40" /> > <reference-descriptor name="b" class-ref="B"> > <foreignkey field-ref="bId" /> > <foreignkey field-ref="xId" /> > <foreignkey field-ref="yId" /> > </reference-descriptor> > </class-descriptor> The problem might be that you're using the native sequence manager, but table A has no identity manager. Could you check whether a different sequence manager works ? Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
