Home > Archive > SQL Server JDBC > April 2006 > lock_timeout









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author lock_timeout
JI

2006-03-28, 9:23 am

we need to set a global lock_timeout value on our jdbc driver. Right now,
the only way we can set it is to run a Set Lock_Timeout call previous to
every statement.

Here are the parameters:
WAS
Driver: com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource

Thanks.


Sue Purkis

2006-04-03, 8:23 pm

JI,

We tested this out. You only need to execute the Set Lock_Timeout call
once per connection. It will then be in effect for all statements that are
executed on that connection. There is currently no connection option for
setting the lock timeout.

I hope this helps.

Sue Purkis
DataDirect Technologies.


"JI" <jidawgs@gmail.com> wrote in message
news:e5XsITnUGHA.5372@TK2MSFTNGP09.phx.gbl...
> we need to set a global lock_timeout value on our jdbc driver. Right now,
> the only way we can set it is to run a Set Lock_Timeout call previous to
> every statement.
>
> Here are the parameters:
> WAS
> Driver: com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource
>
> Thanks.
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com