[Geoserver-users] Geoserver-users Digest, Vol 26, Issue 19

Rett,

The code for the ArcSDE plugin is a part of GeoTools, and I believe that geoserver 1.6.4 is based on geoserver 2.4.x, so to track down the code for the ArcSDE try hitting the geotools project in the 2.4.x branch.

As for the dropped ArcSDE connections, I've not seen that behavior before. Can you try enabling geotools debugging in geoserver? Use the config->server->log level setting to go to "verbose debugging" and see if there are any exceptions right before the connection pool closed error.

Gabriel: is this the "dispose() -> close pool" error in a released version?

Rett: Can you try a geoserver nightly build? See if the arcsde nightlry + geoserver nightly combo works better for you.

--saul

I am using GeoServer 1.6.4 with the ArcSDE Extension.

I seem to be having an odd connection issue.
I am able to connect to ArcSDE but it does not last long and it drops the connection.

I can successfully add ArcSDE as a DataStore. And when I look at the FeatureType drop down list I initially see the ArcSDE FeatureTypes. But if I start to click on other links on the admin page and go back to the FeatureType listing, the ArcSDE FeatureTypes are missing.

I checked the geoserver.log to find
"The ConnectionPool has been closed java.lang.IllegalStateException: The ConnectionPool has been closed" (ArcSDEConnectionPool.java:229)

I do not believe it's my pool parameters that is causing the issue.
pool.minConnections = 2
pool.maxConnections = 6
pool.timeOut = 500

I would like to debug the issue to see why the connection drops by looking at the source code (line 229), but was only able to find source code for GeoServer. None of the extensions seem to have source code accompanying it.

Is the source code available? And is anyone having these dropped connection problems?

Thanks,
Rett