Introduction
This page now contains the explanation and files for Firebird version 2.x (used in current FEWS builds)
See attachments for files
Copy the following files to the On this page $DBVIS_DIR
refers to the install directory of DBVisualizer, e.g c:\Program Files\DbVisualizer-6.x.y
on Windows or /opt/DbVisualizer-6.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)
Copy native libraries and additional files (Linux)
Copy the following file files to the c:\Program Files\DbVisualizer-6.x.y\lib directory:
connector.jar
Copy jaybird-2.1.6p.jar to c:\Program Files\DbVisualizer-6.x.y\jdbc\firebird
...
$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
Set environment variables (Linux)
The Firebird drivers needs the following two environment variables set; replace $DBVIS_DIR
with the directory where DBVisualizer has been installed.
Code Block |
---|
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.
Code Block | ||||
---|---|---|---|---|
| ||||
#!/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
Code Block |
---|
URL: jdbc:firebirdsql:embedded:<filename.fdb> e.g. jdbc:firebirdsql:embedded:d:\FEWS\testfews\EFAS\localDataStore\local.fdb |
...
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)