谁帮我看看这个JAVA程序为什么不回滚? (初学者的小问题)

iamdddboy

package com.oracle.apps.cux.webui;
import java.io.PrintStream;
import java.sql.*;
public class cuxtest1 {
public static String g_function_name = "cuxtest1";
public static String g_app_name = "CUX";
public cuxtest1() {
}
public static Connection getConection(String p_user, String p_pwd) {
  String strUrl1 = "jdbcracle:thin(description=(address_list=(address=(protocol=tcp)";
  String strUrl2 = "(host=192.168.253.150)(port=1521)))(connect_data=(sid=prod)))";
  String strUrl = strUrl1 + strUrl2;
  System.out.println("strUrl=" + strUrl);
  String strUser = p_user;
  String strPassword = p_pwd;
  Connection conn = null;
  try {
   String driverName = "oracle.jdbc.driver.OracleDriver";
   Class.forName(driverName);
   conn = DriverManager.getConnection(strUrl, "APPS", "APPS");
  } catch (Exception e) {
   System.out.println("Connect to dterp Server Error!");
   e.printStackTrace();
  }
  return conn;
}
public static void main(String[] args) {
  System.out.println("MAIN Start");
  String strUser = args[2].substring(0, args[2].indexOf(47, 0));
  String strPwd = args[2].substring(args[2].indexOf(47, 0) + 1);
  System.out.println(strUser + "," + strPwd);
  Connection conn = getConection(strUser, strPwd);
  put_log(conn, "asdasdadasdad");
}
public static void put_log(Connection p_conn, String p_error_msg) {
  CallableStatement cs = null;
  String sql = "begin cux_xxx_pkg.write_debug(:1,:2,:3); end;";
  boolean isProcess = true;
  System.out.println(p_error_msg);
  try {
   p_conn.setAutoCommit(false);
   cs = p_conn.prepareCall(sql);
   cs.setString(1, g_app_name);
   cs.setString(2, g_function_name);
   cs.setString(3, p_error_msg);
   cs.execute();
   if (isProcess) {
    System.out.println("rollback");//我这里明明执行后让它回滚的, 但是事实上还是提交了,这是怎么回事啊
    p_conn.rollback();
   } else {
    System.out.println("commit");
    p_conn.commit();
   }
   cs.close();
   p_conn.close();
  } catch (SQLException sqle) {
   try {
    p_conn.rollback();
    cs.close();
    p_conn.close();
   } catch (Exception exception) {
   }
   sqle.printStackTrace();
  }
}
}

iamdddboy

不好意思,,我刚发现我的 cux_xxx_pkg是自制事务,结贴