Is there something like Restrictions.eq(true, false) in Criteria API?

Question

I need a generic Criterion which forces the result to zero matches.

Something like Restrictions.eq(true, false) ?

Erg

What kind if criteria are you talking about? What technology? Language? Platform? – Archle

Added the java tag for upcoming readers, thank you Stefan – Erg

Answer 1

I use in NHibernate (C#):

Restrictions.Sql("(1=0)");

or in Hibernate (Java):

Restrictions.sqlRestriction("(1=0)");

:-)

Archle

Restrictions.sqlRestriction("(1=0)") seems to do the trick. – Anagnorisis

Answer 2

In Hibernate you might use sqlRestriction:

http://ajava.org/online/hibernate3api/org/hibernate/criterion/Restrictions.html#sqlRestriction(java.lang.String)

Milestone

Answer 3

I used below code in hibernate and it worked for me:

Restrictions.sqlRestriction("1=0")

Victorious