User Tools

Site Tools


h2databasetcpserver

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
h2databasetcpserver [2016/03/06 19:39] – [Configure global logging to the database] pelah2databasetcpserver [2018/11/03 02:59] (current) – external edit 127.0.0.1
Line 42: Line 42:
  
   - Go to the Settings page and enter a GlobalLogger value as **jdbc:h2:tcp:////localhost/nhs_values;USER=sa;PASSWORD=SuperSecretPa$$w0rd**   - Go to the Settings page and enter a GlobalLogger value as **jdbc:h2:tcp:////localhost/nhs_values;USER=sa;PASSWORD=SuperSecretPa$$w0rd**
-  - Create the H2DatabaseServer home item. It is located in the Ports section. Fill in the fields as explained previously+  - Create the H2DatabaseServer home item. It is located in the Ports section. Fill in the fields as explained earlier on this page.
   - Make sure the H2DatabaseServer is enabled   - Make sure the H2DatabaseServer is enabled
  
Line 61: Line 61:
    - The import will start and it can take some time before all values have been imported.    - The import will start and it can take some time before all values have been imported.
    - View and periodically refresh the Log page for progress of the import.     - View and periodically refresh the Log page for progress of the import. 
 +
 +====== View graphs ======
 +When you want to view graphs of the logged data, click the **View graph...** link for home items.
 +
 +Please note that the database server will cache the result on successive views. This means that the first view will take slightly longer but successive views will be faster. This is in any case several times faster than reading the logs from the text files.
  
 ==== See also ==== ==== See also ====
 http://www.h2database.com/html/main.html http://www.h2database.com/html/main.html
h2databasetcpserver.1457289570.txt.gz · Last modified: 2018/11/03 02:57 (external edit)