Hi Palatla,
I only saw in the documentation that the order of arguments in the
sql-expression used in the function shortest_path_astar is slightly
different from the one you are using:
This is an example from the documentation
(http://www.pgrouting.org/docs/1.x/astar.html):
SELECT * FROM shortest_path_astar('SELECT gid AS id, source::int4,
target::int4, length::double precision AS cost,length::double
precision
AS reverse_cost, x1, y1, x2, y2 FROM dourol', 3, 7, true, true);
As you can see, cost and reverse_cost are placed before the coordinates.
Perhaps this might be the cause of the problem?
Hope that helps,
Birgit.
Am 22.02.2012 09:41, schrieb 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*
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users