-
1. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
ctomc Jun 6, 2012 10:22 AM (in response to sudheerk84)Hi,
examples of what? how to use Spring?,
as this looks like Spring bean configuration and has nothing to do with how AS7 handles XA datasources..
take a look at https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/
and https://community.jboss.org/wiki/DataSourceConfigurationInAS7
--
tomaz
-
2. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
jaikiran Jun 6, 2012 11:05 AM (in response to ctomc)I'm not even sure Sudheer is using AS7 (no where does he mention that). From what little I understood of the post, I thought this is a case of standalone JBoss Transcation Manager being used with Tomcat and Spring framework. That's why I moved this to JBoss Transactions user forum.
Sudheer, if however, you are indeed using AS7 and by standalone you mean the standalone profile of the server then let us know - I'll move it back appropriately. By the way, like Tomaz said, you'll have to explain more on what you are asking help for.
Message was edited by: jaikiran pai - Fixed typo
-
3. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
sudheerk84 Jun 6, 2012 10:48 AM (in response to jaikiran)Sorry for not making my self clear. I am not using any application server .
I was previosly using Atomikos transaction manager and because of performance issues i am looking at Jboss transaction manager.(Without JBOSS AS7)
I am using jboss transaction manager - to manage transactions between Mysql and Infinispan cache.
So when i tried - jboss transaction manager - i could not configure it properly. I use spring configurations to enable my configurations.
Basically i am looking for the answer posted in the comment section of this article - https://community.jboss.org/wiki/JBossTransactionsWithSpring
Should the JTA provider come with a datasource similar to Atomikos when it is used in a standalone environment ?
-
4. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
jhalliday Jun 6, 2012 10:57 AM (in response to sudheerk84)1 of 1 people found this helpfulThe built-in JDBC connection pooling in tomcat is not XA aware. Use something that is - TransactionalDriver from JBossTS, IronJacamar or XAPool. Whatever you pick, ensure the resource manager is getting registered for recovery correctly.
-
5. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
sudheerk84 Jun 6, 2012 11:27 AM (in response to jhalliday)I was just checking teh documentation for tomcat jdbc connection pooling - http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html
I am NOT using tomcat - and my intensional was to use it for a stanlone use case.
The documentation for jdbc-pool suggests the "XA connection support" and its a drop in replacement for DBCP , overcoming all its limitations
The link you pasted looks very interesting - I will try with IronJacamar / transactiondriver.
-
6. Re: StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA
jhalliday Jun 6, 2012 11:37 AM (in response to sudheerk84)There are different levels of XA support. Some pools won't even enlist the XAResource automatically for you. If it does, can it deal with use cases such as: connection has been returned to the pool by the application code, but the tx is still running. Tx has been checked out of the pool, then the app begins a tx in which it uses that connection. Or the reverse situation, where the app suspends the tx and then continutes to use the connection. Or where the tx rolls back in the background due to a timeout. Check the small print carefully and write a lot of test cases.