GetConnectionJEE

ReportComponent.java

@Stateless @LocalBean
public class MyClass{
  @Resource(lookup = "java:openejb/Resource/helloDS")
  private DataSource dataSource;
  
  public int countSql(){
    Connection conn = datasource.getConnection();
    Statement st = null;
    try{
      st = conn.createStatement();
      return st.executeQuery("SELECT 0").next().getInt(0);
    }catch(SQLException e){
    }finally{
      try{
        if(st != null){
          st.close();
          conn.close();
        }
      }catch(SQLException e){}
    }
    
  }

}