Eclipse Community Forums: EclipseLink » Inherited subtypes in collection operations?

Home » Eclipse Projects » EclipseLink » Inherited subtypes in collection operations?(Inherited subtypes in collection operations)

Inherited subtypes in collection operations? [message #1488677]

Wed, 26 November 2014 15:44

Eclipse User

Inherited subtypes seem to break collection queries, this:

SELECT o FROM Job AS o WHERE o.occupation = :occupation AND o NOT IN :jobs

dies with the dread

org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of Campaign use setObject ...

when the :jobs collection contains a Campaign, a subclass of Job.

Is this as expected or a bug?

Re: Inherited subtypes in collection operations? [message #1490912 is a reply to message #1488677]

Fri, 28 November 2014 09:55

Eclipse User

Do you see the same problem on MySQL too?
This query looks bad anyway, I would expect "AND o NOT IN (a1, a2, a3, ...)". Can you have look at expanded query which goes into database? How does it look like?

Re: Inherited subtypes in collection operations? [message #1492240 is a reply to message #1490912]

Sat, 29 November 2014 12:33

Eclipse User

The query is correct JPA and the generated sql is also correct ( o.id NOT IN (...))

No, I haven't tried this with MySQL.

Previous Topic:	Eclipselink - JPA 2.0 - Select with lockMode and maxResult doesn't work
Next Topic:	EclipseLink 2.6.0 release date

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 21:30:38 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter