public class TestBatch
{
public static void main(String[] args) throws Exception
{
String url = "jdbc:oracle:thin:@localhost:1521:siddb";
String user = "user";
String psw = "password";
DriverManager.registerDriver (new OracleDriver());
Connection conn = DriverManager.getConnection(url,user,psw);
boolean isAutoCommit = conn.getAutoCommit();
System.out.println("isAutoCommit =" + isAutoCommit);
conn.setAutoCommit(false);
Statement stat = conn.createStatement();
stat.addBatch("CREATE TABLE t(a int , b varchar2(30))");
stat.addBatch("INSERT INTO t VALUES (1,'aaaa')");
int[] counts = stat.executeBatch();
conn.commit();
conn.setAutoCommit(isAutoCommit);

}
}
А вообще по уму в Oracle надо отключать всегда autocommit - там не надо экономить транзакции(см. Том Кайт)