This content has been marked as final. Show 4 replies
I'm double checking with the team what is the wrappedData.getConnection.close() for. However, from what I've seen the login and logout parts are made by E-Business Suite so something like
logoutUrl =(APPS_SERVLET_AGENT).append("/OALogout.jsp?menu=Y"); should close down everything.
Let me check internally and I'll update the thread.
The goal is to use the connection just for the request-response, and not have it be locked specifically to just one user... that way a pool of 20 connections could support several hundred simultaneous users.
I'm double-checking my code to make sure I don't have any un-closed ResultSets or CallableStatements...
I found one CallableStatement that I forgot to close. Also, to optimize the connection pool I had to set these flags:
jbo.doconnectionpooling = true
jbo.txn.disconnect_level = 1.
Thanks go to Andrejus:
Glad to hear that.