API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.43 KB | None | 0 0
raw download clone embed print report
  1. final String jpqlQuery = "SELECT m FROM Message m LEFT JOIN MessageReadDate mr " +
  2. " INNER JOIN m.group g " +
  3. " LEFT JOIN g.classroom c " +
  4. " LEFT JOIN c.ROSTER u WHERE " +
  5. " u.USER = :recipient AND " +
  6. " u.ENABLED = 1 AND " +
  7. " c.ENABLED = 1 AND " +
  8. " g.NAME = '' AND " +
  9. " m.author <> :author";
  10. Query query = m_entityManager.createQuery(jpqlQuery);
  11.  
  12. org.hibernate.hql.internal.ast.ErrorCounter - Path expected for join!
  13. Path expected for join!
  14. at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:379)
  15. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3903)
  16. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3689)
  17. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3567)
  18. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
  19. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
  20. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
  21. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
  22. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
  23. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
  24. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
  25. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:126)
  26. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:88)
  27. at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
  28. at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
  29. at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
  30. at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
  31. at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328)
  32. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  34. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  35. at java.lang.reflect.Method.invoke(Method.java:597)
  36. at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
  37. at com.sun.proxy.$Proxy68.createQuery(Unknown Source)
  38. at org.mainco.subco.messaging.repo.MessageDaoImpl.getUnreadClassAnnouncements(MessageDaoImpl.java:161)
  39. at org.mainco.subco.messaging.repo.MessageDaoImpl.getUnreadMessages(MessageDaoImpl.java:140)
  40. at org.mainco.subco.messaging.repo.MessageDaoIT.testGetUnreadMessages(MessageDaoIT.java:125)
  41. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  42. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  43. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  44. at java.lang.reflect.Method.invoke(Method.java:597)
  45. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
  46. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
  47. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
  48. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
  49. at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java: 74)
  50. at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
  51. at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
  52. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
  53. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
  54. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
  55. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
  56. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
  57. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
  58. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
  59. at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  60. at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
  61. at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
  62. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
  63. at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
  64. at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
  65. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
  66. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
  67. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
  68. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
  69. [ERROR]: org.hibernate.hql.internal.ast.ErrorCounter - Invalid path: 'g.classroom'
  70. [ERROR]: org.hibernate.hql.internal.ast.ErrorCounter - Invalid path: 'g.classroom'
  71. Invalid path: 'g.classroom'
  72. at org.hibernate.hql.internal.ast.util.LiteralProcessor.lookupConstant(LiteralProcessor.java:129)
  73. at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:225)
  74. at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:126)
  75. at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:387)
  76. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3903)
  77. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3689)
  78. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3567)
  79. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
  80. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
  81. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
  82. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
  83. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
  84. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
  85. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
  86. …
  87.  
  88. @Entity
  89. @Table(name = "msg")
  90. public class Message
  91. {
  92.  
  93. @Id
  94. @NotNull
  95. @GeneratedValue(generator = "uuid-strategy")
  96. @Column(name = "ID")
  97. private String id;
  98.  
  99. @Column(name = "MESSAGE", columnDefinition="LONGTEXT")
  100. private String message;
  101.  
  102. @ManyToOne
  103. @JoinColumn(name = "GROUP_ID", nullable = false, updatable = true)
  104. private Group group;
  105.  
  106. @Entity
  107. @Table(name = "msg_group")
  108. public class Group
  109. {
  110. @Id
  111. @NotNull
  112. @GeneratedValue(generator = "uuid-strategy")
  113. @Column(name = "ID")
  114. private String id;
  115.  
  116. @Column(name = "NAME")
  117. private String name;
  118.  
  119. @ManyToOne
  120. @JoinColumn(name = "CLASSROOM_ID", nullable = true, updatable = true)
  121. private Classroom classroom;
  122.  
  123. final String jpqlQuery = "SELECT m FROM Message m LEFT JOIN MessageReadDate mr "...
  124.  
  125. LEFT JOIN m.MessageReadDate mr // the m is referencing the MessageReadDate
  126.  
  127. FROM Message m, MessageReadDate mr
  128.  
  129. from Formula, Parameter
  130. from Formula as form, Parameter as param
  131.  
  132. from Cat as cat
  133. inner join cat.mate as mate
  134.  
  135. SELECT m FROM Message m LEFT JOIN MessageReadDate mr
  136.  
  137. SELECT m FROM Message m LEFT JOIN m.mrd
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!