Hi, list,
i'm having a little problem with geoserver connection to ArcSDE.
From time to time, the connection seems to drop, causing the error on the
bottom of this message.
The only way i get it to work again is restarting Tomcat.
Anyone has any clue why this is happening?
Could it be that a connection hangs not letting tomcat make another, since 1
is the maximum connection number permitted.
But if this is the case, shoudln't be a timeout to kill that hanged
connection?
Any help will be welcome.
Thanks and regards,
Manuel Gomes
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc
http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd">
<ServiceException>
problem with FeatureResults: org.geotools.data.DataSourceException: No
free connection found to query the layers list
at
org.geotools.data.arcsde.ArcSDEConnectionPool.getSdeLayer(ArcSDEConnectionPo
ol.java:472)
at
org.geotools.data.arcsde.ArcSDEAdapter.computeFilters(ArcSDEAdapter.java:460
)
at
org.geotools.data.arcsde.ArcSDEAdapter.createSeQuery(ArcSDEAdapter.java:411)
at
org.geotools.data.arcsde.ArcSDEAdapter.createSeQuery(ArcSDEAdapter.java:376)
at
org.geotools.data.arcsde.ArcSDEDataStore.getCount(ArcSDEDataStore.java:262)
at
org.geotools.data.AbstractFeatureSource.getCount(AbstractFeatureSource.java:
221)
at
org.geotools.data.DefaultFeatureResults.getCount(DefaultFeatureResults.java:
195)
at
org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.jav
a:285)
at
org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.jav
a:142)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:3
65)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:233)
at
org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatcher.java:
219)
at
org.vfny.geoserver.servlets.wfs.WfsDispatcher.doGet(WfsDispatcher.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.geotools.data.arcsde.UnavailableConnectionException: The
maximun of 1 to org.geotools.data.arcsde.ConnectionConfig[dbtype=arcsde,
server=diablo, port=5150, instance=sde, user=sde, password=sinupcmp,
minConnections=1, maxConnections=1, connTimeOut=10000, connIncrement=1] has
been reached
at
org.geotools.data.arcsde.ArcSDEConnectionPool.getConnection(ArcSDEConnection
Pool.java:316)
at
org.geotools.data.arcsde.ArcSDEConnectionPool.getConnection(ArcSDEConnection
Pool.java:267)
at
org.geotools.data.arcsde.ArcSDEConnectionPool.getSdeLayer(ArcSDEConnectionPo
ol.java:467)
... 43 more
</ServiceException>
</ServiceExceptionReport>