[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3638) Ability to use Criteria with Queries
Ability to use Criteria with Queries
------------------------------------
Key: HHH-3638
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3638
Project: Hibernate Core
Issue Type: New Feature
Components: core, query-criteria, query-hql, query-sql
Reporter: Adriano dos Santos Fernandes
I done it, for my needs, using internal classes. It would be very great to have this
nativelly on Hibernate.
Query createQueryByExample(Query query, Entidade entity)
{
SessionImpl session = (SessionImpl) entityManager.getDelegate();
Class<?> entityClass = entity.getClass();
CriteriaImpl criteria = (CriteriaImpl) session.createCriteria(entityClass);
CriteriaQueryTranslator criteriaQuery = new CriteriaQueryTranslator(
session.getFactory(), criteria, entityClass.getName(), "z");
Example example = Example.create(entity)
.enableLike(MatchMode.START)
.excludeZeroes();
criteria.add(example);
String newSql = "select * from (" +
((HibernateQuery) query).getHibernateQuery().getQueryString() +
") z";
Object[] params = criteriaQuery.getQueryParameters().getPositionalParameterValues();
if (params.length > 0)
{
String newWhere = example.toSqlString(criteria, criteriaQuery);
newSql += "\nwhere " + newWhere;
query = entityManager.createNativeQuery(newSql, entityClass);
int n = 0;
for (Object param : params)
query.setParameter(++n, param);
}
return query;
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira