Results 1 to 2 of 2
  1. #1
    lmenaria is offline Member
    Join Date
    Jul 2007
    Posts
    1
    Rep Power
    0

    Default How to read block of rows from database tables

    I have created a Database Application in Java and display all the records in tabular format of one Table. This table have Millions of Rows, If I run Select * from Table, then my Machine not responding, so Now I wants to add paging of 1000 rows at one time.

    Is there are any option to read block of rows at one time and then query again for next page ?

    Please let me know..

    Database : SQL Server 2000/2005, Oracle and MYSQL

    Thanks in Advance
    Laxmilal

  2. #2
    goldhouse is offline Senior Member
    Join Date
    Mar 2007
    Posts
    134
    Rep Power
    0

    Default

    If you are using hibernate it has options like setMaxResults(), firstResults(), lastresults() etc but if not you have to write your own using your own logic and it is dependent on databse tooo

Similar Threads

  1. Deleting All rows in the JTable
    By surot in forum New To Java
    Replies: 1
    Last Post: 04-16-2008, 10:44 AM
  2. Listing tables of a database
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-12-2008, 09:30 AM
  3. Fetching rows from DB
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-06-2008, 09:23 AM
  4. Replies: 0
    Last Post: 12-23-2007, 07:50 AM
  5. display rows in jtable
    By osval in forum AWT / Swing
    Replies: 1
    Last Post: 08-06-2007, 08:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •