|
From: Xavier V. <Xav...@Su...> - 2005-07-26 12:20:48
|
all, thanks for these explanations. Le 26 juil. 05, =E0 07:32, Rowe, Neville a =E9crit : > Early versions of the jdk didn't have a method to set the timeout o= n an > individual statement, so some drivers derive something from the log= in > timeout to do a query timeout also - e.g. Opta2000 (ms sql server f= rom =20 > inet > software) uses something like 5 * login timeout for a query timeout= . =20 > That's > then overridable by a system property I think. > > That said, individual query timeout was added - I think in jdk 1.3 = or =20 > 1.4 - > as a SetQueryTimeout method on the Statement object. > > So I suspect the answer to the question is it depends on Xaviers jd= bc > driver. > > Neville > > -----Original Message----- > From: squ...@li... > [mailto:squ...@li...] On Behalf O= f =20 > 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 Strateg= ies =20 > from > IBM. Find simple to follow Roadmaps, straightforward articles, = =20 > informative > Webcasts and more! Get everything you need to get up to speed, fast= . > http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick > _______________________________________________ > Squirrel-sql-users mailing list =20 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------ > > > -------------------------------------------------------------------= ----=20 > --------- > The information contained herein is confidential and is intended = =20 > solely for the > addressee. Access by any other party is unauthorised without the = =20 > express > written permission of the sender. If you are not the intended =20 > recipient, please > contact the sender either via the company switchboard on +44 (0)20 = =20 > 7623 8000, or > via e-mail return. If you have received this e-mail in error or wis= h =20 > to read our > e-mail disclaimer statement and monitoring policy, please refer to > http://www.drkw.com/disc/email/ or contact the sender. 3167 > -------------------------------------------------------------------= ----=20 > --------- > > --=20 Xavier VIGOUROUX - sun microsystems |
