Commented by: @mrotteveel

Scheduled for 2.3, if easy/small also backport to 2.2.2

Commented by: hugo Larsson (hugol)

It would be fantastic if this feature could be implemented in version 2.2.2

Commented by: @mrotteveel

Firebird has the dpb item isc_dpb_connect_timeout which is the connect timeout in seconds. I will add support in Jaybird for this dpb item, which will fallback to the loginTimeout specified in DriverManager. If no timeout is specified (and DriverManager.getLoginTimeout() returns 0), then the timeout will be OS dependent (for example: about 20 seconds on Windows 8).

This also means the timeout cannot have a subsecond value. I could add a millisecond variant, but that would only work for the pure java driver and not for the JNI driver.

Commented by: @mrotteveel

Got it working for pure java, but the native library seems to ignore the isc_dpb_connect_timeout item.

Commented by: @mrotteveel

Committed implementation to trunk, it however won't work with native (where isc_dpb_connect_timeout seems to be a timeout for executing op_accept after establishing the socket connection). Will need to look into this further, also if I need to use the connectTimeout in the pure-java implementation as the SoTimeout during the op_accept fase.

Potential workaround for the lack of a socket connect timeout with native would be to construct an InetAddress and call isReachable with the timeout, but I am not sure if that is a good idea, because establishing a connection on a slow link might take even longer.

Commented by: @mrotteveel

Added subtask to backport to 2.2.2