#55 Add support for lock_timeout in JDBC URL

open
momo
None
5
2012-08-15
2008-11-04
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





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks