Fast Object Database for Java - with JPA/JDO support

Unexpected query token - AS


We have an issue with following query:

SELECT DISTINCT instance, instanceEntryArtifactSet, artifact
FROM AS instance    
JOIN instance.artifacts AS instanceEntryArtifactSet , AS artifact    
LEFT JOIN artifact.activatedGoals AS artifactActivatedGoals    
LEFT JOIN artifact.activatedAssumptions AS artifactActivatedAssumptions    
LEFT JOIN artifact.activatedCalibrations AS artifactActivatedCalibrations
WHERE        (    artifactActivatedGoals MEMBER OF ?1          
OR artifactActivatedAssumptions MEMBER OF ?1          
OR artifactActivatedCalibrations MEMBER OF ?1        )   
AND artifact MEMBER OF instanceEntryArtifactSet.artifacts


Caused by: com.objectdb.o.UserException: Unexpected query token 'instance.artifacts AS instanceEntryArtifactSet'
    at com.objectdb.o.MSG.a(
    at com.objectdb.o.QPR.g(
    at com.objectdb.o.QPR.r(
    at com.objectdb.o.QPR.d(
    at com.objectdb.o.QRC.<init>(
    at com.objectdb.o.QRM.Zs(
    at com.objectdb.o.MST.Zs(
    at com.objectdb.o.WRA.Zs(
    at com.objectdb.o.WSM.Zs(
    at com.objectdb.o.QRR.k(
    at com.objectdb.o.QRR.i(
    at com.objectdb.jpa.JpaQuery.getResultList(



Thank you for this report. It seems as a regression bug in version 2.8.5 due to fixing another issue with using AS in queries. Please try build 2.8.5_05, which hopefully should solve this issue.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

The patch solves the issue.

Thank you very much.

Post Reply