hibernate官方faq摘录

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").