Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Other Java > Java Databases
Reload this Page Unable to Iterate over large number of records
|
Java Databases Discussion specific to working with Java Databases. For other Java topics, please see related Java forums. For database discussions not specific to Java, please see the Database category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Java Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 28th, 2006, 11:14 AM
Registered User
  
Join Date: May 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to Iterate over large number of records
Hi All,

Please take some time out and give your thoughts on the following use case.

There are 300000 records in the database table.
But when I query this table for all records I get 99999 records only.

Seems there is limitation on number of records that can be fetched from result set. Is it related to driver restriction?

Database:- Sybase
Driver:- com.sybase.jdbc3.jdbc.SybDriver
JDK 1.5

Even I tried using Statement.setMaxRows(300000) but that didn’t worked out.
And it continued to fetch 99999 records only.

Is anyone aware of any such issues/limitations and is there any solution?
Please share your ideas.

Thanks.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Query database with large number of records andyj00 ASP.NET 1.0 and 1.1 Professional 6 June 27th, 2005 08:47 PM
Inserting Large Number of Records mjackson11 Access 2 December 8th, 2004 04:50 PM
Number of records Pharasite Classic ASP Databases 4 July 1st, 2004 02:00 AM
unable to insert records into database everest Classic ASP Databases 11 March 22nd, 2004 02:28 PM
unable to insert records into access DB bn_sree Access ASP 0 October 8th, 2003 08:38 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.