3.21 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
|
