Ask Your Question

How access Firebird employee db via JDBC?

asked 2019-08-13 23:16:23 +0100

PaulDBreneman gravatar image

updated 2019-08-13 23:16:55 +0100

I'm trying to simplify things: Firebird

But I need help connecting to the default employee database.

edit retag flag offensive close merge delete


More information needed. How do you connect to the database? Eror message?

kelsa gravatar imagekelsa ( 2019-08-14 18:28:02 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-08-14 19:05:49 +0100

kelsa gravatar image

updated 2019-08-14 19:10:51 +0100

Extract the, then add the folder to the Class Path in LibreOffice and restart >LibreOffice:


JDBC driver class: org.firebirdsql.jdbc.FBDriver does not work!

In Class Path: Add Archive - /path/to/jaybird-full.X.X.X.jar

Connection String:\databases\mydatabase.fdb


edit flag offensive delete link more


Thanks! That got me further.

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-14 19:15:17 +0100 )edit

I copied employee.fdb and it was messed up. How can I edit this to handle the space in the path?

firebirdsql://localhost:3050/c:/Program Files/Firebird/Firebird_3_0/examples/empbuild/employee.fdb

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-14 20:02:07 +0100 )edit


Try replacing the space with %20.

Ratslinger gravatar imageRatslinger ( 2019-08-15 02:38:54 +0100 )edit

Thanks Ratslinger, I'll have to try that. I did get LO to display the tables by using the firebirdsql:oo: protocol. I need to rest. Hard to make an example of the easiest employee db!

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-15 20:37:28 +0100 )edit

How do I use alias: firebirdsql:oo://localhost:employee ?

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-16 13:33:51 +0100 )edit

firebirdsql:oo:localhost/3050:employee seems to work even though still indicates an error.

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-16 16:21:43 +0100 )edit


Not certain what error you are getting. On Linux have used this:


Note that this does not use a port (default), has the full path to the database and includes the Character set used.

Also, I did not use the Jaybird 4.x beta connector but rather the 3.x connector from Firebird. No problems with it.

Ratslinger gravatar imageRatslinger ( 2019-08-16 18:07:23 +0100 )edit

Thanks again! The ?charSet=UTF-8 got rid of the error message.

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-16 18:35:05 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-13 23:16:23 +0100

Seen: 194 times

Last updated: Aug 14 '19