Commented by: Roman Rokytskyy (rrokytskyy)

Very strange. First of all, Jaybird makes no difference between CS and SS - it simply does not know this. Also it should make no difference between the old and new URL, but I can accept that there is a bug in the parser... I will check it, but frankly I have no idea where to start.

Commented by: Wade Chandler (wadechandler)

I have just experienced this on OpenSuSE 10.3. I knew the server was running fine as I could do a:
connect 'localhost:/path/to/db' user 'username' password 'password';

and connect fine from isql.

In JayBird I was trying to use:
jdbc:firebirdsql://localhost:3050/var/firebird/databases/database.fdb

but found only:
jdbc:firebirdsql:localhost/3050:/var/firebird/databases/database.fdb

would work. If I did not use this format of the URL then I would get the exact error reported here. I am using the SS server as well, and I know I can connect to it using the old format. It seems to me to track down the error one needs to debug through the code and see what parameters remain after the URL is parsed and what is used to make the actual connection. I'll see if I can do this at some point.

Commented by: @mrotteveel

A similar error was raised in Firebird-Support today (although there changing the url did not help).

I took another look at the code and the original issue reported has to do with the fact that the URL specification is:

jdbc:firebirdsql://host:port/path-to-db

If on a Unix/Linux environment the path is /opt/firebird/database.fdb the resulting URL should be:
jdbc:firebirdsql://localhost:3050//opt/firebird/database.fdb (note the two slashes after the port)

The perceived differences between SuperServer and Classic could be the result from different RootDirectory settings in firebird.conf (default is root (/))

Commented by: @mrotteveel

Added explicit warning in releasenotes that the databasepath should include the root slash (/) in the path for Linux.