2547379 - JBOSS connecting to ASE reports "SybConnectionDeadException: JZ0C0: Connection is already closed" - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2547379 - JBOSS connecting to ASE reports "SybConnectionDeadException: JZ0C0: Connection is already closed" - ASE

Symptom

  • JBOSS connecting to ASE reports the following error:

IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.

  • ASE error log reports the following error:

nrpacket: recv, Connection timed out, spid: 423, suid: 1088
00:0010:00000:00000:2017/09/26 21:38:44.64 kernel  extended error information: hostname: <hostname> login: <login>

  • sp_monitorconfig  "number of user connections" shows there are connections available

Name                                Num_free      Num_active            Pct_act       Max_Used      Reuse_cnt      Instance_Name

number of user connection     314                  86                     21.50          309                   0                    [NULL]

  • No errors reported when connecting through isql utility

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.