ALDSP 2.5 - How To Use Custom User-Transaction In Aldsp

(Doc ID 820193.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Data Service Integrator (ODSI) - Version 2.5 and later
Information in this document applies to any platform.
***Checked for relevance on 02-June-2014***

Symptoms

You are trying to insert rows into oracle table using a physical data service -> java code and
you are getting the transaction timeout error.

Exception:
com.bea.ld.dsmediator.DataServiceException: java.sql.SQLException: Un
expected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back:
Transaction timed out after 33 seconds
BEA1-000FDF95DF2443A130A6
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1604)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1512)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:455)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:410)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:344)
at
com.bea.ld.wrappers.rdb.connections.ConnectionFactory$DataSourceConnectionProvider.getConnection(Con
nectionFactory.java:135)
at
com.bea.ld.wrappers.rdb.connections.ConnectionFactory.getConnection(ConnectionFactory.java:48)
at com.bea.ld.dsmediator.update.JDBCAdaptor.getConnection(JDBCAdaptor.java:380)
at com.bea.ld.dsmediator.update.JDBCAdaptor.save(JDBCAdaptor.java:101)
at com.bea.ld.dsmediator.update.DataServiceMediator.submit(DataServiceMediator.java:528)
at com.bea.ld.dsmediator.update.DataServiceMediator.submit(DataServiceMediator.java:245)
at com.bea.ld.ServerBean.submit(ServerBean.java:529)
at com.bea.ld.Server_ydm4ie_EOImpl.submit(Server_ydm4ie_EOImpl.java:900)
at
com.bea.dsp.dsmediator.client.XmlDataServiceBase.submitInternal(XmlDataServiceBase.java:177)
at com.bea.dsp.dsmediator.client.XmlDataServiceBase.submit(XmlDataServiceBase.java:111)
at
dataservice.tardis.physical.CheckFirmOrphanStatusDml.submit(CheckFirmOrphanStatusDml.java:59)
at uk.gov.fsa.bart.individual.CheckOrphanStatus.firmOrphanStatus(CheckOrphanStatus.java:49)
at
uk.gov.fsa.bart.individual.IndividualFunctions.orphanFirmDetails(IndividualFunctions.java:135)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.ld.wrappers.jf.JavaFunctionIterator.exec(JavaFunctionIterator.java:146)
at com.bea.ld.wrappers.jf.JavaFunctionIterator.fetchNext(JavaFunctionIterator.java:211)
at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
at weblogic.xml.query.runtime.querycide.QueryAssassin.fetchNext(QueryAssassin.java:54)
at weblogic.xml.query.iterators.GenericIterator.peekNext(GenericIterator.java:151)
at weblogic.xml.query.runtime.qname.InsertNamespaces.fetchNext(InsertNamespaces.java:161)
at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:113)
at weblogic.xml.query.runtime.core.QueryIterator.fetchNext(QueryIterator.java:127)
at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:134)

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