1 5 package org.h2.test.jdbc; 6 7 import java.sql.Connection ; 8 import org.h2.jdbcx.JdbcDataSource; 9 10 public class TestXA { 11 12 int notYetImplemented; 13 14 public static void main(String [] args) throws Exception { 15 Class.forName("org.h2.Driver"); 16 17 18 21 JdbcDataSource ds1 = new JdbcDataSource(); 22 ds1.setPassword(""); 23 ds1.setUser("sa"); 24 ds1.setURL("jdbc:h2:db1H2"); 25 26 JdbcDataSource ds2 = new JdbcDataSource(); 27 ds2.setPassword(""); 28 ds2.setUser("sa"); 29 ds2.setURL("jdbc:h2:db2H2"); 30 31 34 Connection c1 = ds1.getXAConnection().getConnection(); 35 c1.setAutoCommit(false); 36 Connection c2 = ds2.getXAConnection().getConnection(); 37 c2.setAutoCommit(false); 38 39 c1.createStatement().executeUpdate("create table test(id int, teste varchar(255))"); 40 c2.createStatement().executeUpdate("create table test(id int, teste varchar(255))"); 41 42 43 c1.close(); 45 c2.close(); 46 47 50 } 51 } 52 | Popular Tags |