CoreEnvironmentBean

And what property& value I need to set for CoreEnvironmentBean ?

Thanks

Avinash

@Martin Simka..thanks for the reply..it's working now. I wonder why JBoss keep on changing and renaming properties, files and jars.allowMultipleLastResources needs to be done in 3 different ways in 3 different files in JBoss 4, 5 & 6.

Is maintaining consistency too costly?

Any thoughts on how I could do this in AS7? (set allowMultipleLastResources to true)

It seems to have changed again!

Thanks!

-Kumar

Does it have any side effect of setting in standalone.xml

<system-properties> 

     <property name="com.arjuna.ats.arjuna.allowMultipleLastResources" value="true"/> 

</system-properties> 

Can you clarify the question please?

I am getting ARJUNA012140: Adding multiple last resources is disallowed exceptions as my application is trying to use multiple datasources.

One of the fix for it is to add below setting in standalone.xml file,

<system-properties> 

     <property name="com.arjuna.ats.arjuna.allowMultipleLastResources" value="true"/> 

</system-properties> 

Does it weakens the transactional properties of application or any other side effect of adding com.arjuna.ats.arjuna.allowMultipleLastResources= true in standalone.xml

Thanks

Hi D P,

I am glad I asked, it sounds like you definitely don't want to enable that property as it will weaken the transactional properties. I am not altogether sure what version of the app server you are using but it sounds like you have configured them as <datasource> and not <xa-datasource>. You must do that as that will ensure they respect and adhere to the transactional boundaries.

Tom

Hi Tom,

I am using Wildfly 8.2.0 Application Server.

When I added <xa-datasource> in standalone.xml, server started throwing,

[org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (MSC service thread 1-16) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@44b5f55e[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2bb9603f connection handles=0 lastUse=1433265382084 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@289d5048 mcp=SemaphoreArrayListManagedConnectionPool@49a2f099[pool=N1DS] xaResource=XAResourceWrapperImpl@143a0b20[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2bb9603f pad=false overrideRmValue=null productName=Microsoft SQL Server productVersion=12.00.2000 jndiName=java:jboss/datasources/NedssDataSource] txSync=null]: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_start'.

    at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:631) [sqljdbc4.jar:]

    at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:663) [sqljdbc4.jar:]

MS SQLServer is the database, looks like MS SQLServer having issue with it.

What will be option for application to use multiple datasources.

Thanks

>  Could not find stored procedure 'master..xp_sqljdbc_xa_start

Didn't install XA support in the sql server, did you?

Understanding XA Transactions

Hi Jonathan,

I didn't install XA support in SQL Server.

Actually I am not allowed to install anything on DB server side.

Any driver I can use to overcome this issue or any other option should I try without changing SQLServer.

Thanks,