jconn driver not respecting connection properties

manpreet Best Answer 2 years ago

We are using jconn4.jar to connect to Sybase server using java code. The problem is that sometimes when reading/writing data to the Sybase server, the server hangs which keeps the connection that was made to the server open. We are checking using sp_who and select * from master..sysprocesses.

This is a scenario that is reproducible on a server that is not accessible to us and we are not able to reproduce on the Sybase server that we have with us. To try to mitigate this issue we used DEFAULT_QUERY_ TIMEOUT connection property in the url(jdbc:sybase:Tds:XXX.XXX.XXX.XXXX:X?DEFAULT_QUERY_ TIMEOUT=10). Unfortunately this property is not respected by the driver and may be an issue with the driver. We have used two driver versions (jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17993/JDK16/Thu Jun 3 3:09:09 2010 and jConnect (TM) for JDBC(TM)/7.07 SP140 (Build 27377)/P/EBF28026/JDK 1.6.0/jdbcmain/OPT/Thu Apr 26 00:07:49 PDT 2018) but both do not seem to respect the connection properties that we provide from url.

Is this known behaviour? Is there any documentation where we can find all the jconn jar that have been released and known bugs fixed?