API tools faq
paste
Guest User

Untitled

a guest
Aug 18th, 2018
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.44 KB | None | 0 0
raw download clone embed print report
  1. public List<GradeSummary> getGradeSummaryList(VdtsSysDB vdtsSysDB, BoardLoad boardLoad) {
  2. List<GradeSummary> gradeSummaries = vdtsSysDB
  3. .getEntityManager()
  4. .createQuery(
  5. "select new ca.vdts.grading.model.GradeSummary(grade, " +
  6. "count(*), " +
  7. "sum(footBoardMeasure)) " +
  8. "from Board " +
  9. "where boardLoad = :load " +
  10. "group by grade", GradeSummary.class)
  11. .setParameter("load", boardLoad)
  12. .getResultList();
  13. gradeSummaries.sort(Comparator.comparing(gradeSummary -> gradeSummary.getGrade().getName()));
  14. return gradeSummaries;
  15. }
  16.  
  17. 18-08-18 13:28:50.701 ERROR java.lang.Throwable - Exception in thread "JavaFX Application Thread" java.lang.NullPointerException
  18. 18-08-18 13:28:50.702 ERROR java.lang.Throwable - at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.determineJdbcTypeCode(StandardAnsiSqlAggregationFunctions.java:200)
  19. 18-08-18 13:28:50.702 ERROR java.lang.Throwable - at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.getReturnType(StandardAnsiSqlAggregationFunctions.java:158)
  20. 18-08-18 13:28:50.702 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.findFunctionReturnType(SessionFactoryHelper.java:414)
  21. 18-08-18 13:28:50.703 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.tree.AggregateNode.getDataType(AggregateNode.java:68)
  22. 18-08-18 13:28:50.703 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.tree.ConstructorNode.resolveConstructorArgumentTypes(ConstructorNode.java:158)
  23. 18-08-18 13:28:50.703 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.tree.ConstructorNode.prepare(ConstructorNode.java:133)
  24. 18-08-18 13:28:50.703 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.HqlSqlWalker.processConstructor(HqlSqlWalker.java:1190)
  25. 18-08-18 13:28:50.704 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:2366)
  26. 18-08-18 13:28:50.704 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:2232)
  27. 18-08-18 13:28:50.704 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1503)
  28. 18-08-18 13:28:50.704 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:585)
  29. 18-08-18 13:28:50.704 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:313)
  30. 18-08-18 13:28:50.705 ERROR java.lang.Throwable - at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:261)
  31. 18-08-18 13:28:50.705 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:266)
  32. 18-08-18 13:28:50.705 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  33. 18-08-18 13:28:50.705 ERROR java.lang.Throwable - at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  34. 18-08-18 13:28:50.706 ERROR java.lang.Throwable - at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  35. 18-08-18 13:28:50.706 ERROR java.lang.Throwable - at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  36. 18-08-18 13:28:50.706 ERROR java.lang.Throwable - at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  37. 18-08-18 13:28:50.707 ERROR java.lang.Throwable - at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:553)
  38. 18-08-18 13:28:50.707 ERROR java.lang.Throwable - at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:662)
  39. 18-08-18 13:28:50.707 ERROR java.lang.Throwable - at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:686)
  40. 18-08-18 13:28:50.707 ERROR java.lang.Throwable - at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  41. 18-08-18 13:28:50.707 ERROR java.lang.Throwable - at ca.vdts.grading.model.Progress.getGradeSummaryList(Progress.java:18)
  42. 18-08-18 13:28:50.708 ERROR java.lang.Throwable - at ca.vdts.grading.controllers.ProgressController.updateDisplay(ProgressController.java:155)
  43. 18-08-18 13:28:50.708 ERROR java.lang.Throwable - at ca.vdts.grading.controllers.ProgressController.monitorSelected(ProgressController.java:125)
  44. 18-08-18 13:28:50.708 ERROR java.lang.Throwable - at ca.vdts.grading.controllers.ProgressController.lambda$initialize$3(ProgressController.java:88)
  45. 18-08-18 13:28:50.708 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper$Generic.fireValueChangedEvent(ExpressionHelper.java:361)
  46. 18-08-18 13:28:50.708 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper.fireValueChangedEvent(ExpressionHelper.java:81)
  47. 18-08-18 13:28:50.709 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyObjectPropertyBase.fireValueChangedEvent(ReadOnlyObjectPropertyBase.java:74)
  48. 18-08-18 13:28:50.709 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyObjectWrapper.fireValueChangedEvent(ReadOnlyObjectWrapper.java:102)
  49. 18-08-18 13:28:50.709 ERROR java.lang.Throwable - at javafx.beans.property.ObjectPropertyBase.markInvalid(ObjectPropertyBase.java:112)
  50. 18-08-18 13:28:50.709 ERROR java.lang.Throwable - at javafx.beans.property.ObjectPropertyBase.set(ObjectPropertyBase.java:146)
  51. 18-08-18 13:28:50.709 ERROR java.lang.Throwable - at javafx.scene.control.SelectionModel.setSelectedItem(SelectionModel.java:102)
  52. 18-08-18 13:28:50.710 ERROR java.lang.Throwable - at javafx.scene.control.ComboBox$ComboBoxSelectionModel.lambda$new$154(ComboBox.java:494)
  53. 18-08-18 13:28:50.710 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper$SingleInvalidation.fireValueChangedEvent(ExpressionHelper.java:137)
  54. 18-08-18 13:28:50.710 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper.fireValueChangedEvent(ExpressionHelper.java:81)
  55. 18-08-18 13:28:50.711 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyIntegerPropertyBase.fireValueChangedEvent(ReadOnlyIntegerPropertyBase.java:72)
  56. 18-08-18 13:28:50.711 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyIntegerWrapper.fireValueChangedEvent(ReadOnlyIntegerWrapper.java:102)
  57. 18-08-18 13:28:50.711 ERROR java.lang.Throwable - at javafx.beans.property.IntegerPropertyBase.markInvalid(IntegerPropertyBase.java:113)
  58. 18-08-18 13:28:50.711 ERROR java.lang.Throwable - at javafx.beans.property.IntegerPropertyBase.set(IntegerPropertyBase.java:147)
  59. 18-08-18 13:28:50.711 ERROR java.lang.Throwable - at javafx.scene.control.SelectionModel.setSelectedIndex(SelectionModel.java:68)
  60. 18-08-18 13:28:50.712 ERROR java.lang.Throwable - at javafx.scene.control.SingleSelectionModel.updateSelectedIndex(SingleSelectionModel.java:215)
  61. 18-08-18 13:28:50.712 ERROR java.lang.Throwable - at javafx.scene.control.SingleSelectionModel.select(SingleSelectionModel.java:149)
  62. 18-08-18 13:28:50.712 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.skin.ComboBoxListViewSkin.lambda$createListView$323(ComboBoxListViewSkin.java:484)
  63. 18-08-18 13:28:50.712 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper$Generic.fireValueChangedEvent(ExpressionHelper.java:349)
  64. 18-08-18 13:28:50.713 ERROR java.lang.Throwable - at com.sun.javafx.binding.ExpressionHelper.fireValueChangedEvent(ExpressionHelper.java:81)
  65. 18-08-18 13:28:50.713 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyIntegerPropertyBase.fireValueChangedEvent(ReadOnlyIntegerPropertyBase.java:72)
  66. 18-08-18 13:28:50.713 ERROR java.lang.Throwable - at javafx.beans.property.ReadOnlyIntegerWrapper.fireValueChangedEvent(ReadOnlyIntegerWrapper.java:102)
  67. 18-08-18 13:28:50.713 ERROR java.lang.Throwable - at javafx.beans.property.IntegerPropertyBase.markInvalid(IntegerPropertyBase.java:113)
  68. 18-08-18 13:28:50.714 ERROR java.lang.Throwable - at javafx.beans.property.IntegerPropertyBase.set(IntegerPropertyBase.java:147)
  69. 18-08-18 13:28:50.714 ERROR java.lang.Throwable - at javafx.scene.control.SelectionModel.setSelectedIndex(SelectionModel.java:68)
  70. 18-08-18 13:28:50.714 ERROR java.lang.Throwable - at javafx.scene.control.MultipleSelectionModelBase.select(MultipleSelectionModelBase.java:404)
  71. 18-08-18 13:28:50.714 ERROR java.lang.Throwable - at javafx.scene.control.MultipleSelectionModelBase.clearAndSelect(MultipleSelectionModelBase.java:356)
  72. 18-08-18 13:28:50.714 ERROR java.lang.Throwable - at javafx.scene.control.ListView$ListViewBitSetSelectionModel.clearAndSelect(ListView.java:1403)
  73. 18-08-18 13:28:50.715 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.behavior.CellBehaviorBase.simpleSelect(CellBehaviorBase.java:256)
  74. 18-08-18 13:28:50.715 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.behavior.CellBehaviorBase.doSelect(CellBehaviorBase.java:220)
  75. 18-08-18 13:28:50.716 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.behavior.CellBehaviorBase.mousePressed(CellBehaviorBase.java:150)
  76. 18-08-18 13:28:50.716 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:95)
  77. 18-08-18 13:28:50.716 ERROR java.lang.Throwable - at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  78. 18-08-18 13:28:50.717 ERROR java.lang.Throwable - at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  79. 18-08-18 13:28:50.717 ERROR java.lang.Throwable - at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  80. 18-08-18 13:28:50.717 ERROR java.lang.Throwable - at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  81. 18-08-18 13:28:50.717 ERROR java.lang.Throwable - at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  82. 18-08-18 13:28:50.718 ERROR java.lang.Throwable - at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  83. 18-08-18 13:28:50.718 ERROR java.lang.Throwable - at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  84. 18-08-18 13:28:50.718 ERROR java.lang.Throwable - at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  85. 18-08-18 13:28:50.719 ERROR java.lang.Throwable - at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  86. 18-08-18 13:28:50.719 ERROR java.lang.Throwable - at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  87. 18-08-18 13:28:50.719 ERROR java.lang.Throwable - at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  88. 18-08-18 13:28:50.720 ERROR java.lang.Throwable - at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  89. 18-08-18 13:28:50.720 ERROR java.lang.Throwable - at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  90. 18-08-18 13:28:50.720 ERROR java.lang.Throwable - at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  91. 18-08-18 13:28:50.721 ERROR java.lang.Throwable - at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  92. 18-08-18 13:28:50.721 ERROR java.lang.Throwable - at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  93. 18-08-18 13:28:50.721 ERROR java.lang.Throwable - at javafx.event.Event.fireEvent(Event.java:198)
  94. 18-08-18 13:28:50.721 ERROR java.lang.Throwable - at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  95. 18-08-18 13:28:50.722 ERROR java.lang.Throwable - at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  96. 18-08-18 13:28:50.722 ERROR java.lang.Throwable - at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  97. 18-08-18 13:28:50.722 ERROR java.lang.Throwable - at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  98. 18-08-18 13:28:50.722 ERROR java.lang.Throwable - at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:381)
  99. 18-08-18 13:28:50.723 ERROR java.lang.Throwable - at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
  100. 18-08-18 13:28:50.723 ERROR java.lang.Throwable - at java.security.AccessController.doPrivileged(Native Method)
  101. 18-08-18 13:28:50.723 ERROR java.lang.Throwable - at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$353(GlassViewEventHandler.java:417)
  102. 18-08-18 13:28:50.723 ERROR java.lang.Throwable - at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  103. 18-08-18 13:28:50.723 ERROR java.lang.Throwable - at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:416)
  104. 18-08-18 13:28:50.724 ERROR java.lang.Throwable - at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  105. 18-08-18 13:28:50.724 ERROR java.lang.Throwable - at com.sun.glass.ui.View.notifyMouse(View.java:937)
  106. 18-08-18 13:28:50.724 ERROR java.lang.Throwable - at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  107. 18-08-18 13:28:50.724 ERROR java.lang.Throwable - at com.sun.glass.ui.win.WinApplication.lambda$null$147(WinApplication.java:177)
  108. 18-08-18 13:28:50.725 ERROR java.lang.Throwable - at java.lang.Thread.run(Thread.java:748)
  109.  
  110. public class GradeSummary {
  111. private BoardGrade grade;
  112. private Integer pieceCount;
  113. private Integer footage;
  114.  
  115. public GradeSummary(BoardGrade grade, Long pieceCount, Long footage) {
  116. this.grade = grade;
  117. this.pieceCount = pieceCount.intValue();
  118. this.footage = footage.intValue();
  119. }
  120.  
  121. public BoardGrade getGrade() {
  122. return grade;
  123. }
  124.  
  125. public Integer getPieceCount() {
  126. return pieceCount;
  127. }
  128.  
  129. public Integer getFootage() {
  130. return footage;
  131. }
  132. }
  133.  
  134. private LocalDateTime timeStamp;
  135. private User grader;
  136. private Species species;
  137. private Integer length;
  138. private Integer width;
  139. private Integer surfaceMeasure;
  140. private Integer thickness;
  141. private Integer footBoardMeasure;
  142. private BoardGrade grade;
  143. private BoardModifier modifier;
  144. private BigDecimal price;
  145. private BigDecimal rate;
  146. private Pack pack;
  147. private Batch batch;
  148. private PackDescriptor packDescriptor;
  149. private BoardLoad boardLoad;
Add Comment
Please, Sign In to add comment
Public Pastes
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!