Hi,

I am current using jdbc adapter service to insert parts of xml structure into different tables of the same database.The data from a single document type goes into around 10 tables.There are around 15 different document types and hence the number of adapter services created for insert is getting too large.I want to know which is the best way of handling this situation.Creating insert adapter for each table is the way which is followed right now.I am also considering writing pl/sql procedure and passing the xml as a whole to it for processing.Any help on the best practice/approach is much appreciated.

Thanks

IMHO, if you’re having to deal with 10 tables, you’re doing too much from an integration layer perspective. Applications should provide APIs or interfaces which encapsulate its internal components. In this scenario, I’d go with the stored procedure. You will probably even see a performance increase due to the stored proc being pre-compiled on the database’s side.

• Percio

Hi,
Thanks for the response.I have decided to write a pl/sql procedure as you had mentioned and pass the whole xml to it.

Thanks