...
For debugging purpose it is possible to start the JDBC from the stand-alone FEWS Explorer. With the F12 key you get a list of debug options. Select "start embedded vjdbc server". The service will start and can be accessed from a database viewer.
Setting up connection in DbVisualizer
- 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.
- 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).
- 3. Add a newJDBC 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.
4. Create a new Database Connection in DbVisualizer. - Give it the Alias "Aa en Maas 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.