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.
