Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "SELECT ST_AsText((ST_Dump(makegrid(pasture.area_coordinates, '" + distanceInGrid*10 + "' , 4326))).geom) " FROM pasture WHERE pasture.gid = '" + id + "'"
- CREATE OR REPLACE FUNCTION makegrid(geometry, integer, integer)
- RETURNS geometry AS
- $BODY$SELECT ST_Collect(st_setsrid(ST_POINT(x/1000000::double precision,y/1000000::double precision),$3)) FROM
- generate_series(floor(st_xmin($1)*1000000)::int, ceiling(st_xmax($1)*1000000)::int,$2) as x ,
- generate_series(floor(st_ymin($1)*1000000)::int, ceiling(st_ymax($1)*1000000)::int,$2) as y
- WHERE st_intersects($1,ST_SetSRID(ST_POINT(x/1000000::double precision,y/1000000::double precision),ST_SRID($1)))$BODY$
- LANGUAGE sql VOLATILE
- COST 100;
- ALTER FUNCTION makegrid(geometry, integer, integer)
- OWNER TO postgres;
- java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.MethodNode
- -[METHOD_CALL] MethodNode: '('
- +-[METHOD_NAME] IdentNode: 'ST_Buffer' {originalText=ST_Buffer}
- -[EXPR_LIST] SqlNode: 'exprList'
- +-[METHOD_CALL] MethodNode: '('
- | +-[METHOD_NAME] IdentNode: 'ST_GeomFromText' {originalText=ST_GeomFromText}
- | -[EXPR_LIST] SqlNode: 'exprList'
- | -[QUOTED_STRING] LiteralNode: ''POINT (-54.721718 -20.442634)''
- +-[QUOTED_STRING] LiteralNode: ''5.0E-5''
- -[QUOTED_STRING] LiteralNode: ''quad_segs=8''
- at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:174)
- at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:937)
- at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:705)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:665)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
- at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
- at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
- at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
- at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
- at satb.knowledge.DAO.TrajectoryPatternDAO.buildAreaObject(TrajectoryPatternDAO.java:74)
- at satb.knowledge.controller.TrajectoryPatternController.buildGrid(TrajectoryPatternController.java:117)
- at satb.knowledge.view.PatternView.applySemantic(PatternView.java:213)
- at satb.knowledge.view.PatternView$3.handle(PatternView.java:116)
- at satb.knowledge.view.PatternView$3.handle(PatternView.java:1)
- at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
- at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
- at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
- at javafx.event.Event.fireEvent(Event.java:198)
- at javafx.scene.Node.fireEvent(Node.java:8411)
- at javafx.scene.control.Button.fire(Button.java:185)
- at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
- at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
- at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
- at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
- at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
- at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
- at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
- at javafx.event.Event.fireEvent(Event.java:198)
- at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
- at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
- at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
- at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
- at java.security.AccessController.doPrivileged(Native Method)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
- at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
- at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
- at com.sun.glass.ui.View.notifyMouse(View.java:937)
- at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
- at com.sun.glass.ui.win.WinApplication.lambda$null$149(WinApplication.java:191)
- at java.lang.Thread.run(Thread.java:745)
- jun 30, 2016 3:11:12 PM org.hibernate.hql.internal.ast.ErrorCounter reportError
- ERROR: <AST>:0:0: unexpected end of subtree
- jun 30, 2016 3:11:12 PM org.hibernate.hql.internal.ast.ErrorCounter reportError
- ERROR: <AST>:0:0: unexpected end of subtree
- <AST>:0:0: unexpected end of subtree
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3572)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
- at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
- at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
- at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
- at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
- at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
- at satb.knowledge.DAO.TrajectoryPatternDAO.buildAreaObject(TrajectoryPatternDAO.java:74)
- at satb.knowledge.controller.TrajectoryPatternController.buildGrid(TrajectoryPatternController.java:119)
- at satb.knowledge.view.PatternView.applySemantic(PatternView.java:213)
- at satb.knowledge.view.PatternView$3.handle(PatternView.java:116)
- at satb.knowledge.view.PatternView$3.handle(PatternView.java:1)
- at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
- at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
- at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
- at javafx.event.Event.fireEvent(Event.java:198)
- at javafx.scene.Node.fireEvent(Node.java:8411)
- at javafx.scene.control.Button.fire(Button.java:185)
- at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
- at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
- at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
- at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
- at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
- at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
- at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
- at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
- at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
- at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
- at javafx.event.Event.fireEvent(Event.java:198)
- at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
- at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
- at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
- at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
- at java.security.AccessController.doPrivileged(Native Method)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
- at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
- at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
- at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
- at com.sun.glass.ui.View.notifyMouse(View.java:937)
- at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
- at com.sun.glass.ui.win.WinApplication.lambda$null$149(WinApplication.java:191)
- at java.lang.Thread.run(Thread.java:745)
- Session session = HibernateUtil.getSession();
- Query query = session.createSQLQuery("SELECT ST_AsText((ST_Dump(makegrid(pasture.area_coordinates, '" + distanceInGrid*10 + "' , 4326))).geom) " +
- "FROM pasture WHERE pasture.gid = '" + idPasture + "'");
- Point point = null;
- GeoCoordinate geoCoordinate = null;
- if(query.list().size() > 0)
- {
- for(Object o : query.list())
- {
- point = new Point((String)o);
- geoCoordinate = new GeoCoordinate(point.getX(), point.getY());
- grid.add(geoCoordinate);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement