I set up a data source to a SQL Server database in WL 10.3.5. I have 2
java programs that use
JDBC to query the database every 3 minutes. I close all connections in my java programs using JDBC.
I noticed the Current Active Connection value is pretty high. Leaked connections are 0. After a few days, I've gotta Out Of Memory and I had to restart the server.
I did not make changes to any settings when I set up the data source like Connection Timeout or others? What settings should I change please? And what values should I give them?
Thanks