LCDS Paging, Flex and CF

When I first heard about LiveCycle Data services and that it has the ability to page large datasets I though cool how do I make it do it?

The idea here is to use Coldfusion as the Assembler. I already had a working sample using LiveCycle with CF on the back-end and Flex on the front-end all I needed to do was add more data to the Contacts.mdb file and then turn paging on. At least everything I read so far indicated that I wouldn't need to do anything special in my fill method in order for paging to work.

I opened up my C:\ColdFusion8\wwwroot\WEB-INF\flex\data-management-config.xml file and added the following:

What that is supposed to do is tell LCDS to return only 50 rows at a time. Simple to understand right?

Ok so then on the Flex side the fill method gets called on creation complete and my Grid is filled with 50 rows, but it's clear to me by looking at the scroll bar that the grid has more than just 50 rows, so I scroll down. Low and behold the rows magically appear as I scroll 50 at a time.

WTF? How cool is that!

So I scroll all the way to the bottom and am happy to see my 600+ rows appear. Cool! I reload the application and do it again this time rapidly scrolling all the way to the bottom. I figured it would take a second or two to get the 600 rows in chunks of 50 so I wait...and wait...and wait...and wait some more. And finally nothing happens.

I restart the CF service, and both ODBC services for good measure since its banging against an Access Database and then try to hit the contactmgr.swf again. After 5 minutes waiting and getting dizzy watching that stupid IE connecting image I shut down everything (.net, both odbc, search, and app server service), hell I even restarted the webserver. Finally! I get the contactmgr.swf to display again with results!

This time I scroll slowly through the records and then all of a sudden I get empty rows again I stop and wait and it catches up to me. I continue scrolling and then again I wait for it to catch up. Eventually I up getting to the bottom. Great. I then quickly scroll to the top and down again a couple of times and suddenly all the rows are gone. When I refresh the application I get the first 50 rows and then after I scroll I get just empty rows...

If I refresh it again it just hangs.

Has anyone else had similar problems?

Perhaps it has something to do with the flex example but its pretty a simple Flex application provided by Adobe, I just modified the Access database by adding 600 or so rows to the contacts table and turned on paging to see what would happen....