With reference to above posts -
Earlier i thought that these errors might be due to change in the database (from oracle 8i to oracle 10g ), but now we are getting the 'closed connection' and 'closed statement' errors irrepective of the database (oracle 8i or Oracle 10G) .
In the main service on IS -
i check for database connectivity using pub.db:connect,
if its connected -
i use execSQL to insert and catch any error during SQL insert.
if not connected - then catch it separately.
i’m properly closing the db connections on right places
The strange part is that Closed connection error is getting caught when it tries to execute execSQL (which means that it has already checked for the database connection).
i tried varying minimum connections , maximum connections and expiration time in DB Alias Settings but errors still persists.
Then I tried another thing
I stopped checking for the database connectivity and directly used execSQL , still no success.
Your input will be highly appreciable.