StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POhibernate criteria filtering on a set of enum values
primarykey
Id
2967199
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-06-03T15:06:29.410
FavoriteCount
0
LastActivityDate
2016-08-29T23:12:22.843
LastEditDate
LastEditorUserId
0
OwnerUserId
142366
ParentId
0
PostTypeId
1
Score
1
ViewCount
6101
LastEditorDisplayName
text
Body
Hi I'm using Hibernate 3.2 with a 1.6 JDK and Mysql 5.0 I'm trying to use the criteria api to put together a dynamic filter. However when I add a Restriction on a Set of Enums that is a property of my Criteria object I get a org.hibernate.exception.GenericJDBCException. my code is like this: <pre><code>public class FollowUp { ... public Set<AdminCategory> getAdminCategories() {...} public void setAdminCategories(Set<AdminCategory> _arg) { ... } } </code></pre> My hibernate mapping file has a set of Enum values as specified in the hibernate documentation: <a href="http://docs.jboss.org/hibernate/stable/core/reference/en/html/collections.html#collections-ofvalues" rel="nofollow noreferrer">http://docs.jboss.org/hibernate/stable/core/reference/en/html/collections.html#collections-ofvalues</a>. The file (FollowUp.hbm.xml ) is like this <pre><code><hibernate-mapping> <typedef class="dao.util.HibernateAdminCategoryType" name="main-category" /> <class name="FollowUp" table="follow_up">  <set name="mainCategories" table="follow_up_main_categories" fetch="join" lazy="false"> <key column="fup_id"/> <element column="identifier" type="main-category"/> </set>  </class> </hibernate-mapping> </code></pre> the criteria filter code is like this: <pre><code>public void runFilter(FollowUpFilter _filter) { Criteria criteria = this.getSession().createCriteria(FollowUp.class); if (_filter.hasMainCategories()) { criteria.add(Restrictions.in("mainCategories", _filter.getMainCategories())); } criteria.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ); criteria.setProjection(Projections.rowCount()); Integer count = (Integer) criteria.uniqueResult(); _filter.setTotalSize(count); } </code></pre> When I run my tests (with sql output) I get the following error: <pre><code>Statement parameter 1 not set. org.hibernate.exception.GenericJDBCException: could not execute query </code></pre> the sql output is as follows: <pre><code>select count(*) as y0_ from follow_up this_ where this_.id in ( ? ) </code></pre> Does anyone know the correct way to filter on a set of enum values in a Criteria (in Hibernate 3.2)? Cheers Simon
Tags
<java><sql><mysql><hibernate><enums>
Title
hibernate criteria filtering on a set of enum values
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USSimon B
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.