Submit My Question - Recent Questions - Recent Answer
java >> Core >> Core APIs

Result Set

Hi all,Does the result set has a limit size?thanx
[70 byte] By [IssaBablia] at [2007-9-19]
«« Applet read and write
»» Entity Bean and unique key
# 1
I think usually you will not reach the limit. Because the resultset does not load and data to the memory. Until you get the data of the record.
angusedisona at 2007-7-8 > top of java,Core,Core APIs...
# 2
i did a test with a dba at work couple of ears ago. he loaded a table with 5 million record, and i did a select * from it, and then extracted everything from it and put all records in a vector and stored in the session, played with it, and it was perfectly ok.
daFeia at 2007-7-8 > top of java,Core,Core APIs...
# 3

The JDBC ResultSet does not have a limit, but ODBC connections limit the amount of data that can be returned in a single query... thus if you are using the JDBC-ODBC bridge, there will be a limit (Can't find information on that limit, sorry) on the volume of data that a single query can return.

fiontana at 2007-7-8 > top of java,Core,Core APIs...
# 4
Not sure what the limit is for JDBC (or if there is one). I do know that because the result set API is defined in terms of integers for row access there must at least be an upper limit of 2,147,483,647 rows...
noitalla at 2007-7-8 > top of java,Core,Core APIs...
Core APIs

Core Hot Topic

Core

Site Classified