Steps

1. Download and install the latest 64

Introduction

Delft-FEWS has currently three flavours of local datastores all of which can be inspected with DBVisualizer.

1. MS-Access (32-bit, Windows only)
2. Firebird (32-bit)
3. Derby

For inspecting a Delft-FEWS local datastore it is recommended to install DBVisualizer and the appropriate Jdbc driver that matches the local datastore format.

Installation of DBVisualizer

...

1. -bit DBVisualizer from the download section of http://www.dbvis.com/.

   Info
   For Windows it is recommended to download the DBVisualizer

...

1. 64-bit with embedded JRE. This way it is guaranteed that the firebird driver is always started with

...

1. 64-bit java. !! Install DBVisualizer in a directory that

...

1. does not contain any spaces

...

1. !!

   
   

2. Extract dbvis_addons.zip into

...

1. the DBVisualizer installation directory

...

Also the following settings in the Windows Environment variables are required.

DBVIS_DIR=$DBVIS_DIR
PATH=.;%DBVIS_DIR%;%PATH%

For linux the following settings are recommended.

...

#!/bin/bash

# Point $DBVIS_DIR to the directory where DBVisualizer has been installed
DBVIS_DIR=/opt/DBVisualizer


# Start the application
$DBVIS_DIR/dbvis $*

1. (e.g. jdbc subfolder and dlls are copied into the DBVisualizer installation directory).
2. Start DBVisualizer (e.g. ignore / close the DriverManager).
3. Import dbvis_settings.jar using File->Import settings. Restart when DBVisualizer prompts to restart.
4. In the list of connections, right-Click on a suitable connection example and duplicate it.
5. Edit the new connection and put in the correct connection details.
6. If the connection doesn't work because of some Java class couldn't be loaded: add the DbVisualizer installation dir to the PATH system environment variable (either using Windows Explorer or using setx /m command) 

Example urls for each local datastore database

Derby

Image Added

jdbc:derby:d:\fews\OC\localDataStore\local.derby

Firebird

Image Added

Installation of the MS Access driver

Select the Jdbc/ODBC bridge and specify the windows jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\datastores\region_home\localDataStore\local.mdb

where d:\datastores\local.mdb is where the MSAccess file is located.

Image Removed

Installation of the Derby Jdbc Driver

If needed copy the latest derby driver from the Delft-FEWS bin dir, e.g. derby-10.8.1.2.jar to the $DBVIS_DIR/jdbc/derby directory.

Specify the database url as where the derby local datastore is located, e.g. jdbc:derby:D:/datastores/region_home/localDataStore/local.derby

Image Removed

Installation of the Firebird Jdbc Driver

For using DBVisualizer with Firebird under Windows specify following environment variable.

LD_LIBRARY_PATH=$DBVIS_DIR/jdbc/firebird

For using DBVisualizer with Firebird under Linux include  the following in the shell profile.

# Setting the variables
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DBVIS_DIR/jdbc/firebird

Copy java libraries (Windows and Linux)

• create the directory $DBVIS_DIR/jdbc/firebird
• copy connector.jar from the FEWS bin dir to $DBVIS_DIR/jdbc/firebird (can also be put globally in $DBVIS_DIR/lib done in see above)

• copy jaybird-2.1.6p.jar from the FEWS bin dir to $DBVIS_DIR/jdbc/firebird

In the driver manager create a firebird driver with the two firebird jars.

and the URL format jdbc:firebirdsql:embedded:

Image Removed

The following Firebird connection properties are required:

...

jdbc:firebirdsql:embedded:d:\

...

fews\

...

OC\localDataStore\local.fdb

...

?lc_ctype=UTF-8

Hsqldb

Image Added

jdbc:hsqldb:file:d:\fews\OC\localDataStore\local.hsqldb\hsqldb

Copy native libraries (Windows)

Copy the following files to the $DBVIS_DIR directory:
fbembed.dll
icudt30.dll
icuin30.dll
icuuc30.dll
ib_util.dll
jaybird21.dll
(NB fbembed.dll depends on MSVCR80.dll }}while {{jaybird21.dll depends on MSVCR71.dll. On some computers you must need to include those also when not available. See the Fews binary or the attachments)

All in one zip file firebird_jdbc_win.zip for Windows.

Copy native libraries and additional files (Linux)

Copy the following files to the $DBVIS_DIR/jdbc/firebird directory:
firebird.conf
firebird.msg
libfbdrop.so
libfbembed.so
libib_util.so
libicudata.so.30
libicui18n.so.30
libicuuc.so.30
libjaybird21.so
security2.fdb

All in one tgz file firebird_jdbc_linux.tgz for Linux.

Note: For this to work, any user wanting to access a firebird localdatastore needs to have write access to the directory where these files are located. Alternatively, the user can create symbolic links to or copies of there files in another directory and set the environment variables below accordingly to point to these "writeable" directories.

Tips and tricks

• The wildcard for texts when using the LIKE statement is % (e.g. SELECT * FROM TimeSeries WHERE moduleInstanceId LIKE '%Import%')
• When looking for a date in an SQL string - use CAST('yyyy-MM-dd HH:mm:ss' as TIMESTAMP)
  (this is equivalent to the ORACLE to_Date command)