Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » SELECT and CONCAT

Show: Today's Messages :: Show Polls :: Message Navigator

SELECT and CONCAT [message #704202]

Thu, 28 July 2011 11:29

Oliver Baum

Messages: 6
Registered: July 2009

Junior Member

Hi,

hope somebody can help me. I'm not sure if it is a bug.

I use a query with JPA 2.0 and eclipselink 2.3. But the follow query dosn't work and I don't know why. I use a Oracle 11G database.

The query:
select distinct v from Partnersuche v where v.partnerIndex in (SELECT
concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) from PartnersucheV p
where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)

And here the error:
java.lang.IllegalArgumentException: An exception occurred while creating a
query in EntityManager:
Exception Description: Syntax error parsing the query [select distinct v
from Partnersuche v where v.partnerIndex in (SELECT
concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) from PartnersucheV p
where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)], line 1, column
71: unexpected token [concat].
Internal Exception: NoViableAltException(16@[1292:16: ( DISTINCT )?])

I used this query before with Hibernate and it works.

Thanks for help
Oliver

Report message to a moderator