인포믹스에서 commit(), rollback을 적용할려구 합니다..
근데 인포믹스에서는 이걸 commit()을 지원하지 안는다는 Exception이 뜨더라구요.. 혹시 처리하는 방법을 아시는지요?
DBConnectionManager connMgr= DBConnectionManager.getInstance();
Connection pconn=null;
PreparedStatement pstmt=null;
try{
pconn=connMgr.getConnection();
String query="Insert into dmct_group(state) values('2') ";
pconn.setAutoCommit(false); <======== Not supported Exception
pstmt=conn.prepareStatement(query);
pstmt.executeUpdate();
pconn.commit();
}catch(Exception e){
pconn.rollback();
}finally {
try{if(pstmt!=null) pstmt.close();}catch(Exception e1){}
try{if(pconn!=null) pconn.close();}catch(Exception e1){}
}
|