Re: Problem with mysql xa and 1.2-beta

[Donald Woods]

David Jencks wrote:

On Jan 3, 2007, at 10:56 AM, Mike Perham wrote:

I'm using the new 1.2-beta with the mysql-xa connector from wasce
1.1.0.1.  My application does some db work when it starts up and we
don't see this error on 1.1.0.1.  I'm using Spring 1.2.8's
JTATransactionManager like this:

<bean id="inboxTransactionManager"
class="org.springframework.transaction.jta.JtaTransactionManager">

</bean>

Is this the correct JNDI location?

<property name="transactionManagerName"><value>java:/TransactionManager</value></property>

I would have expected it to be java:TransactionManager but it's possible both values work. I suspect it's working because apparently there is a transaction started and I assume it was started by Spring. I haven't personally tried the tranql mysql xa adapter (is that the one from wasce?)

No, WASCE doesn't include the MySQL adapter from TranQL.
BTW - WASCE 1.1.0.1 == Geronimo 1.1.1

but I wonder.... have you gotten it to work in other

circumstances?





Do you expect there to be any work done outside a transaction?

thanks
david jencks

One possibility is that there's a bug in the connector. When a connection is not enrolled in a transaction it's supposed have autocommit behavior. If this isn't working you probably wouldn't see a problem using a local-tx connector since there isn't much to the start of a transaction -- just turning off autocommit. If it was already off you might not see any errors. Can you put a breakpoint in a likely spot in perhaps the WrapperNamedXAResource and see if commit is actually being called?

[EMAIL PROTECTED], errorCode: -9

outside global transaction

Exception(MysqlXAConnection.java:562)

XAConnection.java:545)

on.java:485)

WrapperNamedXAResource.java:86)

e(TransactionImpl.java:207)

r.getConnection(TransactionEnlistingInterceptor.java:54)

getConnection(TransactionCachingInterceptor.java:87)

tConnection(ConnectionHandleInterceptor.java:43)

TCCLInterceptor.java:39)

getConnection(ConnectionTrackingInterceptor.java:66)

cateConnection(AbstractConnectionManager.java:61)

)


       at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

nnectorMethodInterceptor.java:54)

ated>)

ataSourceUtils.java:112)

etConnection(TransactionAwareDataSourceProxy.java:107)

lookupConnection(LocalDataSourceConnectionFactory.java:88)

(Unknown Source)

nt(Unknown Source)

Source)

Source)

nown Source)

ry(Unknown Source)

(Unknown Source)

Unknown Source)

Unknown Source)

Unknown Source)

(Unknown Source)

yQuery(Unknown Source)

yQuery(Unknown Source)

ceBroker(PersistenceBrokerTemplate.java:192)

09:50:32,771 WARN [Transaction] Unable to enlist XAResource org.apache.geronimo com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUTSIDE: Some work is done at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQL at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(Mysql at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnecti at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.start( at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResourc at org.apache.geronimo.connector.outbound.TransactionEnlistingIntercepto at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor. at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.ge at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection( at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor. at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allo at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56 at $javax.sql.DataSource$$FastClassByCGLIB$$6525cafd.invoke(<generated>) at org.apache.geronimo.connector.ConnectorMethodInterceptor.intercept(Co at $javax.sql.DataSource$$EnhancerByCGLIB$$f0297be4.getConnection(<gener at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.g at org.springframework.orm.ojb.support.LocalDataSourceConnectionFactory. at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStateme at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unk at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB at org.springframework.orm.ojb.PersistenceBrokerTemplate$3.doInPersisten at org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(Persist

Mike, for WASCE specific questions, try using our devWorks forum at -
http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=541&cat=51


-Donald

smime.p7s
Description: S/MIME Cryptographic Signature