开发者

Error with JPA request

开发者 https://www.devze.com 2023-03-19 05:22 出处:网络
I have a EJBQL request that generate an error: EJBQL request: javax.persistence.Query multipleSelect= em.createQuery(\"SELECT p.pname,j.descriptor from Project p LEFT OUTER JOIN Nodeassociation nON

I have a EJBQL request that generate an error:

EJBQL request:

javax.persistence.Query multipleSelect= em.createQuery("SELECT p.pname,j.descriptor from Project p LEFT OUTER JOIN Nodeassociation n  ON p.id=n.sourceNodeId and n.sinkNodeEntity='WorkflowScheme' LEFT OUTER JOIN Workflowscheme w  ON n.sourceNodeId = w.id LEFT OUTER JOIN Jiraworkflows j ON开发者_Python百科 w.name=j.workflowname; " );

Error:

line 1:244 mismatched character ' ' expecting set ''..''
An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT p.pname,j.descriptor   from Project p LEFT OUTER JOIN Nodeassociation n  ON p.id=n.sourceNodeId and n.sinkNodeEntity='WorkflowScheme' LEFT OUTER JOIN Workflowscheme w  ON n.sourceNodeId = w.id LEFT OUTER JOIN Jiraworkflows j ON w.name=j.workflowname; ].
 Internal Exception:   org.eclipse.persistence.internal.libraries.antlr.runtime.EarlyExitException

UPDATE After removing semicolone:

An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT p.pname,j.descriptor   from Project p LEFT OUTER JOIN Nodeassociation n  ON p.id=n.sourceNodeId and n.sinkNodeEntity='WorkflowScheme' LEFT OUTER JOIN Workflowscheme w  ON n.sourceNodeId = w.id LEFT OUTER JOIN Jiraworkflows j ON w.name=j.workflowname ].
Internal Exception:     org.eclipse.persistence.internal.libraries.antlr.runtime.EarlyExitException

UPDATE:

An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT p.pname,j.descriptor from Project p LEFT OUTER JOIN Nodeassociation n  ON p.id=n.sourceNodeId  n.sinkNodeEntity='WorkflowScheme' LEFT OUTER JOIN Workflowscheme w  ON n.sourceNodeId = w.id LEFT OUTER JOIN Jiraworkflows j ON w.name=j.workflowname ].
Internal Exception:  org.eclipse.persistence.internal.libraries.antlr.runtime.EarlyExitException
0

精彩评论

暂无评论...
验证码 换一张
取 消