Support Forums: Message List - Scrollable results sets for 100,000+ rows... http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Thu, 23 May 2013 12:48:39 -0400 Re: setFecthSize() http://www.theserverside.com/discussions/thread.tss?thread_id=25625 Tue, 29 Aug 2006 20:12:17 -0400 Tue, 29 Aug 2006 20:12:17 -0400 Tue, 29 Aug 2006 20:12:17 -0400 Aug 29, 2006 Abhinav Arora 0 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625
Does...]]> Fri, 30 Apr 2004 12:42:33 -0400 Fri, 30 Apr 2004 12:42:33 -0400 Fri, 30 Apr 2004 12:42:33 -0400 Apr 30, 2004 me havename 0 setFecthSize() http://www.theserverside.com/discussions/thread.tss?thread_id=25625 Fri, 30 Apr 2004 12:37:56 -0400 Fri, 30 Apr 2004 12:37:56 -0400 Fri, 30 Apr 2004 12:37:56 -0400 Apr 30, 2004 me havename 0 setFecthSize() http://www.theserverside.com/discussions/thread.tss?thread_id=25625 object does not mean that object is populated with all of the database data for the query. Modern JDBC drives will "lazy-load" data in chunks from the database as you step through the ResultSet. The...]]> Fri, 30 Apr 2004 10:18:39 -0400 Fri, 30 Apr 2004 10:18:39 -0400 Fri, 30 Apr 2004 10:18:39 -0400 Apr 30, 2004 Paul Strack 0 setFecthSize() http://www.theserverside.com/discussions/thread.tss?thread_id=25625 Fri, 30 Apr 2004 09:26:34 -0400 Fri, 30 Apr 2004 09:26:34 -0400 Fri, 30 Apr 2004 09:26:34 -0400 Apr 30, 2004 Raffi Basmajian 3 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625
If you...]]> Fri, 30 Apr 2004 07:43:12 -0400 Fri, 30 Apr 2004 07:43:12 -0400 Fri, 30 Apr 2004 07:43:12 -0400 Apr 30, 2004 Senthil Chinnaiyan 1 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625
All databases have a default buffer size or tuple size that is sent. Unless you specify stmt.setFetchSize(), the driver will fetch the default tuple size (for example, in Informix,...]]> Thu, 29 Apr 2004 23:36:54 -0400 Thu, 29 Apr 2004 23:36:54 -0400 Thu, 29 Apr 2004 23:36:54 -0400 Apr 29, 2004 me havename 4 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625
Ravi]]> Thu, 29 Apr 2004 23:02:28 -0400 Thu, 29 Apr 2004 23:02:28 -0400 Thu, 29 Apr 2004 23:02:28 -0400 Apr 29, 2004 Ravi Srinivasan 0 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625
Most JDBC drivers use these...]]> Thu, 29 Apr 2004 20:41:51 -0400 Thu, 29 Apr 2004 20:41:51 -0400 Thu, 29 Apr 2004 20:41:51 -0400 Apr 29, 2004 Paul Strack 0 Scrollable results sets for 100,000+ rows... http://www.theserverside.com/discussions/thread.tss?thread_id=25625 Statement st = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

ResultSet rs = statement.executeQuery("Select * from products");

Let's...]]> Thu, 29 Apr 2004 14:56:27 -0400 Thu, 29 Apr 2004 14:56:27 -0400 Thu, 29 Apr 2004 14:56:27 -0400 Apr 29, 2004 Raffi Basmajian 9