My Oracle Support Banner

Integrations failing with: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Object has been closed (Doc ID 2882210.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

Oracle Integration-OIC - Version 21.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Integrations that use the SQL Server Adapter, and run infrequently are failing with:

[2022-07-08T18:35:29.070Z] [WARNING] [ThreadID: 24600] [Logger: oracle.soa.adapter.db.toplinkall] [SRC Class: org.eclipse.persistence.internal.sessions.AbstractSession; Method: handleException] Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Object has been closed.
Error Code: 0
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicRollbackTransaction(DatabaseAccessor.java:1717)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.rollbackTransaction(DatasourceAccessor.java:688)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.rollbackTransaction(DatabaseAccessor.java:1700)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicRollbackTransaction(AbstractSession.java:841)

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.