1. JPA Persistence: case insensitive search / order by java.netThe second question also refers to collation. Recent Databases allow to specify the required collation used by the ORDER BY. MySQL has a feature to specify a collation for every query. I guess many other databases support collation in vendor specific SQL language extensions. Since there is no way to specify a Locale in EJBQL the only way to get a ... |
2. Hibernate custom types - text-based search and order-by forum.hibernate.orgHello, I'm using Hibernate 3.0.5. I have created a custom type implementing UserType interface and in nullSafeGet method I access a different database table than the one the custom type field belongs to: Code: public Object nullSafeGet(ResultSet resultSet, String[] names, Object owner) throws HibernateException, SQLException { ... |
3. Order by - Full text search support forum.hibernate.orgFor full text search in MySQL: select * from Book where match(title,description) against ('TV' in BOOLEAN mode) order by match(title,description) against ('TV' in BOOLEAN mode) desc how to translate this to EJB QL or HQL, or Criteria? The issue is "order by". select id, match(title,description) against ('TV' in BOOLEAN mode) as value from Book where match(title,description) against ('TV' in BOOLEAN mode) ... |