Pruteanu Dragos wrote:

> Hi,
>
> 1 year ago I had an issue by connecting to Firebird from Windows, using URLClassLoader for loading the driver, from DbSchema.
> You recomended me to check the URL, to be like
> jdbc:firebirdsql: host: /path/to/ db.fdb

What is the actual URL you are using.

> With the latest Firebird version from website this error comes up again, even if I use the correct URL:

What version of Firebird and what version of Jaybird

> java.sql.SQLException: java.lang.UnsatisfiedLinkError: no jaybird21 in java.library.path

> Also, strange is that the host has to be local. If I set localhost, I receive a strange error (
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544382. Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long
> Reason: Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long )

If you specify 'local' you are not specifying a hostname, but
instructing the driver to use the 'local' driver, which uses an external
JNI library for the connection. Since you did not specify that external
library on your classpath(? not sure, usually don't use JNI) or using
-Djava.library.path=... the driver won't load.

The error you get when you are using the pure Java driver, might have
something to do with this : http://tracker.firebirdsql.org/browse/JDBC-101

But otherwise you have to be more specific about the connection
properties you use.

--
Mark Rotteveel