{noformat}@Query(""" select address from AddressEntity address inner JOIN VendorEntity vendor where address.workspaceId = :workspaceId and address.partyId=:partyId and address.partyType=:partyType and address.partyId=vendor.id and address.status in (:statuses) and vendor.status = :vendorStatus """) List<AddressEntity> getCheckVendorAddresses( @NonNull @Param("partyId") String partyId, @NonNull @Param("partyType") PartyType partyType, @NonNull @Param("addressScopeType") AddressScopeType addressScopeType, @NonNull @Param("workspaceId") String workspaceId, @NonNull @Param("vendorStatus") Status vendorStatus, @NonNull @Param("statuses") List<AddressStatus> statuses );{noformat}
Spring+JPA Used, However, this is not a spring JPA issue. It throws following exception when JPA Query is validated.
{noformat}Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: in near line 1, column 72 [select address from in.abcdef.model.AddressEntity address inner JOIN in.abcdef.vendor.entity.VendorEntity vendor where address.workspaceId = :workspaceId and address.addressScopeType=:addressScopeType and address.partyId=:partyId and address.partyType=:partyType and address.partyId=vendor.id and address.status in (:statuses) and vendor.status = :vendorStatus ] at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:301) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162) at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:636) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:748) ... 172 common frames omitted{noformat} |
|