Multiple Transactions in single Web service

Hi,

I need to expose a java webservice. scenario is we need to persist some data into database and pull the data and send to external system. here we are using jdbc statments to insert and oracle toplink to read the data (this is existing functionality which cant be changed). am facing problem in inserting the data into db, as its inserting up on completion of the transaction(exit of method) but not on completion of jdbc statement query.execute(), due to this when i am trying to read the data, its throwing exception

Please help in resolving the issue

Use explicit transaction management. Refer to the JDBC Adapter User’s Guide for information.