JSRP Throws Java.Sql.Sqlexception: Jz0s2: Statement Object Has Already Been Closed (Doc ID 861179.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Communications ASAP - Version 5.2.4 to 7.0.1 [Release 5.2 to 7.0.0]
Information in this document applies to any platform.
***Checked for relevance on 3-MAR-2015***
***Check on Currency on Feb-2-2017***

Symptoms

Weblogic logged the following errors:

<Error> <JDBC> <BEA-001112> <Test "ping" set up for pool
"System.CIT1.ApplicationType.ServiceActivation.Application.1-0;5-2;ASAP.Comp.RPCConnectionPool" failed with exception:
"java.sql.SQLException: JZ0S2: Statement object has already been closed.".>
refresh xa conn with {url=jdbc:sybase:Tds:in1awiasap01:40000, serverName=in1awiasap01,
dataSourceName=System.CIT1.ApplicationType.ServiceActivation.Application.1-0;5-2;ASAP.Comp.RPCConnectionPool, user=sarmCIT1,networkProto =Tds, databaseName=SARM
CIT1, password=sarmCIT1, portNumber=40000, USE_METADATA=false}

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms