We have upgraded our OAAdapter from 3.0 to 6.0 and after the upgrade we are getting the following error which we never got while we were using 3.0 OAAdapter :
ART.117.4000] Adapter Runtime (Adapter Service): Unable to invoke adapter service upgrade.S711OAHR1158.Acknowledge.EmployeeTrueComp:ackEmployeeDataOut. Unable to establish connection to connection S711ISConfiguration.JDBCAdapters.OracleraCon. [ART.117.4011] Adapter Runtime (Adapter Service): Unable to connect to resource S711ISConfiguration.JDBCAdapters.OracleraCon. The resource is already being used in a parent transaction.
We got rid of this problem by explicitly commiting the transaction i.e
Using the startTransaction and commitTransaction around the service(where we are either inserting the data in the Database or updating).
But the thing with that is we have too many interfaces and we have to touch all of them and make the change where ever we are connecting to the database which is a big hassle and not a good way to fix the problem.
I just wanted to know if anybody came across with this kind of issue and solved it by having a different and more better approach.
P.S Even if we select anything we have to commit the transaction.
Any help will be appreciated