HOW-TO look at Firebird localdatastore with DBVisualizer

Introduction

This page now contains the explanation and files for Firebird version 2.x (used in current FEWS builds)

See attachments for files

On this page $DBVIS_DIR refers to the install directory of DBVisualizer, e.g c:\Program Files\DbVisualizer-7.x.y on Windows or /opt/DbVisualizer-7.x.y on Linux

Copy java libraries (Windows and Linux)

create the directory $DBVIS_DIR/jdbc/firebird
copy connector.jar to $DBVIS_DIR/lib
copy jaybird-2.1.6p.jar $DBVIS_DIR/jdbc/firebird

Copy native libraries (Windows)

Copy the following files to the $DBVIS_DIR directory:
fbembed.dll
icudt30.dll
icuin30.dll
icuuc30.dll
ib_util.dll
jaybird.dll
(NB on some computers you must also copy MSVCP71.dll, this file can be found in the fews bin directory)

All in one zip file firebird_jdbc_win.zip.

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

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.

Set environment variables (Windows)

The Firebird drivers may need the following two environment variables set; replace $DBVIS_DIR with the directory where DBVisualizer has been installed.

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

Set environment variables (Linux)

The Firebird drivers need the following two environment variables set; replace $DBVIS_DIR with the directory where DBVisualizer has been installed.

LD_LIBRARY_PATH=$DBVIS_DIR/jdbc/firebird
FIREBIRD=$DBVIS_DIR/jdbc/firebird

This can be easily done a wrapper script which calls DBVisualizer, e.g.

#!/bin/bash


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

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

# Start the application
$DBVIS_DIR/dbvis $*

Connection details

URL: jdbc:firebirdsql:embedded:<filename.fdb>
e.g. jdbc:firebirdsql:embedded:d:\FEWS\testfews\EFAS\localDataStore\local.fdb

username: sysdba
password: masterkey

Only one process can access the local.fdb file at one time. To look at e.g. an OC localdatastore, exit the OC before accessing the localdatastore with DBVisualizer and vice versa.

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)

Page tree