分布式事务是指操作多个数据库之间的事务,spring的org.springframework.transaction.jta.JtaTransactionManager,提供了分布式事务支持。如果使用WAS的JTA支持,把它的属性改为WebSphere对应的TransactionManager。
在tomcat下,是没有分布式事务的,不过可以借助于第三方软件jotm(Java Open Transaction Manager )和AtomikosTransactionsEssentials实现,在spring中分布式事务是通过jta(jotm,atomikos)来进行实现。
一、使用JOTM例子
(1) Dao及实现
GenericDao接口:
public interface GenericDao { public int save(String ds, String sql, Object[] obj) throws Exception; public int findRowCount(String ds, String sql); }
GenericDaoImpl 实现:
public class GenericDaoImpl implements GenericDao{ private JdbcTemplate jdbcTemplateA; private JdbcTemplate jdbcTemplateB; public void setJdbcTemplateA(JdbcTemplate jdbcTemplate) { this.jdbcTemplateA = jdbcTemplate; } public void setJdbcTemplateB(JdbcTemplate jdbcTemplate) { this.jdbcTemplateB = jdbcTemplate; } public int save(String ds, String sql, Object[] obj) throws Exception{ if(null == ds || "".equals(ds)) return -1; try{ if(ds.equals("A")){ return this.jdbcTemplateA.update(sql, obj); }else{ return this.jdbcTemplateB.update(sql, obj); } }catch(Exception e){ e.printStackTrace(); throw new Exception("执行" + ds + "数据库时失败!"); } } public int findRowCount(String ds, String sql) { if(null == ds || "".equals(ds)) return -1; if(ds.equals("A")){ return this.jdbcTemplateA.queryForInt(sql); }else{ return this.jdbcTemplateB.queryForInt(sql); } } }</pre> (2) Service及实现 UserService 接口: public interface UserService { public void saveUser() throws Exception; } UserServiceImpl 实现: public class UserServiceImpl implements UserService{ private GenericDao genericDao; public void setGenericDao(GenericDao genericDao) { this.genericDao = genericDao; } public void saveUser() throws Exception { String userName = "user_" + Math.round(Math.random()*10000); System.out.println(userName); StringBuilder sql = new StringBuilder(); sql.append(" insert into t_user(username, gender) values(?,?); "); Object[] objs = new Object[]{userName,"1"}; genericDao.save("A", sql.toString(), objs); sql.delete(0, sql.length()); sql.append(" insert into t_user(name, sex) values(?,?); "); objs = new Object[]{userName,"男的"};//值超出范围 genericDao.save("B", sql.to