*/
    public ResultSet executeQuery(String sql) throws  SQLException {        try        {            c.ensureInTransaction();            if (!internalExecute(sql)) {                throw new SQLException("query did not return a result set: " + sql);            }            if (c.willEndTransaction())            {                ResultSet rs = getCachedResultSet(false);                //autocommits.                return rs;            } // end of if ()            else            {                return getResultSet();            } // end of else        }        catch (ResourceException re)        {           log.warn("resource exception", re);           throw new SQLException("ResourceException: " + re);        } // end of try-catch        catch (GDSException ge)        {            throw new SQLException("GDSException: " + ge);        } // end of try-catch        finally        {            c.checkEndTransaction();        } // end of finally    }