Spring ibatis jta多数据源配置

《Spring ibatis jta多数据源配置》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Spring+iBatis+JOTM实现JTA事务JOTM是个开源的JTA事务管理组件，可以让程序脱离J2EE容器而获得分布式事务管理的能力。测试过程如下：一、环境1、准备软件环境spring-framework-2.5.6.SEC01-with-dependencies.zipibatis-2.3.4ow2-jotm-dist-2.1.4-bin.tar.gzMySQL-5.1JDK1.52、创建数据库环境，注意数据库引擎为InnoDB，只有这样才能支持事务。CREATEDATABASEIFNOTEXIS

2、TStestdb_aDEFAULTCHARACTERSETutf8;USEtestdb_a;DROPTABLEIFEXISTStab_a;CREATETABLEtab_a(idbigint(20)NOTNULL,namevarchar(60)DEFAULTNULL,addressvarchar(120)DEFAULTNULL,PRIMARYKEY(id))ENGINE=InnoDBDEFAULTCHARSET=utf8;CREATEDATABASEIFNOTEXISTStestdb_bDEFAULTCHAR

3、ACTERSETutf8;USEtestdb_b;DROPTABLEIFEXISTStab_b;CREATETABLEtab_b(idbigint(20)NOTNULL,namevarchar(60)DEFAULTNULL,addressvarchar(120)DEFAULTNULL,PRIMARYKEY(id))ENGINE=InnoDBDEFAULTCHARSET=utf8;二、建立项目testJOTM1、建立项目后，准备依赖的类库，结构如下：│spring-aop.jar│spring-beans.j

4、ar│spring-context-support.jar│spring-context.jar│spring-core.jar│spring-jdbc.jar│spring-jms.jar│spring-orm.jar│spring-test.jar│spring-tx.jar│spring-web.jar│spring-webmvc-portlet.jar│spring-webmvc-struts.jar│spring-webmvc.jar│aspectjrt.jar│aspectjweaver.jar

5、│cglib-nodep-2.1_3.jar│asm-2.2.3.jar│log4j-1.2.15.jar│asm-commons-2.2.3.jar│asm-util-2.2.3.jar│aopalliance.jar│mysql-connector-java-5.1.6-bin.jar│├─ibatis│ibatis-2.3.4.726.jar│sql-map-2.dtd│sql-map-config-2.dtd│├─jotm│license.txt│xapool.jar│jotm-core.jar│j

6、otm-standalone.jar│jotm-jms.jar│jotm-datasource.jar│ow2-jta-1.1-spec.jar│jotm-client.jar│├─jakarta-commons│commons-attributes-api.jar│commons-attributes-compiler.jar│commons-beanutils.jar│commons-codec.jar│commons-collections.jar│commons-dbcp.jar│commons-d

7、igester.jar│commons-discovery.jar│commons-fileupload.jar│commons-httpclient.jar│commons-io.jar│commons-lang.jar│commons-logging.jar│commons-pool.jar│commons-validator.jar│├─junit│junit-3.8.2.jar│junit-4.4.jar│license.txt│└─log4jlog4j-1.2.15.jar2、根据表建立entit

8、y和SQLMappublicclassTabAimplementsSerializable{privateLongid;privateStringname;privateStringaddress;//省略getter/setterpublicclassTabBimplementsSerializable{privateLongid;privateStringname;privateStringaddress;/