# Problems with Oracle -\> XML metadata -\> DB2 - addForeignKeyConstraint with more than 1 column

**URL:** <https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811>\
**Category:** General Discussion\
**Created:** [January 25, 2012, 11:46pm UTC](https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811 "2012-01-25T23:46:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [January 25, 2012, 11:46pm UTC](https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811/1 "2012-01-25T23:46:00Z")

</div>

The trouble is that multi-column FKs are not handled well by the diff code regardless of the database type. Improvements to diff (including multi-column FKs) are the focus of the next release which I’m hoping to have an initial beta of within a week or two.

Nathan

---

<div class="post-metadata">

**Author:** ![mmorin1](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@mmorin1](https://forum.liquibase.org/u/mmorin1)\
**Post date:** [January 25, 2012, 11:46pm UTC](https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811/2 "2012-01-25T23:46:00Z")

</div>

Nathan,

Thanks for the response.

In the meantime (while you work on the beta), any workarounds you can suggest for my multi-column FKs problem?

---

<div class="post-metadata">

**Author:** ![mmorin1](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@mmorin1](https://forum.liquibase.org/u/mmorin1)\
**Post date:** [January 25, 2012, 11:46pm UTC](https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811/3 "2012-01-25T23:46:00Z")

</div>

Thanks

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [January 25, 2012, 11:46pm UTC](https://forum.liquibase.org/t/problems-with-oracle-xml-metadata-db2-addforeignkeyconstraint-with-more-than-1-column/1811/4 "2012-01-25T23:46:00Z")

</div>

I’m not sure I know of any workarounds off hand besides manually updating the generated XML based on how you know it should be. I’m not sure how you are using the diff to know how do-able that is.

Nathan