Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Resultset - retrieves all rows or only one at a time

843859Jul 21 2006 — edited Aug 1 2006
Hey guys,

I am using oracle DB. Lets say the query i run has about 1000 records

when i call:

prepareStmt(cstmt);
Rsultset rs = cstmt.executeQuery();

Do I get all the records, or do i get them one by one
when i call

rs.next
??

is this DB specific??

This is simple q, but i been working with oracle and java for a while, and for some reason this never came up.

thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2006
Added on Jul 21 2006
9 comments
811 views