private static void execSQL(String query) throws SPARULException {

        Connection conn = null;
        Statement stmt = null;
        ResultSet result = null;
        try {
            conn = JDBCPoolConnection.getPoolConnection();
            stmt = conn.createStatement();
            result = stmt.executeQuery(query);
        } catch (Exception e) {
            throw new SPARULException(e);


        } finally {
            try {
                if (result != null) {
                    result.close();
                }
            } catch (Exception e) {
                logger.warn("Cannot close ResultSet", e);
            }
            try {
                if (stmt != null) {
                    stmt.close();
                }
            } catch (Exception e) {
                logger.warn("Cannot close Statement", e);
            }
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                logger.warn("Cannot close Connection", e);
            }
        }
    }