I think your stuff works, and I think it's our database instead that
doesn't work. Our problem is that we're talking to multiple servers from
one server. But thanks for the info!

terry 

-----Original Message-----
From: Ron Grabowski [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 26, 2005 4:40 PM
To: ibatis-user-cs@incubator.apache.org
Subject: RE: How do I set a query/stored procedure timeout in .net
ibatis?

IBatisNet sets the CommandTimeout property on the IDbCommand using this
code (Gilles: the IsInfoEnabled() check is missing):

try // MySql provider doesn't suppport it !
{
command.CommandTimeout = _connection.ConnectionTimeout; }
catch(NotSupportedException e) { _logger.Info(e.Message); }

If you set your connection timeout on the connection string and the
property gets set on the IDbConnection object, wouldn't it get set on
the command as well?

--- "Heath, Terry" <[EMAIL PROTECTED]> wrote:
> The timeouts in connection strings usually apply to the initial 
> connection timeout only, though this could differ from db to db.
> 
> I looked around and it looks like there isn't a way to do it yet, but 
> I don't think it'll be hard to patch.
> 
> Thanks though!
> terry
> 
> -----Original Message-----
> From: Ron Grabowski [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 26, 2005 10:02 AM
> To: ibatis-user-cs@incubator.apache.org
> Subject: Re: How do I set a query/stored procedure timeout in .net 
> ibatis?
> 
> What database are you using? Have you looked on:
> 
>  http://www.connectionstrings.com/
> 
> to see if its possible to set the timeout via the connection string.
> 
> --- "Heath, Terry" <[EMAIL PROTECTED]> wrote:
> > I think the default timeout is too low because we keep getting them
> 
> > (our test db server is slow), so I'd like to raise it, but I don't 
> > know how.
> > 
> > Thanks!
> > terry
> > 
> 
> 
> 


Reply via email to