I'm running GlassFish V2 and our deployment environment is : SunOS 5.10 Generic_118833-36 sun4u sparc SUNW,Sun-Fire-V240

We have deployed our EAR file to the server, which is clustered. Now when we
perform certain actions we receive the exceptions listed below. Basically,

[b]JTS5041: The resource manager is doing work outside a global transaction[/b]

Our Stateless EJB has the following annotations defining it as an EJB and the
transaction boundary. @Stateless(name = "QuoteBroker") @Local(com.sybase.it.quoting.QuoteBroker.class) @Interceptors(SpringBeanAutowiringInterceptor.class) @TransactionAttribute(TransactionAttributeType.REQUIRED)

Looking at the Exception message it appears as if the container is not starting
a transaction when the methods are invoked. How is this possible and how do we
get around this issue?

Thanks for the help...

[u][b]Stack Trace:[/b][/u] [#|2008-07-28T09:11:22.174-0700|WARNING|sun-appserver9.1|javax.enterprise.system.core.transaction|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;_RequestID=b7e375b0-c20e-4634-ab69-d95026a47426;|JTS5041:
The resource manager is doing work outside a global transaction javax.transaction.xa.XAException at com.sybase.jdbc3.jdbc.SybXAResource.a(Unknown Source) at com.sybase.jdbc3.jdbc.SybXAResource.a(Unknown Source) at com.sybase.jdbc3.jdbc.SybXAResource.start(Unknown Source) at com.sun.gjc.spi.XAResourceImpl.start(XAResourceImpl.java:222) at com.sun.jts.jta.TransactionState.startAssociation(TransactionState.java:305) at com.sun.jts.jta.TransactionImpl.enlistResource(TransactionImpl.java:205) at
com.sun.enterprise.distributedtx.J2EETransaction.enlistResource(J2EETransaction.java:562) at
com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.enlistResource(J2EETransactionManagerImpl.java:372) at
com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.enlistResource(J2EETransactionManagerOpt.java:144) at
com.sun.enterprise.resource.SystemResourceManagerImpl.enlistResource(SystemResourceManagerImpl.java:98) at
com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:216) at
com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:337) at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189) at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165) at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158) at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108) at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at
org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy134.prepareStatement(Unknown Source

[u][b]More:[/b][/u]

[#|2008-07-28T09:11:22.199-0700|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;_RequestID=b7e375b0-c20e-4634-ab69-d95026a47426;|poolmgr.err_enlisting_res_in_getconn|#]

[#|2008-07-28T09:11:22.202-0700|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;cosmosConnectionPool;javax.transaction.SystemException;_RequestID=b7e375b0-c20e-4634-ab69-d95026a47426;|RAR5117
: Failed to obtain/create connection from connection pool [ cosmosConnectionPool
]. Reason : javax.transaction.SystemException|#]

[#|2008-07-28T09:11:22.203-0700|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;Error
in allocating a connection. Cause:
javax.transaction.SystemException;_RequestID=b7e375b0-c20e-4634-ab69-d95026a47426;|RAR5114
: Error allocating connection : [Error in allocating a connection. Cause:
javax.transaction.SystemException]|#]

[#|2008-07-28T09:11:22.205-0700|INFO|sun-appserver9.1|com.sybase.it.quoting.advice.MethodTimingInterceptor|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;|Method
Invocation Complete [com.sybase.it.quoting.dao.ibatis.CosmosDaoImpl.validateCBS]
Total Time: 0(seconds) 37(millis)|#]

[#|2008-07-28T09:11:22.206-0700|SEVERE|sun-appserver9.1|com.sybase.it.customer.impl.CustomerBroker|_ThreadID=22;_ThreadName=httpSSLWorkerThread-1080-0;_RequestID=b7e375b0-c20e-4634-ab69-d95026a47426;|org.springframework.jdbc.UncategorizedSQLException:
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null];
error code [0]; --- The error occurred in com/sybase/it/quoting/dao/ibatis/maps/Cosmos.xml. --- The error occurred while executing query. --- Check the SELECT CASE WHEN COUNT(1) = 0 THEN 'N' ELSE 'Y' END
FROM ciim..customer_shipping JOIN ciim..customer_billing ON
ciim..customer_shipping.customer_no = ciim..customer_billing.customer_no AND
ciim..customer_shipping.bill_to_location =
ciim..customer_billing.bill_to_location JOIN sybasedb..customers
ON ciim..customer_shipping.customer_no = sybasedb..customers.customer_no
where (sybasedb..customers.activeind = 'Y' OR
sybasedb..customers.activeind = 'y') and
ciim..customer_shipping.customer_no = ? and
ciim..customer_shipping.addr_status = 'ACT' and
ciim..customer_shipping.ship_to_location = ? and
ciim..customer_shipping.bill_to_location = ? . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Error in allocating a connection. Cause:
javax.transaction.SystemException; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/sybase/it/quoting/dao/ibatis/maps/Cosmos.xml. --- The error occurred while executing query. --- Check the SELECT CASE WHEN COUNT(1) = 0 THEN 'N' ELSE 'Y' END
FROM ciim..customer_shipping JOIN ciim..customer_billing ON
ciim..customer_shipping.customer_no = ciim..customer_billing.customer_no AND
ciim..customer_shipping.bill_to_location =
ciim..customer_billing.bill_to_location JOIN sybasedb..customers
ON ciim..customer_shipping.customer_no = sybasedb..customers.customer_no
where (sybasedb..customers.activeind = 'Y' OR
sybasedb..customers.activeind = 'y') and
ciim..customer_shipping.customer_no = ? and
ciim..customer_shipping.addr_status = 'ACT' and
ciim..customer_shipping.ship_to_location = ? and
ciim..customer_shipping.bill_to_location = ? . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Error in allocating a connection. Cause:
javax.transaction.SystemException|# [Message sent by forum member 'cmathrusse' (cmathrusse)]

http://forums.java.net/jive/thread.jspa?messageID=289834