connection through jaybird on fedora 15 linux

I was having some problems to connect to a Firebird database on my linux box. altough the same configuration has worked for my windows environment, clearly it was not the case for linux. it keep throwing the “GDS Exception 335544721”. after digging for a while, I discovered a way to make it work. I must say, I installed the JayBird for Mandriva for the .jar and the  .so files. you can download it here.

my jdbc url was something like:

String databaseURL = "jdbc:firebirdsql:localhost/3050:c:/path/to/database.fdb";

and I the full exception thrown was:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721. Unable to complete network request to host "localhost".
Reason: Unable to complete network request to host "localhost".
	at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:122)

to solve it, just add put your jdbc url in the following format:

String databaseURL = "jdbc:firebirdsql:native:localhost/3050:c:/path/to/database.fdb";

(see the “native” thing?)

and we’re done!

this also works, of course, if you’re having any trouble connecting on iReport.

links:
JayBird for Mandriva



Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s