How to Set-up a Fews JDBC Server - Viewer for a FEWS LocalDataStore
Introduction
To be able to query timeseries directly using SQL statements Delft-Fews can be set up to act as a jdbc server. This can be done using an OC configuration (which will log in and automatically syncronise date with the MC, thereby assuring all data is constantly being updated, or by running this stand-alone. In the latter case the system will only export what is in the local datastore at startup.
Fews JDBC API
Installing a FEWS JDBC Server
Step 1: Install an OC
Step 2: Delete the "Log4jConfig.xml" from the "OC" directory. When starting the application a new "Log4jConfig-JdbcServer.xml" file will be generated for logging.
Step 3 Intaling on Windows: Make a new "<OC-Name>_JDBC.exe" and "<OC-Name>_JDBC.jpif" file in the \bin folder. The "<OC-Name>_JDBC.jpif" must contain the following information.
..\jre -mx512m -cp $JARS_PATH$ nl.wldelft.fews.jdbc.FewsJdbcServer <OC-Name>_JDBC