[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3638) Ability to use Criteria with Queries

[Adriano dos Santos Fernandes (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira