ResultSet (pointer or actual rows) 
Author Message
 ResultSet (pointer or actual rows)
When using an Oracle Stored Procedure and returning back a REF CURSOR that
is cast into a ResultSet object, does all of the data ride along with the
explicit cast or does the ResultSet object actually point to the data rows
on the database server?

I guess my question is... what exactly is a ResultSet?  Pointer to data rows
on the database server or a collection of the data rows contained in the
ResultSet object?

Thanks,

Brian



Sun, 06 Jan 2002 03:00:00 GMT
 ResultSet (pointer or actual rows)

Hi Brian. It's really a thin Java wrapper around the DBMS protocol that
asks for existing data rows from a prior query. These rows are at the DBMS,
or in some cases for performance, some or all of them of them may have been
pre-fetched to the client process, either on instantiation of the ResultSet, or
during the first call to next(). In most cases, pre-fetched rows are at a low
level, and not accessible except via next().

Quote:

> When using an Oracle Stored Procedure and returning back a REF CURSOR that
> is cast into a ResultSet object, does all of the data ride along with the
> explicit cast or does the ResultSet object actually point to the data rows
> on the database server?

> I guess my question is... what exactly is a ResultSet?  Pointer to data rows
> on the database server or a collection of the data rows contained in the
> ResultSet object?

> Thanks,

> Brian

--
PS: Hey folks, we're hiring Java engineers for our WebLogic
    Engineering group in downtown S.F. Send me your resume.
--------------------------------------------------------------------------------
                    The Weblogic Application Server from BEA
         JavaWorld Editor's Choice Award: Best Web Application Server
  Java Developer's Journal Editor's Choice Award: Best Web Application Server
     Crossroads A-List Award: Rapid Application Development Tools for Java
Intelligent Enterprise RealWare: Best Application Using a Component Architecture
               http://weblogic.beasys.com/press/awards/index.htm


Sun, 06 Jan 2002 03:00:00 GMT
 ResultSet (pointer or actual rows)
It is an abstraction. It could be either one depending on the
driver. JDBC abstracts from the concept so you don't have to worry
about those issues.

: When using an Oracle Stored Procedure and returning back a REF CURSOR that
: is cast into a ResultSet object, does all of the data ride along with the
: explicit cast or does the ResultSet object actually point to the data rows
: on the database server?

: I guess my question is... what exactly is a ResultSet?  Pointer to data rows
: on the database server or a collection of the data rows contained in the
: ResultSet object?

: Thanks,

: Brian

--

                    http://www.imaginary.com/~borg
       "The dead know only one thing: it's better to be alive"
                     -Joker in Full Metal Jacket



Mon, 07 Jan 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ResultSet with few rows invisible to ResultSet.next()

2. passing resultset pointer from oracle to vb

3. ResultSet next() throws Null Pointer Exception

4. Actual row size

5. How do you get the actual row number?

6. Pointers on modelling row-level/capability based security.

7. DLL Pointer to a Pointer

8. Rows in ResultSet

9. Sorting resultset rows in BLL/DAL COM objects or SPs

10. ResultSet can not re-read row data for column XX.

11. [SQLServer JDBC Driver]ResultSet can not re-read row data for column 1

12. ResultSet can not re-read row data for column 1


 
Powered by phpBB® Forum Software