java.lang.IllegalStateException: cannot add non-XA Resource to global JTS t

Hi,

I am using JCAPS 5.1.2.

As one of my project requirement I am invoking a jcd from page flow and that jcd uses 2 oracle otd, each oracle otd corresponds to database which resides in two different machines/hosts.

When jcd is invoked from page flow, i got following error,

"java.lang.IllegalStateException: cannot add non-XA Resource to global

JTS transaction."

[#|2007-07-17T19:13:06.209+0530|SEVERE|IS5.1.2|javax.enterprise.resource.resour ceadapter|_ThreadID=17; ThreadName=Worker: 3;stacktrace-id=0;|RAR5029:Unexpected exception while registering component

java.lang.IllegalStateException: cannot add non-XA Resource to global JTS transaction.

at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.enlistResource(J2EET ransactionManagerOpt.java:171)

at com.sun.enterprise.resource.ResourceManagerImpl.registerResource(ResourceManage rImpl.java:97)

at com.sun.enterprise.resource.ResourceManagerImpl.enlistResource(ResourceManagerI mpl.java:71)

at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:14 2)

at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(Conne ctionManagerImpl.java:202)

at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(Connecti onManagerImpl.java:148)

at com.stc.gjc.spi.DataSource.getConnection(DataSource.java:67)

at com.stc.connector.oracleadapter.base.SessionImpl.connect(SessionImpl.java:130)

at com.stc.connector.oracleadapter.OracleSession.open(OracleSession.java:98)

at com.stc.connector.oracleadapter.OracleConnector.open(OracleConnector.java:90)

at com.stc.connector.oracleadapter.appconn.OracleApplicationConnection.<init> ;(OracleApplicationConnection.java:63)

at com.stc.connector.oracleadapter.appconn.OracleApplicationConnection.<init> ;(OracleApplicationConnection.java:50)

at com.stc.connector.oracleadapter.appconn.OracleApplicationConnectionFactory.getC onnection(OracleApplicationConnectionFactory.java:133)

at com.stc.oracle.runtime.ejb.OracleEWayRuntimeHandler.initializeService(OracleEWa yRuntimeHandler.java:256)

Please let me know is there any work around for above problem

Message was edited by:

VenkateshSampoornam

[2317 byte] By [VenkateshSampoornama] at [2007-11-27 10:50:06]
# 1

Hi Venkatesh,

Did you specify XA on the Page Flow level ? The Sun App Server which lies at the core of the Integration Server allows for only one non-XA connection to participate in a global XA transaction.

Also, in the IS's domain.xml is an entry <property name="allow-single-nonXA" value="false"/>, which you can set to true

Good luck

Paul

PaulPetersa at 2007-7-29 11:23:17 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 2

Hi Paul,

Thanks for your reply. I ddidn't specify XA at page

flow level.

But the problem is rectified for me.

I have two jcds in which one of them connects to two different oracle databases for e.g host A and host B.

JCD1 connects to host A and host B[ 2 oracle otds]

JCD2 connects to host B. [single oracle otd]

I had three external applications for each otd

In deployment profile, i connected two external applications to single external system for HOST B.

When i created one more new external system for host b and moved one external application to that.

After then the problem didn't occur again.

null

VenkateshSampoornama at 2007-7-29 11:23:17 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 3

Hi Venkatesh,

Thanks for the update.

i'm a wee bit amazed that such internals start rising to the surface slowly..

Well, anyway, for sake of completeness, i assume you mean Connectivity Map when you mention Deployment Profile ?

Good luck

Paul

PaulPetersa at 2007-7-29 11:23:17 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 4

Hi Paul,

No i mean deployment profile only. Sorry i should't have used the word as "connected" instead i shoud have used mapped. Hope this will clarify you.

Regards

Venkatesh.S

VenkateshSampoornama at 2007-7-29 11:23:17 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...
# 5

Hi Venkatesh,

Yup. Thanks for the clarification.

Weird actually as the Connectivity Map was meant to be the final technical step in the development process and Environment settings would only contain configuration info, but it now looks like the Environment's External Systems correspond directly with Connector Connection Pools.

Have fun

Paul

PaulPetersa at 2007-7-29 11:23:17 > top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...