Attached is a simple example of the problem.
An Animal has boolean property alive.
A Cat has boolean property tail.
A CatPlace is a place for cats (List<Cat>).
With a jpql I'm trying to find all CatPlaces that has a cat that is alive.
That results in an exception:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: CATS1_1_.ALIVE
However to find all CatPlaces that has a cat with tail via jpql is no problems.
|