Hi everyone,
I have a SOA application connecting to a IBM DB2 database, when the DB is restarted for mantainance I get the following error until I restart the whole application server:
oracle.tip.esb.server.common.exceptions.BusinessEventRetriableException: An unhandled exception has been thrown in the ESB system. The exception reported is: "org.collaxa.thirdparty.apache.wsif.WSIFException: esb:///ESB_Projects/temp_temp_JDEDBAdapter_soaappvrt.amadori.local/JDEDBAdapterUpdate.wsdl [ JDEDBAdapterUpdate_ptt::update(Ammsgofm2Collection) ] - WSIF JCA Execute of operation 'update' failed due to: DBWriteInteractionSpec Execute Failed Exception.
update failed. Descriptor name: [JDEDBAdapterUpdate.Ammsgofm2]. [Caused by: [oias][DB2 JDBC Driver]Broken pipe]
; nested exception is:
ORABPEL-11616
DBWriteInteractionSpec Execute Failed Exception.
update failed. Descriptor name: [JDEDBAdapterUpdate.Ammsgofm2]. [Caused by: [oias][DB2 JDBC Driver]Broken pipe]
Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.3.0) (Build 070608)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [oias][DB2 JDBC Driver]Broken pipeError Code: 0
Call:UPDATE PRODSYCOM.AMMSGOFM SET AMETATMSG = ? WHERE ((AMAPPLI = ?) AND (AMDOCO = ?))
bind => [2, AMAJDE, 668704]
Query:UpdateObjectQuery(<Ammsgofm2 AMAJDE 668704 />).
at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:633)
at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeInputOnlyOperation(WSIFOperation_JCA.java:736)
at oracle.tip.esb.server.common.wsif.WSIFInvoker.executeOperation(WSIFInvoker.java:865)
at oracle.tip.esb.server.common.wsif.WSIFInvoker.nextService(WSIFInvoker.java:781)
at oracle.tip.esb.server.common.wsif.WSIFInvoker.nextService(WSIFInvoker.java:801)
...
My application is an Oracle ESB flow running over Oracle SOA Suite 10.1.3.4, the flow uses the data source showed below:
<managed-data-source connection-pool-name="AMAJDE_POOL" jndi-name="jdbc/AmajdeDataSource" name="AMAJDE_DATA_SOURCE" />
and here is the connection pool:
<connection-factory factory-class="com.oracle.ias.jdbc.db2.DB2Driver" user="*******" password="*******" url="jdbc:oracle:db2://******:446;LocationName=******;PackageName=*****;" commit-record-table-name="">
<fatal-error-codes>
<error-code code="3113" />
<error-code code="3114" />
<error-code code="1033" />
<error-code code="1034" />
<error-code code="1089" />
<error-code code="1090" />
<error-code code="4068" />
<error-code code="28" />
<error-code code="3135" />
<error-code code="12537" />
<error-code code="12547" />
<error-code code="12560" />
<error-code code="12570" />
<error-code code="12571" />
<error-code code="17002" />
<error-code code="17430" />
<error-code code="17002" />
<error-code code="17008" />
<error-code code="17009" />
<error-code code="17010" />
<error-code code="17410" />
</fatal-error-codes>
</connection-factory>
</connection-pool>
Any of you have an advise to solve the problem, I just need a way to make the connection pool clean itself when I receive this error.
Thanks In advance,
Lisa