RE: [Squirrel-sql-users] login timeout vs SQL timeout

[Rowe, N. <Nev...@dr...>]

Early versions of the jdk didn't have a method to set the timeout on an
individual statement, so some drivers derive something from the login
timeout to do a query timeout also - e.g. Opta2000 (ms sql server from inet
software) uses something like 5 * login timeout for a query timeout. That's
then overridable by a system property I think.

That said, individual query timeout was added - I think in jdk 1.3 or 1.4 -
as a SetQueryTimeout method on the Statement object.

So I suspect the answer to the question is it depends on Xaviers jdbc
driver.

Neville

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of Rob
Manning
Sent: 25 July 2005 19:50
To: Xavier Vigouroux
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] login timeout vs SQL timeout


Xavier Vigouroux wrote:

> Hi,
>
> squirel has a time-out mechanism named "login timeout".
> What I can conclude is that this timeout is in fact effective for any
> SQL command sent to the DB.
>
> I wonder if the name is correct?
>
>
Looks to me like this is used to as the value for 
DriverManager.setLoginTimeout (Application.java : 678) According to the
JavaDocs for DriverManager, setLoginTimeout does the 
following:

"Sets the maximum time in seconds that a driver will wait while 
attempting to connect to a database. "

Looks ok to me.  Not sure what you would use to set the timeout on any 
given SQL statement.

Rob





CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from
IBM. Find simple to follow Roadmaps, straightforward articles, informative
Webcasts and more! Get everything you need to get up to speed, fast.
http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Squirrel-sql-users mailing list Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
 ------


--------------------------------------------------------------------------------
The information contained herein is confidential and is intended solely for the
addressee. Access by any other party is unauthorised without the express
written permission of the sender. If you are not the intended recipient, please
contact the sender either via the company switchboard on +44 (0)20 7623 8000, or
via e-mail return. If you have received this e-mail in error or wish to read our
e-mail disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender. 3167
--------------------------------------------------------------------------------