On Fri, 6 Mar 2015 13:45:34 +0300, "Arioch The ariochthe@...
[Firebird-Java]" <Firebird-Java@yahoogroups.com> 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
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.7/release_notes.html#__RefHeading__2755_1560579136
(look for defaultHoldable), but there are also some other differences in
the implementation between jdbc:firebirdsql:// and jdbc:firebirdsql:oo://,
see
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.7/release_notes.html#__RefHeading__3761_663895651

> 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.

Mark