Firebird connection with java

Question

I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code:

Class.forName("org.firebirdsql.jdbc.FBDriver"); 

connection = DriverManager.getConnection(
    "jdbc:firebirdsql://localhost/3050//C:/firebird/database/EMPLOYEE.FDB", 
    "test","test");

I am getting following error:

Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544375.
unavailable database 
Reason: unavailable database at 
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:122) at 
org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:140) at 
java.sql.DriverManager.getConnection(DriverManager.java:525) at 
java.sql.DriverManager.getConnection(DriverManager.java:171)

Please help.

Problem solved: Actually I had problem with jar file that I got from

http://mirrors.ibiblio.org/pub/mirrors/maven2

I downloaded jaybird-full-2.1.6.jar from firebird offical website and problem got solved.

Correct URL is

"jdbc:firebirdsql://localhost:3050/C:\\firebird\\database\\EMPLOYEE.FDB"

I tried this URL earlier also but it was not working beacuse of jar issue.

Don't add a "Problem solved" section to the question, post it as an answer instead and accept it. Thanks! — bluish, May 26 '11 at 08:07

trashgod · Answer 1 · 2010-08-08T09:09:55.647

3

As @Thorbjørn Ravn Andersen observes, your Jaybird JDBC URL is incorrect. The syntax is jdbc:firebirdsql:[host[/port]:]<database>. You need a colon between the host/port and the database path. Perhaps something like this:

"jdbc:firebirdsql://localhost/3050:C:\\firebird\database\EMPLOYEE.FDB"

Oops, I left in the leading slashes; try this:

"jdbc:firebirdsql:localhost/3050:C:\\firebird\database\EMPLOYEE.FDB"

Addendum: You might run through the common errors list. Also, my firebird database files end in .fdb, but the FAQ mentions .gdb. It can't hurt to check.

edited Aug 08 '10 at 09:09

answered Aug 06 '10 at 15:23

trashgod

203,806
29
246
1,045

I have tried all the options including url specified by you..nothing is working.. – Rakesh Goyal Aug 06 '10 at 16:07
Is Firebird running on port 3050? Can you connect by any other means, e.g. isql or a GUI client? – trashgod Aug 06 '10 at 16:40
I can connect with isql and flameRobin..it is running on 3050 port..I have tried creating a new database..switching off windows firewall..copying dll's in system 32 (as specified on firebird support group).. – Rakesh Goyal Aug 06 '10 at 16:54
@rakesh-nitj: Sorry, I'm running low on fresh ideas; more above. – trashgod Aug 07 '10 at 04:28
@trashgod:tried .gdb databases as well..anyways posted this question in firebird-java-support group..thanks for your time and efforts! – Rakesh Goyal Aug 07 '10 at 08:05
@rakesh-nitj: I'd like to hear how the problem gets resolved. – trashgod Aug 07 '10 at 11:22
@trashgod:Problem got solved. Please see the updates above. Thanks for your assistance. – Rakesh Goyal Aug 08 '10 at 05:02
@rakesh-nitj: Thanks for updating your question. – trashgod Aug 08 '10 at 09:12
@Thorbjørn Ravn Andersen: Sorry about misspelling your name. :-) – trashgod Aug 08 '10 at 09:13

score 3 · Answer 2 · answered Mar 30 '17 at 14:00

From https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#pure-java-default

Default URL format:

"jdbc:firebirdsql://host[:port]/<database>"

Deprecated, but still supported legacy URL format:

"jdbc:firebirdsql:host[/port]:<database>"

Then, the correct URL should be:

"jdbc:firebirdsql://localhost:3050/C:/firebird/database/EMPLOYEE.FDB"

score 0 · Answer 3 · answered May 29 '14 at 02:41

Looking at the documentation on this site: http://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html, item 3.1

It seems that after the [port], you must have an slash "/" or double slash "//" in case you would connect on a linux server.

score 0 · Answer 4 · answered Aug 06 '10 at 13:42

0

Your URL is most likely broken for this driver.

Attach actual source to the jar and set a breakpoint in FBDataSource.getConnection(...) and see what values are actually present when the connection is attempted made.

Are you absolutely certain that the combination of a hostname with port agrees with a path to the FDB-file?

answered Aug 06 '10 at 13:42

Thorbjørn Ravn Andersen

73,784
33
194
347

I am absolutley sure about connection parameters along with the path of FDB file. – Rakesh Goyal Aug 06 '10 at 13:44

score 0 · Answer 5 · answered Sep 14 '17 at 06:23

0

To connect to the database located on remote machine or cloud (linux) then use following link.

jdbc:firebirdsql:34.212.208.251/3050:/opt/app/db/sample_training.fdb

answered Sep 14 '17 at 06:23

Mayur Lokare

31
3

score 0 · Answer 6 · edited Apr 01 '19 at 11:56

0

You should try this one. It works for me on Windows.

jdbc:firebirdsql://localhost:3050/C:\firebird\database\EMPLOYEE.FDB

Also make sure you added an exception for port 3050 to the Firewall.

edited Apr 01 '19 at 11:56

karel

5,489
46
45
50

answered Apr 01 '19 at 11:35

tjlee

16
2

score 0 · Answer 7 · answered Jan 25 '23 at 14:23

0

Connection string example for Apache Tomcat properties.xml with specified IP, port, data base alias and encoding:

<entry key="db.url">jdbc:firebirdsql:127.0.0.1/2222:my-db-alias?lc_ctype=WIN1251</entry>

answered Jan 25 '23 at 14:23

Kyo

61
6

Firebird connection with java

7 Answers7