Introduction

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

...

Installation of DBVisualizer

Download the latest 64-bit DBVisualizer from the download section of http://www.dbvis.com/. For Windows it is recommended to download the DBVisualizer 64-bit with embedded JRE. This way it is guaranteed that the firebird driver is always started with 64-bit java. Install DBVisualizer in a directory that does not contain any spaces. For Windows and Linux it is required to use a 64-bit JRE.

...

#!/bin/bash

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


# Start the application
$DBVIS_DIR/dbvis $*

Download libraries

First download the firebird_addons_x64.zip. zip file containing all the required additions and extract them into the $DBVIS_DIR.

Derby localdatastore

Installation of the Derby Jdbc Driver

If needed copy 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.

Add the driver to DBVizualizer:

Image Added

Setting up the database connection in DBVizualizer

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

Make sure the Settings format is set to Database URL

Image Modified

Firebird localdatastore

Download libraries

First download the firebird_addons_x64.zip. zip file containing all the required additions and extract them into the $DBVIS_DIR.

Installation of the Firebird Jdbc Driver

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

...

# 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 jaybird-2.1.6p.jar from the FEWS bin dir to $DBVIS_DIR/jdbc/firebird
  
  

...

add the URL format jdbc:firebirdsql:embedded: (note: if the URL Format is not editable through the interface, please edit the dbvis.xml file which can be found in user settings e.g. c:\Users\minett\.dbvis\config70\, D:\duin\.dbvis\config70)

Copy native libraries (Windows)

Copy the following files to the $DBVIS_DIR directory:
fbembed.dll
icudt30.dll
icuin30.dll
icuuc30.dll
ib_util.dll
jaybird22.dll

...

Use the set PATH command using cmd.exe to verify whether the DBVisualizer path is available in the path so that the required dll files can be found.

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

Firebird connection properties

Specify the database url as where the Firebird local datastore is located, e.g. jdbc:firebirdsql:embedded:d:\datastores\region_home\localDataStore\local.fdb

jdbc:firebirdsql:embedded:d:\datastores\region_home\localDataStore\local.fdb
username: sysdba
password: masterkey

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)
• More scripts and suggestions can be found here: How+to+optimize+the+size+of+the+database+-+using+queries+to+determine+the+size+of+the+different+components

...