Hello
I get an error when executing the following JPQL query:
select doi
from Doi doi
left join fetch doi.metadata metadata
left join fetch metadata.titles titles
left join fetch metadata.creators creators
left join fetch metadata.descriptions descriptions
left join fetch metadata.publishers publishers
left join fetch metadata.contributors contributors
left join fetch metadata.dates dates
left join fetch metadata.types types
left join fetch metadata.formats formats
left join fetch metadata.identifiers identifiers
left join fetch metadata.sources sources
left join fetch metadata.languages languages
left join fetch metadata.relations relations
left join fetch metadata.subjects subjects
left join fetch metadata.coverages coverages
left join fetch metadata.rights rights
where LOWER( doi.doi ) LIKE LOWER( :doi )
The error is: Unexpected query token 'metadata'
This query works on Hibernate with Oracle / MySQL / Postgres, so I'm assuming the JPQL is valid.
Any ideas?
Thanks
John