[JBoss-user] Explicit commit and rollback in EJB

[Ricky]

 
Hi all , i am using jboss2.1 , linux6.1 ,Tomcat 3.2.1 and jdk1.3.
Can implemented the code below in my stateless bean ??? 
Can i do commit and rollback explicit in EJB ??
 
 Thanks wt.

  try{

    conn = this.getConnection() ;
    conn.setAutoCommit(false);  
    ps = conn.prepareStatement("Select NEXTVAL('userprojectinfo_seq')
from userprojectinfo_seq");
    rs = ps.executeQuery();
    conn.commit()

    if(rs.next()){
      projectinfojb.setProjectid(rs.getInt("nextval"));
     }
   }
   catch(Exception ce){
    ce.printStackTrace();
     try{
       conn.rollback();
     }
      catch(SQLException se){}
    }
    projectinfohome.create(projectinfojb);
   }
   else throw new UserException("Project no is already exist ");
  }

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user