Not sure why, but this bounced when sent to the dev list. Could a dev please
look at this?
-----Original Message-----
From: Russell Smyth
Sent: Wednesday, September 25, 2002 6:36 PM
To: 'OJB Developers List' (E-mail)
Subject: [PATCH] fix for DB2
This patch is needed to generate the test-db for DB2 - it doesnt like trying
to create a foreign key reference to a table that has not been generated
yet!
This patch simply changes the order of RelatedToContract and Contract tables
FYI currently for DB2 you will need to use torque from CVS, plus a few
patches I am submitting to Torque as I write this.. (I will post them here
as well as an interem fix)
Index: src/schema/ojbtest-schema.xml
===================================================================
RCS file: /home/cvspublic/jakarta-ojb/src/schema/ojbtest-schema.xml,v
retrieving revision 1.6
diff -u -r1.6 ojbtest-schema.xml
--- src/schema/ojbtest-schema.xml 31 Jul 2002 19:50:24 -0000 1.6
+++ src/schema/ojbtest-schema.xml 26 Sep 2002 01:28:51 -0000
@@ -221,6 +221,12 @@
<column name="value1" required="false" type="VARCHAR" size="64"/>
<column name="aOid" required="false" type="VARCHAR" size="48"/>
</table>
+ <table name="RelatedToContract">
+ <column name="pk" required="true" primaryKey="true" type="VARCHAR"
size="48"/>
+ <column name="relatedValue1" required="false" type="VARCHAR"
size="64"/>
+ <column name="relatedValue2" required="false" type="INTEGER"/>
+ <column name="relatedValue3" required="false" type="TIMESTAMP"/>
+ </table>
<table name="Contract">
<column name="pk" required="true" primaryKey="true" type="VARCHAR"
size="48"/>
@@ -253,12 +259,6 @@
<reference local="fk_to_version" foreign="pk"/>
</foreign-key>
</table>
- <table name="RelatedToContract">
- <column name="pk" required="true" primaryKey="true" type="VARCHAR"
size="48"/>
- <column name="relatedValue1" required="false" type="VARCHAR"
size="64"/>
- <column name="relatedValue2" required="false" type="INTEGER"/>
- <column name="relatedValue3" required="false" type="TIMESTAMP"/>
- </table>
<table name="MultiMappedTable">
<column name="ID" required="true" primaryKey="true"
type="INTEGER"/>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
