[postgis-users] ERROR: Error computing path: | SQL state: 38001

[Palatla Srikanth]

Hi,



We are developing an web application that users PostgreSQL 8.4 +
PostGIS1.5  + Pgrouting 1.03 + development using (Java + Struts + Hibernate)



*When this Query is executed:*

SELECT ST_AsText(the_geom),id AS Coords FROM delhi_road WHERE id IN (SELECT
edge_id FROM shortest_path_astar('SELECT id, source,
target,x1,y1,x2,y2,cost,reverse_cost from delhi_road',550,662,true,true))



We are getting the below mentioned error and the other users accessing the
application were too facing the database exceptions. Can someone help us to
fix this issue.



-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

*Error from the postgreSQL query*



ERROR:  Error computing path:

********** Error **********

ERROR: Error computing path:

SQL state: 38001



------------------------------------------------------------------------

*Query used:*

* *

SELECT ST_AsText(the_geom),id AS Coords FROM delhi_road WHERE id IN (SELECT
edge_id FROM shortest_path_astar('SELECT id, source,
target,x1,y1,x2,y2,cost,reverse_cost from delhi_road',550,662,true,true))



-------------------------------------------------------------------------

*Error on the Application server (IDE)*



[ INFO] 46:48 (*MapServiceDAO.java:generateRoute:1525*)

Query is......SELECT ST_AsText(the_geom),id AS Coords FROM delhi_road WHERE
id IN (SELECT edge_id FROM shortest_path_astar('SELECT id, source,
target,x1,y1,x2,y2,cost,reverse_cost from delhi_road',550,662,true,true))



[ INFO] 46:48 (*MapServiceDAO.java:generateRoute:1552*)

Exception *aala.........org.postgresql.util.PSQLException*: ERROR: Error
computing path: _



Feb 22, 2012 11:46:48 AM org.apache.catalina.core.StandardWrapperValve
invoke

SEVERE: Servlet.service() for servlet GenerateRoute threw exception

*org.hibernate.SessionException*: Session was already closed

      at org.hibernate.impl.SessionImpl.close(*SessionImpl.java:303*)

      at com.tis.hib.util.HibernateSessionFactory.closeSession(*
HibernateSessionFactory.java:86*)

      at com.tis.dao.impl.MapServiceDAO.generateRoute(*
MapServiceDAO.java:1572*)

      at com.tis.servlet.GenerateRoute.doGet(*GenerateRoute.java:125*)

      at javax.servlet.http.HttpServlet.service(*HttpServlet.java:690*)

      at javax.servlet.http.HttpServlet.service(*HttpServlet.java:803*)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(*
ApplicationFilterChain.java:290*)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(*
ApplicationFilterChain.java:206*)

      at org.apache.catalina.core.StandardWrapperValve.invoke(*
StandardWrapperValve.java:230*)

      at org.apache.catalina.core.StandardContextValve.invoke(*
StandardContextValve.java:175*)

      at org.apache.catalina.core.StandardHostValve.invoke(*
StandardHostValve.java:128*)

      at org.apache.catalina.valves.ErrorReportValve.invoke(*
ErrorReportValve.java:104*)

      at org.apache.catalina.core.StandardEngineValve.invoke(*
StandardEngineValve.java:109*)

      at org.apache.catalina.connector.CoyoteAdapter.service(*
CoyoteAdapter.java:261*)

      at org.apache.coyote.http11.Http11Processor.process(*
Http11Processor.java:844*)

      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(*
Http11Protocol.java:581*)

      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(*
JIoEndpoint.java:447*)

      at java.lang.Thread.run(*Thread.java:619*)



*Regards,*

*Palatla Srikanth*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120222/61892f3d/attachment.html>