[Geoserver-devel] About a geoserver exception in my webAppliaction

Dear !
A exception like this :
org.geotools.renderer.lite.StreamingRenderer$DefaultRenderListener errorOccurred
SEVERE: SQL Exception reading geometry column
org.geotools.data.DataSourceException: SQL Exception reading geometry column
at org.geotools.data.oracle.attributeio.SDOAttributeIO.read(SDOAttributeIO.java:104)
at org.geotools.data.jdbc.QueryData.read(QueryData.java:185)
at org.geotools.data.jdbc.JDBCFeatureReader.readFeature(JDBCFeatureReader.java:108)
at org.geotools.data.jdbc.JDBCFeatureReader.next(JDBCFeatureReader.java:87)
at org.geotools.data.crs.ForceCoordinateSystemFeatureReader.next(ForceCoordinateSystemFeatureReader.java:126)
at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1209)
at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:506)
at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:390)
at org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:244)
at org.vfny.geoserver.wms.responsesGetMapResponse.execute(GetMapResponse.java:187)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:452)
at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
at org.vfny.geoserver.wms.servlets.WmsDispatcherdoGet(WmsDispatcher.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChainjava:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException: Logical handle no longer valid
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.checkPhyiscalStatus(OracleConnection.java:699)
at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1074)
at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:988)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:476)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:406)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1952)
at oracle.sql.ArrayDescriptor.(ArrayDescriptor.java:199)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:118)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.createArrayDescriptor(OracleTypeCOLLECTION.java:1086)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECTION.java:736)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECTION.java:716)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:481)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:416)
at oracle.jdbc.oracore.OracleTypeADT.unpickle81(OracleTypeADT.java:1621)
at oracle.jdbc.oracore.OracleTypeADT._unlinearize(OracleTypeADT.java:1312)
at oracle.jdbc.oracore.OracleTypeADT.unlinearize(OracleTypeADT.java:1271)
at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:494)
at oracle.sql.STRUCT.getOracleAttributes(STRUCT.java:411)
at org.geotools.data.oracle.sdo.GeometryConverter.asGeometry(GeometryConverter.java:99)
at org.geotools.data.oracle.attributeio.SDOAttributeIO.read(SDOAttributeIO.java:99)that StreamingRenderer
occured when I use geoserver1.3.2 in my application.Please help me to solve it.


网易邮箱精准过滤超过96%的垃圾邮件 www.126.com

taixingjason@anonymised.com ha scritto:

Dear !
      A exception like this :
org.geotools.renderer.lite.StreamingRenderer$DefaultRenderListener errorOccurred
SEVERE: SQL Exception reading geometry column
org.geotools.data.DataSourceException: SQL Exception reading geometry column
at org.geotools.data.oracle.attributeio.SDOAttributeIO.read(SDOAttributeIO.java:104)

...

Caused by: java.sql.SQLException: Logical handle no longer valid
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at

A quick search for the Oracle error ("Logical handle no longer valid") seems to suggest you're having issues either with the oracle jdbc driver
or the server, or with the connection pool, it seems there's a ton of possible reasons for this error. I can't provide you any good hint unfortunately, other than digging the net...

Cheers
Andrea