Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Firebird JDBC DriverImage RemovedImage Added

Contents

Table of Contents

...

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 runs 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.

...

Firebird tutorial for Aqua Data Studio to Connect Firebird Database


Firebird - Create Server GroupImage Removed

Image Added

Firebird - Register ServerImage Removed

Image Added

Firebird - Registration PropertiesImage Removed

Image Added

Firebird JDBC Driver File SelectionImage Removed

Image Added

Create Server GroupRegister a FirebirdServerEnter PropertiesLocate Firebird Driver
Firebird JDBC Driver LocationImage Removed

Image Added

Firebird - Server RegisteredImage Removed

Image Added

Firebird - Server Registered - Database ObjectsImage Removed

Image Added

Firebird - Server Registered - Tables CreatedImage Removed

Image Added

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 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 the the  downloaded driver by clicking on Browse. For e.g the downloaded driver in this sample is jaybird-full-2.2.1.jar

...