Download Latest Version jdbc-valve-extension-1.0.jar (18.7 kB) Get Updates
Home
Name Modified Size InfoDownloads / Week
source 2011-08-30
0
README.txt 2011-08-30 1.5 kB
0
HSqlTool-Readme.txt 2011-08-30 621 Bytes
0
jdbc-valve-extension-1.0.jar 2011-08-30 18.7 kB
0
Totals: 4 Items   20.8 kB 0 
Tomcat JDBC Valve Extension application that monitors the Http Request/Response.


Integrate the jdbc-valve-extension application on tomcat server
--------------------------------------------------------------
1. Assuming an existing tomcat web server at least version 5

2. Download hsqldb_1_8_0_10.zip from "https://sourceforge.net/projects/hsqldb/files/hsqldb/". The HsqlDB store the information and has the GUI tool to query the Http Request/response.

3. Extract the hsql to a working folder (say E:\)

4. Next Edit tomcat's server.xml; add
<Valve className="net.healthlink.catalina.valve.JDBCAccessLogValveExtension" driverName="org.hsqldb.jdbcDriver" connectionURL="jdbc:hsqldb:hsql://localhost/formdb" connectionName="SA" connectionPassword="" resolveHosts="true" persistenceEnabled="true" persistenceType="batch" queueMaxSize="50" dbAutoStartEnabled="true" dbProperties="databaseFileBase=E:/hsqldb/data/form-db"/>

Ensure the path of HSQL is valid. For example, E:/hsqldb/data/form-db points to the physical database file where you have defined in the dbProperties.
 
5. Copy the "jdbc-valve-extension-1.0.jar" and "hsqldb.jar" (from the extracted hsql's lib folder) to the tomcat's lib folder.

6. Restart tomcat.

7. Access the tomcat server's web page via Http.

8. Run Hsql tool (runManagerSwing.bat) to query records.


Note: The database starts once tomcat has started. When tomcat is shutdown, the database is shutdown as well.
Source: README.txt, updated 2011-08-30