Oracle Retail Allocation - Datasource Won't Release Connections
Hello,
We are having intermittent issues with our Oracle Retail Allocation application. Yesterday the application was stuck and wouldn't allow users to log in. Upon further investigation it appears that the connection pool only had one open connection that was stuck processing.
Is there a setting within the Weblogic Server or within the allocation.properties where we can set the connection pool to release the connection if stuck after x amount of time?
Please advise.
Thank you.