Subject Re: [Firebird-Java] Re: Accessing Firebird via Jaybird for LibreOffice, tables with more
Author Mark Rotteveel
On Fri, 6 Mar 2015 13:45:34 +0300, "Arioch The ariochthe@...
[Firebird-Java]" <> wrote:
> just a matter of interest
>> Using the jdbc:firebirdsql:oo defaults to holdable.
> i wonder if default for holdable could be passed as the connection
> string optional parameter rather than sub-protocol

Of course that is also possible, see
(look for defaultHoldable), but there are also some other differences in
the implementation between jdbc:firebirdsql:// and jdbc:firebirdsql:oo://,

> also does JayBird log if it was connected by main protocol or by oo-sub
> just if the application unfamiliar with subprotocols would parse the
> connection url way too greedy

I believe it does log it, but I am not 100% sure. However applications -
usually - don't parse JDBC-urls as JDBC urls are opaque; that is:
everything after the vendorid (eg firebirdsql) in jdbc:vendorid: is driver
specific, so having applications parse URLs doesn't make much sense (even
if most drivers adhere to a relative common URL definition). I know for
sure that LibreOffice doesn't do any parsing and passes the jdbc URL as is.