Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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"JDBC service install.zip

6 unzip the "JDBC service install.zip" to a directory at the same level as the bin and application directory, eg. like "service"
7 replace in the file "run_installscript.bat" the BIN directory and the FEWs application name and directory
8 run the batch file "run_installscript.bat"
9 go to the services window and define the correct properties for the just installed service, like

  • automatic startup
  • correct user settings in login tab
  • restart options after 5 minutes

Notice that the batch calls the file install_JDBC_Service.bat, that contains a list of the *.jar files in the bin directory. If these filenames have changed or the list has changed, this list should be updated. If not, running the service may not be successful. Also notice that your JAVA_HOME environment variable has been set and refers to your JRE directory. This JRE directory should not contain space characters in the name. If so, make a copy of your JRE to a directory with a name without space and set in the run_installscript.bat the JAVA_HOME variable to this new path.

Linux

Step 1: Install an OC

...

Step 5: Stop the FEWS JDBC service by typing exit in the console window where the JDBC startup script was executed. An other option is to kill the process of the FEWS JDBC service.

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"

6 unzip the "JDBC service install.zip" to a directory at the same level as the bin and application directory, eg. like "service"
7 replace in the file "run_installscript.bat" the BIN directory and the FEWs application name and directory
8 run the batch file "run_installscript.bat"
9 go to the services window and define the correct properties for the just installed service, like

  • automatic startup
  • correct user settings in login tab
  • restart options after 5 minutes

Notice that the batch calls the file install_JDBC_Service.bat, that contains a list of the *.jar files in the bin directory. If these filenames have changed or the list has changed, this list should be updated. If not, running the service may not be successful. Also notice that your JAVA_HOME environment variable has been set and refers to your JRE directory. This JRE directory should not contain space characters in the name. If so, make a copy of your JRE to a directory with a name without space and set in the run_installscript.bat the JAVA_HOME variable to this new path.

Example SQL queries