Gantt Run database
Creates Gantt Run data from and saves changes back to database using AJAX
Do not run this file locally!
Run it from your local or remote web http server where is installed JAVA JRE.
Source files: RunDB.html
(this html page),
RunDBDef.xml
(static XML layout),
RunDBData.jsp
(server script generates XML data),
RunDBUpload.jsp
(server script saves XML data to database),
../Database.*
(source SQL database, table
Run),
RunSources.xml
(static XML layout and data for right grid),
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.
This example demonstrates Continuous Run, complex and universal bar type. It supports more bars in one cell, with different features, size, color, class, text and tooltip.
For more Gantt Run features see Gantt Local examples or Gantt tutorials.
For more ways of database communication see Basic Ajax or Form Submit JSP examples.