Server side grouping and child paging
Server side root paging with grouping rows on server with server side child paging
Do not run this file locally!
Run it from your local or remote web http server where is installed JAVA JRE.
Source files:

GroupingChild.html

(this html page),

Grouping_Layout.xml

(static XML layout),

Grouping_Data.jsp

(server script generates XML list of pages),

GroupingChild_Page.jsp

(server script generates XML for individual root page and also child page),

../Database.*

(source SQL database, table TableData)

You have to copy file hsqldb.jar to your JRE shared lib directory and restart your http server


The JSP service program must have write access to all files database.*


The

hsqldb.jar

is JDBC driver for

HSQLDB database

and is located in TreeGrid distribution in /Server/Jsp/ directory. The shared lib directory is usually jre_install_path/lib/ext and also e.g. in Tomcat is usually tomcat_install_path/shared/lib.
You can use any other SQL database instead of HSQLDB (e.g.

Oracle

,

MS SQL server

,

MySQL

,...), just assign different connection to java.sql.Connection Conn in the *.jsp files. You can run the ../MySqlUTF8.sql script to create the "TreeGridTest" sample database on your SQL server.
Demonstrates server paging with server child paging - group row downloads its children only when it is expanded first time.
This is only simple example with not ideal database access (for every page gets all data). The root pages are downloaded on demand from server (when the page is visible by scrollbars).