executeBatch() 事务 批量执行sql

[chenhongwei0924]

Connection connection = OracleDB.getConn(ip, user, password);
	if (connection == null) {
	  return;
	}
	Statement statement = null;
	File file = new File("D:\\test.sql");
	
	List<String> sqlList = loadSql(file);
	try {
	    connection.setAutoCommit(false);
	    statement = connection.createStatement();
	    for (String sql : sqlList) {
		System.out.println("sql :  " + sql);
		statement.addBatch(sql);
	    }
	    int[] rows = statement.executeBatch();
	   System.out.println("Row count:" + Arrays.toString(rows));

	} catch (Exception ex) {
	    connection.rollback();
	    connection.setAutoCommit(true);
             System.err.print(ex.getMessage());
	} finally {
	    OracleDB.closeAll(connection, statement, null);
	}

create table TEST_DELETE
(
  ADDRESS VARCHAR2(50) not null,
  NAME    VARCHAR2(50) not null,
  SCORE   NUMBER not null
)
;
alter table TEST_DELETE
  add constraint TEST_PK primary key (ADDRESS, SCORE);


insert into TEST_DELETE (ADDRESS, NAME, SCORE)
values ('Los Angeles', 'kobe', 100);
insert into TEST_DELETE (ADDRESS, NAME, SCORE)
values ('Los Angeles', 'Atai', 23);
insert into TEST_DELETE (ADDRESS, NAME, SCORE)
values ('Italy', 'kobe', 23);
insert into TEST_DELETE (ADDRESS, NAME, SCORE)
values ('Los Angeles', 'Plou', 95);
insert into TEST_DELETE (ADDRESS, NAME, SCORE)
values ('Espana', 'Plou', 95);

executeBatch() 批量执行sql,假如insert 出现异常，为什么create 不回滚事务

Class.forName("oracle.jdbc.driver.OracleDriver");
	  
	  
	    return   DriverManager.getConnection(url,user,password);

[shixianwei]

应该是ddl和dml的区别吧能回滚的只能是dml吧不知道顶一下看高手解答

[minitoy]

ddl默认自动commit的，事务里不能含ddl语句

[iihero_]

ddl语句在oracle中无法回滚。

[sanhgjc]

在java中有多少种从处理SQL事务方式，哪个大虾帮忙解答一下