[jBoss-User] Simple question to ask about ejb

[Ricky]

 
 Hi all , i am using jBoss-FINAL_2.0 container .
 My question is that can i do open Connection in the CMP bean in
ejbCreate() .
 Any wrong with that ? Is violated the EJB specification ??

 Please commment. Below is the CMP bean code:  


 public UsersPK ejbCreate(String username,String password,boolean
isadmin) throws CreateException {

    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;

    try{
      conn = this.getConnection();
      ps = conn.prepareStatement("Select NEXTVAL('userproject_seq') from
test_seq");
      rs = ps.executeQuery();

      if(rs.next()){
        this.userid = rs.getInt(1);
      }
    }
    catch(SQLException se){}
    finally{
     try{
      if(conn != null) conn.close();
      if(rs != null ) rs.close();
      if(ps != null ) ps.close();
     }
     catch(SQLException se){}
    }

    this.username = username;
    this.password = password;
    this.isadmin = isadmin;

    return null;

  }


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]