posted 18 years ago
Hi,
I am using Websphere 5.1v.My application connects with sql database.I have closed all the connections that i have opened. But the problem is i use a scheduler whose task is to fetch data thrice a day from the database.
Would those scheduler connections be active all time?
My DSN settings are Max Connections -15 Min Connections-1
Every sixth day i get ConnectionWaitTimeoutException.i.e the first five days it holds the connections active such that 5*3=15 which results in the exception on sixth day. I always want my scheduler to be active to perform its daily task
Can i set MAX Connections to zero which would result in infinte physical connections. would there be any performance issue?
Help me out plz.
Thanks in advance