Support Forums: Message List - Pagination JDBC

java.sql.SQLException: Populate data before calling

Wed, 16 Jun 2010 05:33:23 -0400

This error comes whenever u dont populate a RowSet and try to perform operations on it.

...

cached

Fri, 24 Mar 2006 17:15:05 -0500

Okay , I guess there are more surprises than I think.

I tries to close the connection after populating the CachedResultSet and tries to iterate the CRS and get the data. As per specs ( as I understand) , the CRS is supposed to establish a...

cached

Fri, 24 Mar 2006 16:17:06 -0500

Quote:
//I hope this reply will rescue some person from sun's puzzle!
End Quote:

It certainly did rescue me. I struggled for a while trying to make sense of it when it returned all the records without paging.

I crossed the first...

I find a key reason! maybe

Tue, 21 Mar 2006 04:53:00 -0500

public int store_userpage() throws Exception {
// TODO 自动生成方法存根

Cache cache1 = CacheFactory.getInstance();
Connection connection = null;
CachedRowSet rs = new...

CachedRowSetImp Doesnt Work for me

Thu, 29 Dec 2005 03:29:11 -0500

//---------------My CODE------------------------//
CachedRowSet crs = new CachedRowSetImpl();
DBConnector connector=new DBConnector("conf/conf.properties");
Connection con=connector.getConnection();// getting database...

Using RowSet API with Oracle

Wed, 03 Aug 2005 17:44:33 -0400

RowSet paging works for me in the following environment :
JDK1.4.2
Oracle 8i
ojdbc14.jar (It is available with Oracle 10g JDBC downloads. JDBC driver version is 10.1.0.2.0).
rowset.jar (Release 1.0.1 available from

Pagination JDBC

Tue, 02 Aug 2005 11:50:58 -0400

Have you checked out Sun's Rowset Implementation 1.0.1 ? The CachedRowset implementation contains paging functionality. Let us know how that works.

Pagination JDBC

Wed, 20 Jul 2005 06:11:10 -0400

You can use application server caching option and avoid the database trip for paging. It also depends upon the application if the data is not updated by the other application you can write your own caching layer in which you cached the data and whenever...

scrollable resultset :(

Tue, 19 Jul 2005 20:05:34 -0400

unfortunatly the scrollable resultset still reads the values from the database:( Better to use a nested inline view to limit the results:

SELECT * FROM
(
SELECT ...
)
WHERE rownum between (20, 40)...

Pagination JDBC

Tue, 19 Jul 2005 01:51:19 -0400

I need to implement pagination for huge amount of records from Oracle 9i db. What's the best way to do it? Are there any readymade classes available for the same? Is it good practice to use scrollable resultset?