How can I place a condition upon a collection size? from User user where size(user.messages) >= 1
How can I query for entities with empty collections? from Box box where box.balls is empty
Are collections pageable? Query q = s.createFilter( collection, "" ); // the trivial filter q.setMaxResults(PAGE_SIZE); q.setFirstResult(PAGE_SIZE * pageNumber); List page = q.list();
How can I bind properties of a JavaBean to named query parameters? Query q = s.createQuery("from foo in class Foo where foo.name=:name and foo.size=:size"); q.setProperties(fooBean); // fooBean has getName() and getSize() List foos = q.list();
How can I assign a default value to a property when the database column is null? Use a UserType.
How can I execute arbitrary SQL using Hibernate? PreparedStatement ps = session.connection().prepareStatement(sqlString); Or, if you wish to retrieve managed entity objects, use session.createSQLQuery().
@Serialized was working for me, and now that I use @Lob it fails Due to a change in the EJB3 specification, @Serialized is gone and has been replaced by a mapping through a blob. Many JDBC drivers have issues with Blob. @Serialized can be replaced by @Type(type="serializable").