Subject Re: Relative directories in jdbc url
Author Roman Rokytskyy <rrokytskyy@acm.org>
Hi Dave,

> I work on a number of projects that are used by developers all over
> the place. As such when the checkout the source they often need to
> change the jdbc url to reflect the location of their .gdb file.
>
> I wondered if a syntax would be possible in the url to signify that
> the url is for localhost and relative to the current directory. The
> driver would expand the path before passing onwards.
> ....
> What do you think?

In general this is good idea, but I would vote against adding this
feature into main driver before release. You can solve this issue
relatively easy by subclassing org.firebirdsql.jdbc.FBDriver class
and register your subclass in java.sql.DriverManager for a different
URL.

Later (after relase) we will think about making URL scheme more
extensible. There are some research in developing type 2-like JDBC
driver that will use embeddable Firebird 1.5 (so, finally that will
be an embeddable database with JDBC interface). If this succeeds, we
will need to have scheme like JDataStore has:

jdbc:firebirdsql:remote:localhost/3050:/database/my.gdb
jdbc:firebirdsql:embedded:localhost/3050:/database/my.gdb
jdbc:firebirdsql:local:localhost/3050:./database/my.gdb

This will need some FBDriver redesign, but then we can include your
scheme to.

Best regards,
Roman Rokytskyy