<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif"">Hi,</span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif"">We
are developing an web application that users PostgreSQL 8.4 + PostGIS1.5
+ Pgrouting 1.03 + development using (Java + Struts + Hibernate)</span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif""> </span></p>
<p class="MsoNormal"><b><span style="font-family:"Century Gothic","sans-serif"">When
this Query is executed:</span></b></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif"">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))</span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif"">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</span>.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</p>
<p class="MsoNormal"><b>Error from the postgreSQL query</b></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif""> </span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">ERROR: Error computing
path: </p>
<p class="MsoNormal">********** Error **********</p>
<p class="MsoNormal" style="margin-bottom:12.0pt">ERROR: Error computing path: </p>
<p class="MsoNormal">SQL state: 38001</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">------------------------------------------------------------------------</p>
<p class="MsoNormal"><b>Query used:</b></p>
<p class="MsoNormal"><b> </b></p>
<p class="MsoNormal">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))</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-------------------------------------------------------------------------</p>
<p class="MsoNormal"><b>Error on the Application server (IDE)</b></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'">[ INFO] 46:48 (</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">MapServiceDAO.java:generateRoute:1525</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'">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))</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New';background-image:initial;background-color:yellow;background-repeat:initial initial">[
INFO] 46:48 (</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy;background:yellow">MapServiceDAO.java:generateRoute:1552</span></u><span style="font-size:10pt;font-family:'Courier New';background-image:initial;background-color:yellow;background-repeat:initial initial">)</span><span style="font-size:10.0pt;font-family:"Courier New";background:yellow"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New';background-image:initial;background-color:yellow;background-repeat:initial initial">Exception
</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy;background:yellow">aala.........org.postgresql.util.PSQLException</span></u><span style="font-size:10pt;font-family:'Courier New';background-image:initial;background-color:yellow;background-repeat:initial initial">: ERROR: Error computing path: _</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'">Feb 22, 2012 11:46:48 AM
org.apache.catalina.core.StandardWrapperValve invoke</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'">SEVERE: Servlet.service() for servlet
GenerateRoute threw exception</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">org.hibernate.SessionException</span></u><span style="font-size:10pt;font-family:'Courier New'">: Session was
already closed</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.hibernate.impl.SessionImpl.close(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">SessionImpl.java:303</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
com.tis.hib.util.HibernateSessionFactory.closeSession(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">HibernateSessionFactory.java:86</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
com.tis.dao.impl.MapServiceDAO.generateRoute(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">MapServiceDAO.java:1572</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
com.tis.servlet.GenerateRoute.doGet(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">GenerateRoute.java:125</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
javax.servlet.http.HttpServlet.service(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">HttpServlet.java:690</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
javax.servlet.http.HttpServlet.service(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">HttpServlet.java:803</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">ApplicationFilterChain.java:290</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">ApplicationFilterChain.java:206</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.StandardWrapperValve.invoke(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">StandardWrapperValve.java:230</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.StandardContextValve.invoke(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">StandardContextValve.java:175</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.StandardHostValve.invoke(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">StandardHostValve.java:128</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.valves.ErrorReportValve.invoke(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">ErrorReportValve.java:104</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.core.StandardEngineValve.invoke(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">StandardEngineValve.java:109</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.catalina.connector.CoyoteAdapter.service(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">CoyoteAdapter.java:261</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.coyote.http11.Http11Processor.process(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">Http11Processor.java:844</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">Http11Protocol.java:581</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">JIoEndpoint.java:447</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span><span style="font-size:10.0pt;font-family:"Courier New""></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'Courier New'"> at java.lang.Thread.run(</span><u><span style="font-size:10.0pt;font-family:"Courier New";color:navy">Thread.java:619</span></u><span style="font-size:10pt;font-family:'Courier New'">)</span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic","sans-serif""> </span></p>
<p class="MsoPlainText"><b>Regards,</b></p>
<p class="MsoPlainText"><b>Palatla Srikanth</b></p>
<p class="MsoPlainText"><br></p>