tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: tomcat + mysql xa setup
Date Tue, 11 Jun 2013 20:53:14 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

이재만,

Full disclosure: I've never done XA with any RDBMS.

On 6/10/13 7:15 PM, 이재만 wrote:
> how do i setup xa(2pc) on the tomcat with mysql ??? please anybody
> tell me setup process..

1. Make sure you are using Connector/J 5.0 or later [1]

2. Make sure you are using InnoDB storage engine for all involved
tables [2]

3. Use com.mysql.jdbc.jdbc2.optional.MysqlXADataSource as your driver

4. Declare your TransactionManager in context.xml [3]

Note that Tomcat does not provide its own TransactionManager: you have
to use a 3rd party one (Hibernate, Atomikos, OpenJPA, Bitronix, etc.).

You might want to check out this blog posting where someone has set
everything up from scratch, albeit with their own personal
preferences. Perhaps you can make some progress using it as a guide:

http://codepitbull.wordpress.com/2011/07/08/tomcat-7-with-full-jta/


[1] http://dev.mysql.com/doc/refman/5.0/en/connector-j-versions.html
[2] http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html
[3]
http://tomcat.apache.org/tomcat-7.0-doc/config/context.html#Transaction
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJRt445AAoJEBzwKT+lPKRYxDIQAK4+RiIuGFsBqoO4NyXieJ2R
0tjq78uUnJdcpPv2gi7C+gszt2KDYBLn1teSAi2+Fc7clqtIIEXWO6ryi361bOpX
iPm0+ajqNYQfbO8cOo7OMog2hVtZTurVMBTePRATvdPIJw6lqhscesdN23AYCLqE
u9ahgYFNY5yXJjyen2KEiMWFLs78UFchBycaE2yfhmsBxl5VxGuTb44uTSUQaFNT
R7LXfZpLXK3KUkECtVqU2PzJ3ElQXM7nBOCUHqhDoKdIBOuD0m0OZbcc60yIizFq
bo+Ow5Wnl/o2Ekzpzu1XD9MsZOLn34AXfgYJZ/h+WMD+yzsWgxp4lSS73gsOG2Vm
CEYj6yweLO0Eg4CVigckVMwvvnWOqUT8jr3RBTwH9pAI5rTM/NyquU9awR623MJe
gXqmEIX+liL6UqbM7/kwjxxk+HnXi8lGx/tUkwtKUImCrvfHaJ+piM+Y85Ao4qao
vGPJps6Oyzd9rifwe36oDu9MCJ+2X8Wkph8yNoZ3ePl16tivSaggsbpxPH9UuSpj
v9oAHiIYsniPI6IBWvrTwvPm3F4seXyUPw0IdSr59+IM/ENddoQ4KoOYpFCgF5nA
+Ww7quoMDbKm2ljMpnOLgVjpzs2icLB3Vh0ZhUuuTlobNNEq9kG+iPvrD1zsi+ZC
LqN/JOXQF4o8JAwdCKFE
=tkk6
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message