Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#55 Add support for lock_timeout in JDBC URL

open
momo
None
5
2012-08-15
2008-11-04
thomas kellerer
No

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

Discussion

  • momo
    momo
    2009-08-05

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

    Cheers,
    momo

     
  • Mr.Sea
    Mr.Sea
    2011-08-22

    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,

     


Anonymous


Cancel   Add attachments