Hi, Thanks for your reply. Even I saw command timeout is deprecated and got confuse.
I hope, I have to use ADO.net timeout property to extend SP/query execution to avoid timeout of that request. Do you know, how we can apply globally in hibernate for timeout setting instead individual Thanks & Regards, Ayyappa Kolli. On Mar 26, 2013, at 3:55 AM, Frédéric Delaporte <[email protected]> wrote: > Hello, > > A point need to be clarified: your problem does not look like a connection > timeout but like a request timeout. Those are not the same things and have > different settings. > The NHibernate command_timeout config property should change the right > timeout for you, but some post on the web let me think this is a deprecated > feature (https://bugs.launchpad.net/dbversion/+bug/1043316 ), > > You may solve your timeout setting problem an other way: by setting it > directly on queries requiring an extended timeout. > http://solomon-t.blogspot.fr/2013/01/extending-default-command-timeout-in.html > As said on above page, this is a "last resort" solution, when we need that > "immediate solution" rather than devising a way to get faster queries. > > Le lundi 25 mars 2013 16:56:55 UTC+1, Kolli Ayyappa a écrit : >> >> Hi, >> >> We are getting connection timeout error as below when exectuing Stored >> Procedure or Criteria Query >> Error Message:- >> >> Inner Exception : System.Data.SqlClient.SqlException: Timeout expired. The >> timeout period elapsed prior to completion of the operation or the server is >> not responding. >> >> Error Message-2 >> exceptionNHibernate.Exceptions.GenericADOException: Failed to execute multi >> criteria >> >> both issues happening randomly. >> >> We are using Command Timeout prorperty in Web.config and set to 60 secs. >> >> now my question, is nHibernate using Command Timeout property to set to >> connection timeout or do we need to specify in coneection string and using >> ADO.Net Connection timeout during Session opens or is there way to set >> globally in configraiton. >> >> Please let me know suggestions/best practices will help for us. >> >> Thanks, >> Ayyappa Kolli > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
