ListGrid DataSource example

[mookieit]

Hello,

Can a member please direct me or provide a basic simple code example(client and server side) on how to get data from the server to the client by leveraging the fetch row functionality of the smart GWT framework.

The server gets data from an Oracle database.

Ultimately would want the client to fire a query on the server and for example fetch 100 rows from the server at a time.

This is asked because the ListGrid is causing IE8 to popup a slow script message when a many rows are returning to the client.

Currently using SmartGWT 5.0p.

I will appreciate all assistance.

Thank you.

[Blama]

Hi mookieit,

did you read these?

• SmartGWT FAQ
• SmartGWT Quick Start Guide (PDF)

Make sure to read the QSG cover to cover.

Regarding your example: The EE BuiltInDS sample included in the download already does what you are looking for.
It uses a local HSQLDB it starts itself. You can see the SQL sent to the DB in the server log, just like it would be the case with Oracle.
You can also see the data limiting there used to save bandwidth and provide the client the currently needed records only.

Hope this helps, Best regards,
Blama