1 Reply Latest reply on Mar 18, 2013 2:41 PM by Alessandro I

    JCA DB insert on 2 tables with foreign keys

    Alessandro I
      Hi there,
      I am using the DB JCA adaptor in OSB for making an insert of an XML in 2 tables. One of the table has a foreign key pointing to the other, problem is, when the insert is made the field is left empty. In a normal java code I would have used JPA or simply performed a set of statements within a transaction. But how does it work in the JCA DB adapt?
      My xml looks like:

      <parentCollection>
      <parent_table>
      <!-- parent_id>Generated runtime by a trigger and sequence</parent_id> -->
      <child_table>
      <parent_fk></parent_fk>
      </child_table>
      </parent_table>
      </parentCollection>

      Thanks in advance
      Alessandro