When I use mapbuilder to get map from geoserver that link oracle spatial data, a exception occur like :
Feb 8, 2007 9:18:38 PM org.geotools.data.oracle.attributeio.SDOAttributeIO read
SEVERE: SQL Exception reading geometry column
java.sql.SQLException: Logical handle no longer valid
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccessDBError.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(OracleConnectionjava: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)
at org.geotools.data.jdbc.QueryData.read(QueryData.java:185)
at org.geotools.data.jdbc.JDBCFeatureReader.readFeature(JDBCFeatureReader.java:108)
at orggeotools.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.responses.GetMapResponse.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.servletsWmsDispatcher.doResponse(WmsDispatcher.java:156)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(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(ApplicationFilterChain.java: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(StandardEngineValvejava: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(ThreadPooljava:684)
at java.lang.Thread.run(Thread.java:595)
Feb 8, 2007 9:18:38 PM 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.responses.GetMapResponse.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.WmsDispatcher.doGet(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(ApplicationFilterChain.java: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)
… 34 more
Can someone tell me how to solve the probelm?