HibernateSQLQuery projection with domain query type

[John Cook]

I've encountered a little problem trying to build HibernateSQLQuery using SQL query types but project it using domain query type (as written in manual: 2.2.14. Using Native SQL in Hibernate queries). However, validation performed during query building does not allow me to do that reporting unknown path for projection. According to manual, I consider this to be a bug (validation should be probably turned off before projection for AbstractHibernateQuery?), right?

Example query: http://source.mysema.com/forum/mvnforum/viewthread_thread,2973

[Timo Westkämper (timo-westkamper)]

Concerning your example query :

SKontakt sKontaktPath = SKontakt.kontakt;
QKontakt qKontaktPath = QKontakt.kontakt;

Query sqlQuery = hibernateSqlQuery()
      .from(sKontaktPath)
      .where(sKontaktPath.typ.eq("E-mail"))
      .createQuery(qKontaktPath);

How do SKontakt.kontakt and QKontakt.kontakt look like?

I have not yet been able to reproduce your problem.

[Timo Westkämper (timo-westkamper)]

Found the problem now and fixed it.

[Timo Westkämper (timo-westkamper)]

Released in 2.2.2