con = getConnection();
con = JDBCUtil.getDBConnection(JNDINames.DATASOURCE);
    public int getLastCRLNumber(Admin admin, String issuerdn) {        debug(">getLastCRLNumber(" + issuerdn + ")");        Connection con = null;        PreparedStatement ps = null;        ;        ResultSet result = null;        try {            con = getConnection();            ps = con.prepareStatement("select MAX(CRLNumber) from CRLData where issuerDN=?");            ps.setString(1, issuerdn);            result = ps.executeQuery();            int maxnumber = 0;            if (result.next())                maxnumber = result.getInt(1);            debug("<getLastCRLNumber(" + maxnumber + ")");            return maxnumber;        } catch (Exception e) {            throw new EJBException(e);        } finally {            JDBCUtil.close(con, ps, result);        }    } //getLastCRLNumber