I had a similary problem with mysql 5.0.27 My problem was that i did
alter table MyTable add foreign key ...
twice. This caused mysql to add the key twice, instead of detecting that
it's already there and do nothing.
And this caused torque to generate the same <foreign-key> twice which
caused problems.
My solution was simply to drop the foreign key. (This caused both keys
to be dropped) and then just added
the foreign key once.
Jim wrote:
Thomas,
The standard process except we are still using Ant to
generate the schema file using the ant command ant -f
build-torque.xml jdbc.
That's it. The file generated has the dup references.
The source is mainframe DB2.
We have not changed anything rcently except moving to
the 3.2 rc2 version of Torque when it became
available. But that is not the issue.
I suspect something is different on the DB2 side but
the dba's say no. And that's probably where the issue
is and I'm hoping someone ran into the same issue and
can give me a clue as to what I can look for to find
the issue.
Jim
--- Thomas Fischer <[EMAIL PROTECTED]> wrote:
Could you please give a short description of what
you do ? I don't have a
clue.
Thomas
Jim <[EMAIL PROTECTED]> schrieb am 06.03.2008
19:22:32:
Hi,
I started running into a duplicate reference in
the
foreign-key issue several months ago in the ant
generated schema.xml file.
We are still using the 3.2 rc2 version of Torque
and
the tables are DB2.
Here is an example of the dup reference..
<foreign-key foreignTable="TABLE2">
<reference foreign="OFFRG_N" local="OFFRG_N"/>
<reference foreign="OFFRG_N" local="OFFRG_N"/>
</foreign-key>
Here is a portion the table that has the
forigh-key..
<table name="TABLE2">
<column name="OFFRG_N" primaryKey="true"
required="true" size="12" type="CHAR"/>
The dba's swear there have been no changes to the
DB2
tables.
Thanks for any suggestions!
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
