-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
