We are using execSQL service of B2B server to access TN Translation Tables from Oracle. We are using Oracle JDBC driver. It throws an SQL Exception: Connection closed/Null PointerException for an incoming document from a partner. However when we submit the same document from TN again, it just goes through. We are not able to regenerate the error.
Moreove, there is another application accessing TN db thru Sequelink driver… it works fine.
N/w issues are not there as the webmethods server/TN and db are on the same machine.
We are using execSQL service multiple times in the application. Error occurs at least at 2 places
All we can think of is as reasons for hte db connection error are:
- Is there any know issues with webmethods builtin java service execSQL?
- Are there any steps to be performed while useing execSQL? I mean, do we need to specifically destroy/create some variables in the pipeline after accessing the db ( like results)?
- Is this anything to do with connection pooling? we have nto enabled connection pooling for Oracle JDBC Server.
Valuable Suggestions are appreciated.
Thanks and Regards,