Connection Closed Error

, ,
1

1 . Recently we are getting some errors for the Adapters as(JDBC) :
(17008) Closed Connection"
Closed Connection in Service : .
Though on checking on the Admin screen it was found that the connection was up , no error poped up
when we re-stared the connection . The data base was up .
But running the adapter service gave connection closed error .
Above error was kind of transient … after some time we were able to successfully run the adapter service.
2 . Another problem :
Tried to create an notification service same server another Connection(JDBC), it gave error as :
Failed to run notificationLookupValues service. Details provided in error log.
[ADA.1.318] Cannot get the list of catalogs. "
(17008) Closed Connection"
Closed Connection
on tables.catalogName [Ljava.lang.String;@f55600

java.lang.Exception: Adapter values are not available.

Above two things were working fine till some time back .
we already have a notification created for the 2nd problem earlier.
Recently seen this problem , for things working fine earlier.
Can some on help , as what is the cause of the problem.

Our Server configuration :
We are using wM version 6.5 for IS with following fixes :
IS_6-5_Fix4
IS_6-5_Fix7
IS_6-5_Fix12
IS_6-5_Fix14
IS_6-5_Fix22
IS_6-5_Fix27
IS_6-5_Fix30
IS_6-5_Fix31
IS_6-5_Fix32
IS_6-5_Fix35
TNS_6-5_Fix3
TNS_6-5_Fix10
TNS_6-5_Fix11
TNS_6-5_Fix15
IS_6-5_Fix61
and using JDBC Version 6.0.3 with update as : JDBC_6-0-3_FP1_Fix10.

Thanks

2

few more error , for another connection :
SIZE=2 Invalid state, the Connection object is closed."
Invalid state, the Connection object is closed. in Service

Is anybody having clue about all above

Thanks.
[/size]

3

What is your Minimum Pool Size set to?

When Minimum Pool Size is set to something other than zero, you may end up with stale connections in your pool if you lose connectivity to the database for whatever reason. Therefore, check your Minimum Pool Size and if it is anything other than zero, set it to zero.

  • Percio