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:
<!-- parent_id>Generated runtime by a trigger and sequence</parent_id> -->
My conclusion was to refactory my DB schema into a flat table. it would have not been possible with a more complex schema, but in anycase, I am not really impressed by th JCA DB adator, I'd have expected some kind of integration with JPA as well.