...
Step 4: Start the FewsJdbcServer by clicking on the <OC-Name>_JDBC.exe. The Server will start as an OC and synchronise its localDataStore with the Central Database using the synchprofiles of an OC.
Step 5: Stop the FewsJdbcServer by killing the application using the System Monitor. In the attachements an exe is provided that opens a console window. If this console window is stopped, the FEWS JDBC driver process is also stopped.
Install windows service
Follow the above listed steps to install and test the JDBC server. Finally stop the server and proceed with the next steps, based on the attached file JDBC service install.zip
Step 6: unzip the "JDBC service install.zip" to a directory at the same level as the bin and application directory, eg. like "service"
Step 7: replace in the file "run_installscript.bat" the BIN directory and the FEWs application name and directory
Step 8: run the batch file "run_installscript.bat"
Step 9: go to the services window and define the correct properties for the just installed service, like
...
Setting up connection in DbVisualizer
Step 1: Install DbVisualizer on your PC. Make sure it is not installed in a folder with spaces, such as "Program Files". When there is a space in the folder name, it will NOT work correctly. This is a DbVisualizer bug that can not be solved by FEWS.
Step 2: Copy the files "commons-logging-1.1.jar" and "vjdbc.jar" to a folder on your computer. These are the drivers used by
...
DBVisualizer. Also this folder name should not contain any space characters (use the 8.3 format).
Step 3
...
: Add a
...
new JDBC driver to DBVisualiser:
- Start DbVisualizer
- Open the Tools menu and the Driver Manager
- Create a new driver and give it the name "vjdbc". Load the two jar files in the "User Specified" tab. * Close the Driver Manager Window.
Step 4
...
: Create a new Database Connection in DbVisualizer.
- Give it the Alias "
...
- <OC-Name> JDBC"
- Select the vjdbc driver
- Enter the database URL: "jdbc:vjdbc:rmi://145.9.227.80:2000/VJdbc,FewsDataStore". The number "145.9.227.80" is the IP adress of the Server where the database is located. (you can get the IP adress by typing ipconfig in the command line of the Server). The number "2000" is the default port number, the correct port number is shown in the FEWS log file on the Server when it is started.