Ask Your Question
0

How access Firebird employee db via JDBC?

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

PaulDBreneman gravatar image

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

I'm trying to simplify things: Firebird

But I need help connecting to the default employee database.

edit retag flag offensive close merge delete

Comments

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

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

1 Answer

Sort by » oldest newest most voted
0

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

kelsa gravatar image

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

Extract the jaybird-jdk18-4.0.0-beta-1.zip, then add the folder to the Class Path in LibreOffice and restart >LibreOffice: https://help.libreoffice.org/6.3/en-U...

...

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: 127.0.0.1:d:\databases\mydatabase.fdb

Read: https://www.ibphoenix.com/files/Conne...

edit flag offensive delete link more

Comments

Thanks! That got me further.

PaulDBreneman gravatar imagePaulDBreneman ( 2019-08-14 19:15:17 +0200 )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 +0200 )edit

Hello,

Try replacing the space with %20.

Ratslinger gravatar imageRatslinger ( 2019-08-15 02:38:54 +0200 )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 +0200 )edit

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

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

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

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

@PaulDBreneman,

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

firebirdsql:oo://localhost//var/lib/firebird/3.0/data/employee.fdb?charSet=UTF-8

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 +0200 )edit

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

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

Question Tools

1 follower

Stats

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

Seen: 38 times

Last updated: Aug 14