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
> >
>
>
>
