3.23 Firebird JDBC Drivers

JDBC Drivers - Firebird JDBC Drivers

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

You can get more information about Firebird Database and Firebird Driver here

Vendor: Firebird Foundation Incorporated
Download Page: http://www.firebirdsql.org/download
Driver URL: http://www.firebirdsql.org/driver

Firebird tutorial for Aqua Data Studio to Connect Firebird Database

Firebird has full ACID compliant transactions and is available for Windows, Linux and a vareity of Unix platforms

Create Server Group	Register a FirebirdServer	Enter Properties	Locate Firebird Driver

Firebird Driver Properties	Firebird Server in ADS	Firebird Schema	Creating tables in Firebird

 To connect to Firebird Database using Aqua Data Studio:

• Download Firebird Relational Database Engine and Install the RDBMS. For e.g. Firebird 2.1 which is the recent stable version
• 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
• Provide "org.firebirdsql.jdbc.FBDriver " in the Driver field
• Locate the the downloaded driver by clicking on Browse. For e.g the downloaded driver in this sample is "jaybird-ful-2.1.5.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