JDBC Drivers for Firebird must be downloaded from the vendor and are not bundled within Aqua Data Studio. Each registered Firebird server in Aqua Data Studio requires the use of the Generic JDBC connection type and the jaybird-full-x.x.x.jar Firebird JDBC driver that is written for the version of Firebird you have installed.

Aqua Data Studio (ADS) supports Firebird Database Schema. Firebird is a very popular RDBMS maintained by the Firebird Project at SourceForge.

Contents

Driver Location

You may locate the latest Firebird JDBC drivers at the following location ...

Vendor: Firebird
Website: http://www.firebirdsql.org
Download Page: http://www.firebirdsql.org/en/downloads/
Driver URL: http://www.firebirdsql.org/en/jdbc-driver/
Database Product: Firebird
Description: Firebird is an open-source relational database offering many ANSI SQL standard features that run on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

Updating Driver Contents for use Firebird

To update Firebird JDBC drivers download the latest available driver for your version of Firebird and edit the Server Properties > General > Location > Driver Location input field so that it points to driver you most recently downloaded.

When entering the database location within windows, make sure the database url paths follow this example, any \ should become \\.

jdbc:firebirdsql:localhost/3050:C:\\Program Files\\Firebird\\Firebird_2_1\\examples\\empbuild\\EMPLOYEE.FDB

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.

Firebird tutorial for Aqua Data Studio to Connect Firebird Database


Create Server GroupRegister a FirebirdServerEnter PropertiesLocate Firebird Driver

Firebird Driver PropertiesFirebird Server in ADSFirebird SchemaCreating tables in Firebird

 To connect to Firebird Database using Aqua Data Studio:

  • Download Firebird Relational Database Engine and Install the RDBMS.
  • Download Firebird JDBC driver from the URL given above to your local machine
  • Create a new server Group and name it as Firebird
  • Right Click on server group and click on the the Item which displays Register Server
  • Provide a new name for the Firebird Server
  • In the General tab, pick Generic - JDBC
  • Specify a URL. Enter jdbc:firebirdsql:localhost/3050:C:\\pathtodatabase\\SampleDB.FDB where SampleDB is the Firebird database you want to Connect to (only windows user require paths to be formatted with escaped \, like C:\\pathtodatabase\\SampleDB.FDB ;while Linux and OSX would use /pathtodatabase/SampleDB.FDB)
  • Provide org.firebirdsql.jdbc.FBDriver in the Driver field
  • Locate the  downloaded driver by clicking on Browse. For e.g the downloaded driver in this sample is jaybird-full-2.2.1.jar

The Firebird Database server is registered successfully in Aqua Data Studio. You can now connect to the newly registered Server and perform Data Manipulations.




  • No labels