/**
     * Executes a procedure on database.
     *
     * Use {@link #getCon()} to get a connection.
     *
     * @param procedure The procedure which will be executed. Using like "{call
     * procedure()"
     * @exception Exception
     */
    public Boolean executeProcedure(String procedure) throws DBException {
        Connection con = null;
        try {
            con = getConnection();
            PreparedStatement pst = con.prepareCall(procedure);
            return pst.execute();
        } catch (DBException ex) {
            throw new DBException(ex);
        } catch (SQLException ex) {
            throw new DBException(ex);
        } catch (Exception ex) {
            throw new DBException(ex);
        } finally {
            releaseCon(con);
        }
    }

    /**
     * Executes a procedure on database.
     *
     * Use {@link #getCon()} to get a connection.
     *
     * @param procedure Procedure which will be executed. Using like "{call
     * procedure(?,?)"
     * @param args objects needed in query
     * @exception Exception
     */
    public Boolean executeProcedure(String procedure, Object... args) throws DBException {
        Connection con = null;
        try {
            con = getConnection();
            CallableStatement pst = con.prepareCall(procedure);
            for (int i = 0; i < args.length; i++) {
                pst.setObject(i + 1, args[i]);
            }
            return pst.execute();
        } catch (DBException ex) {
            throw new DBException(ex);
        } catch (SQLException ex) {
            throw new DBException(ex);
        } catch (Exception ex) {
            throw new DBException(ex);
        } finally {
            releaseCon(con);
        }
    }
/**
     * Return result from database.
     *
     * Use {@link #getCon()} to get a connection.
     *
     * @param sqlQuery Query which will be retuned
     * @return ResultSet
     * @exception Exception
     */
    public ResultSet returnProcedureResult(final String sqlQuery) throws DBException {

        Connection con = null;
        try {
            con = getConnection();
            CallableStatement pst;
            if (con != null && !con.isClosed()) {
                pst = con.prepareCall(sqlQuery);
            } else {
                throw new DBException("Connection is closed");
            }
            return pst.executeQuery();
        } catch (DBException ex) {
            throw new DBException(ex);
        } catch (SQLException ex) {
            throw new DBException(ex);
        } catch (Exception ex) {
            throw new DBException(ex);
        } finally {
            releaseCon(con);
        }
    }

    /**
     * Return result from database.
     *
     * Use {@link #getCon()} to get a connection.
     *
     * @param sqlQuery Query which will be retuned
     * @param args Objects needed in sqlQuery
     * @return ResultSet
     * @exception Exception
     */
    public ResultSet returnProcedureResult(final String sqlQuery, Object... args) throws DBException {

        Connection con = null;
        try {
            con = getConnection();
            CallableStatement pst;
            if (con != null && !con.isClosed()) {
                pst = con.prepareCall(sqlQuery);
            } else {
                throw new DBException("Connection is closed");
            }
            for (int i = 0; i < args.length; i++) {
                pst.setObject(i + 1, args[i]);
            }
            return pst.executeQuery();
        } catch (DBException ex) {
            throw new DBException(ex);
        } catch (SQLException ex) {
            throw new DBException(ex);
        } catch (Exception ex) {
            throw new DBException(ex);
        } finally {
            releaseCon(con);
        }
    }