Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.67 KB | None | 0 0
  1. "SELECT ST_AsText((ST_Dump(makegrid(pasture.area_coordinates, '" + distanceInGrid*10 + "' , 4326))).geom) " FROM pasture WHERE pasture.gid = '" + id + "'"
  2.  
  3. CREATE OR REPLACE FUNCTION makegrid(geometry, integer, integer)
  4. RETURNS geometry AS
  5. $BODY$SELECT ST_Collect(st_setsrid(ST_POINT(x/1000000::double precision,y/1000000::double precision),$3)) FROM
  6. generate_series(floor(st_xmin($1)*1000000)::int, ceiling(st_xmax($1)*1000000)::int,$2) as x ,
  7. generate_series(floor(st_ymin($1)*1000000)::int, ceiling(st_ymax($1)*1000000)::int,$2) as y
  8. WHERE st_intersects($1,ST_SetSRID(ST_POINT(x/1000000::double precision,y/1000000::double precision),ST_SRID($1)))$BODY$
  9. LANGUAGE sql VOLATILE
  10. COST 100;
  11. ALTER FUNCTION makegrid(geometry, integer, integer)
  12. OWNER TO postgres;
  13.  
  14. java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.MethodNode
  15. -[METHOD_CALL] MethodNode: '('
  16. +-[METHOD_NAME] IdentNode: 'ST_Buffer' {originalText=ST_Buffer}
  17. -[EXPR_LIST] SqlNode: 'exprList'
  18. +-[METHOD_CALL] MethodNode: '('
  19. | +-[METHOD_NAME] IdentNode: 'ST_GeomFromText' {originalText=ST_GeomFromText}
  20. | -[EXPR_LIST] SqlNode: 'exprList'
  21. | -[QUOTED_STRING] LiteralNode: ''POINT (-54.721718 -20.442634)''
  22. +-[QUOTED_STRING] LiteralNode: ''5.0E-5''
  23. -[QUOTED_STRING] LiteralNode: ''quad_segs=8''
  24.  
  25. at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:174)
  26. at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:937)
  27. at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:705)
  28. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:665)
  29. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
  30. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
  31. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
  32. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
  33. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
  34. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
  35. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
  36. at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
  37. at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
  38. at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
  39. at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
  40. at satb.knowledge.DAO.TrajectoryPatternDAO.buildAreaObject(TrajectoryPatternDAO.java:74)
  41. at satb.knowledge.controller.TrajectoryPatternController.buildGrid(TrajectoryPatternController.java:117)
  42. at satb.knowledge.view.PatternView.applySemantic(PatternView.java:213)
  43. at satb.knowledge.view.PatternView$3.handle(PatternView.java:116)
  44. at satb.knowledge.view.PatternView$3.handle(PatternView.java:1)
  45. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  46. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  47. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  48. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  49. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  50. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  51. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  52. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  53. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  54. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  55. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  56. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  57. at javafx.event.Event.fireEvent(Event.java:198)
  58. at javafx.scene.Node.fireEvent(Node.java:8411)
  59. at javafx.scene.control.Button.fire(Button.java:185)
  60. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
  61. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
  62. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  63. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  64. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  65. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  66. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  67. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  68. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  69. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  70. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  71. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  72. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  73. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  74. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  75. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  76. at javafx.event.Event.fireEvent(Event.java:198)
  77. at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  78. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  79. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  80. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  81. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
  82. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
  83. at java.security.AccessController.doPrivileged(Native Method)
  84. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
  85. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  86. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
  87. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  88. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  89. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  90. at com.sun.glass.ui.win.WinApplication.lambda$null$149(WinApplication.java:191)
  91. at java.lang.Thread.run(Thread.java:745)
  92. jun 30, 2016 3:11:12 PM org.hibernate.hql.internal.ast.ErrorCounter reportError
  93. ERROR: <AST>:0:0: unexpected end of subtree
  94. jun 30, 2016 3:11:12 PM org.hibernate.hql.internal.ast.ErrorCounter reportError
  95. ERROR: <AST>:0:0: unexpected end of subtree
  96. <AST>:0:0: unexpected end of subtree
  97. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3572)
  98. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
  99. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
  100. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
  101. at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
  102. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
  103. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
  104. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
  105. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
  106. at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
  107. at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
  108. at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
  109. at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
  110. at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
  111. at satb.knowledge.DAO.TrajectoryPatternDAO.buildAreaObject(TrajectoryPatternDAO.java:74)
  112. at satb.knowledge.controller.TrajectoryPatternController.buildGrid(TrajectoryPatternController.java:119)
  113. at satb.knowledge.view.PatternView.applySemantic(PatternView.java:213)
  114. at satb.knowledge.view.PatternView$3.handle(PatternView.java:116)
  115. at satb.knowledge.view.PatternView$3.handle(PatternView.java:1)
  116. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  117. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  118. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  119. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  120. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  121. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  122. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  123. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  124. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  125. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  126. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  127. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  128. at javafx.event.Event.fireEvent(Event.java:198)
  129. at javafx.scene.Node.fireEvent(Node.java:8411)
  130. at javafx.scene.control.Button.fire(Button.java:185)
  131. at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
  132. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
  133. at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
  134. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  135. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  136. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  137. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  138. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  139. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  140. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  141. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  142. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  143. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  144. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  145. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  146. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  147. at javafx.event.Event.fireEvent(Event.java:198)
  148. at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
  149. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  150. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  151. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  152. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
  153. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
  154. at java.security.AccessController.doPrivileged(Native Method)
  155. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
  156. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  157. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
  158. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  159. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  160. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  161. at com.sun.glass.ui.win.WinApplication.lambda$null$149(WinApplication.java:191)
  162. at java.lang.Thread.run(Thread.java:745)
  163.  
  164. Session session = HibernateUtil.getSession();
  165. Query query = session.createSQLQuery("SELECT ST_AsText((ST_Dump(makegrid(pasture.area_coordinates, '" + distanceInGrid*10 + "' , 4326))).geom) " +
  166. "FROM pasture WHERE pasture.gid = '" + idPasture + "'");
  167.  
  168.  
  169.  
  170. Point point = null;
  171. GeoCoordinate geoCoordinate = null;
  172.  
  173. if(query.list().size() > 0)
  174. {
  175. for(Object o : query.list())
  176. {
  177. point = new Point((String)o);
  178. geoCoordinate = new GeoCoordinate(point.getX(), point.getY());
  179. grid.add(geoCoordinate);
  180. }
  181. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement