macromedia flash flash remoting: java pagedResultSet problem -- macromedia flash flash remoting

You're in the

macromedia flash flash remoting

group:

java pagedResultSet problem

killjoy_tr
10/4/2004 11:10:42 AM

macromedia flash flash remoting: Hello,

I've been trying to make use of PagedResultSet created in a servlet the way
below;

Connection connection = getConnection("oracle_map");
Statement statement = connection.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_UPDATABLE);
ResultSet resultSet = statement.executeQuery(strSql);

CachedRowSetImpl crs = new CachedRowSetImpl();
crs.populate(resultSet);
pagedResultSet = new PagedResultSet(crs,5,false);

at this point I need paging. I tried below code to get the records from 5 to
10;

Map pagedMap = pagedResultSet.getRecords(5,10);
Vector pagedVector = (Vector)pagedMap.get("Page");

Unfortunately all the first 10 records return :-((((( How can I get only
records between?

Thanks in advance

Re: java pagedResultSet problem

Pete
10/4/2004 2:39:25 PM

The PagedResultSet always works by returning the first page of data... then,
based on the client data retrieval mode, subsequent data can be retrieved.
This means that the first 5 records arrive on the first response.

[quoted text, click to view]

Re: java pagedResultSet problem

killjoy_tr
10/5/2004 12:49:24 PM

Hi,

Thanks for responding. I created a pagedResultSet the way below and return it
from the servlet ;

crs = new CachedRowSetImpl();
crs.populate(resultSet);
pagedResultSet = new PagedResultSet(crs,5);

on the Flash side, I use below responder function to set the dataProvider of
the grid;

function pageservlet_Result (result_rs){
result_rs.setDeliveryMode("page",5);
_root.data_grd.dataProvider=result_rs;
}

Altough I expect to see first 5 records, all the records are returned :-( How
can I fix this?

Thanks

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the macromedia flash flash remoting group.

home · blog · groups

Questions? Comments? Contact the dn