#55 Add support for lock_timeout in JDBC URL

[TomK]

The MS SQL Driver allows to specify a default lock_timeout for the connection directly in the JDBC url (using e.g. ;lockTimeout=0)

With jTDS this is not possible.

When connections are creating through a DataSource there is no possibility to deifne a SQL statement that should be run when the connection is established, so the only way is the JDBC url

[momo]

This sounds quite reasonable. I'll include a lockTimeout property in one of the next releases of jTDS.

Cheers,
momo

[Mr.Sea]

The lockTimeout property in URL is an absolute requirement for Java EE App.Servers.
I have long running queries and I have to set LOCK_TIMEOUT for every connection.
There is not any workaround if you are using DataSource in a app. server pool.
Please add this property to URL. I think that the priority for this request has to be 9
I don't want to use Micro$oft JDBC driver for only this requirement.
Thanks,

[Mr.Sea]

Also you can see this post; https://sourceforge.net/projects/jtds/forums/forum/104389/topic/3294182

I am sure that MS driver has "lockTimeout" property in URL and datasource;
http://msdn.microsoft.com/en-us/library/ms378988.aspx
http://msdn.microsoft.com/en-us/library/ms379052.aspx