NHibernate SetTimeout on ICriteria

nhibernate

Could someone tell me what the units the SetTimeout(int) method in the ICriteria interface uses?
Is it milliseconds, seconds, minutes or other?

Best Answer

A little bit of poking around suggests that it could be seconds:

Assuming that ICriteria is the same as the Criteria interface in Hibernate core, then the JavaDoc for org.hibernate.Criteria provides a hint - the "see also" link to java.sql.Statement.setQueryTimeout(). The latter refers to its timeout parameter as seconds.

Assuming that the NHibernate implementation follows the implied contract of that method, then that should be fine. However, for peace of mind's sake, I went and looked for some NHibernate specific stuff. There are various references to CommandTimeout; for example, here, related to NHibernate. Sure enough, the documentation for CommandTimeout states that it's seconds.

I almost didn't post the above, because I don't know the answer outright, and can't find any concrete documentation - but since there is so little on the issue, I figured it couldn't hurt to present these findings.

Related Solutions

R – Is it possible to get a lazy IEnumerable from an NHibernate query using ICriteria

ICriteria doesn't have any methods that return an IEnumerable, but IQuery does.

C# – nHibernate bag query issue

Try this:

var groupsCrit = items.CreateCriteria("Groups");
var groupIds = Restrictions.Disjunction();
foreach (var groupid in Groups)
{
    groupIds.Add(Restrictions.Eq("Id", groupid)); // "Id" should be the name of the Id property on the Group class
}
groupsCrit.Add(groupIds);

Best Answer

Related Solutions

R – Is it possible to get a lazy IEnumerable from an NHibernate query using ICriteria

C# – nHibernate bag query issue

Related Topic