Thanks Andrea,
I have downloaded the Oracle plugin for GeoServer 1.7.1. I must admit that I
was not so sure which one to choose.
This is the describe Feature type:
http://193.43.36.238:8484/geoserver/wfs?request=DescribeFeatureType&version=1.0.0&typeName=fifao:FAO_MAJOR
Concerning the geoserver.log, This is what i found concerning the zip
creation:
2008-12-10 15:38:02,214 INFO [geoserver.wfs] -
Request: getServiceInfo
2008-12-10 15:38:02,217 DEBUG [geoserver.requests] - Query is
net.opengis.wfs.impl.QueryTypeImpl@anonymised.com (group: , propertyName: ,
function: null, filter: null, sortBy: , featureVersion: null, handle:
null, srsName: null, typeName: [{http://www.fao.org/fi\}FAO_MAJOR])
To gt2: Query:
feature type: FAO_MAJOR
filter: Filter.INCLUDE
[properties: ALL ]
2008-12-10 15:38:02,217 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle:
Geometric Column is: GEOMETRY
2008-12-10 15:38:02,218 DEBUG [data.jdbc] - SQL: SELECT COUNT(*) as cnt FROM
"FAO_MAJOR"
2008-12-10 15:38:02,242 DEBUG [geotools.data] - IOException while
calculating size() of FeatureCollection
org.geotools.data.DataSourceException: Could not count null
at
org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:521)
at
org.geotools.data.jdbc.JDBCFeatureCollection.getCount(JDBCFeatureCollection.java:110)
at
org.geotools.data.store.DataFeatureCollection.size(DataFeatureCollection.java:268)
at
org.geotools.data.crs.ReprojectFeatureResults.size(ReprojectFeatureResults.java:120)
at org.geoserver.wfs.GetFeature.run(GetFeature.java:358)
at
org.geoserver.wfs.DefaultWebFeatureService.getFeature(DefaultWebFeatureService.java:134)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy27.getFeature(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.geoserver.security.OperationSecurityInterceptor.invoke(OperationSecurityInterceptor.java:41)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:582)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:211)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:163)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Io exception: Connection reset
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:806)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:510)
... 74 more
2008-12-10 15:38:02,244 INFO [geoserver.wfs] -
Request: getFeature
handle = null
service = wfs
version = 1.1.0
baseUrl = http://figis02:8484/geoserver/
providedVersion = 1.1.0
query = [net.opengis.wfs.impl.QueryTypeImpl@anonymised.com (group: null,
propertyName: null, function: null, filter: null, sortBy: null,
featureVersion: null, handle: null, srsName: null, typeName:
[{http://www.fao.org/fi\}FAO_MAJOR])]
maxFeatures = null
outputFormat = SHAPE-ZIP
resultType = results
traverseXlinkDepth = null
traverseXlinkExpiry = null
formatOptions = {}
2008-12-10 15:38:02,246 DEBUG [org.geoserver] - Found Java environment
variable : 'GS-SHAPEFILE-CHARSET' to be unset
2008-12-10 15:38:02,246 DEBUG [org.geoserver] - Found Servlet context
parameter : 'GS-SHAPEFILE-CHARSET' to be unset
2008-12-10 15:38:02,246 DEBUG [org.geoserver] - Found System environment
variable : 'GS-SHAPEFILE-CHARSET' to be unset
2008-12-10 15:38:02,247 DEBUG [data.shapefile] - Write lock:
file:/usr/local/tomcat/5.5.23/geoserver/temp/wfsshptemp0.5901345251513032/FAO_MAJOR.shp
by ShpFiles for deleting all files
2008-12-10 15:38:02,248 DEBUG [data.shapefile] - Write lock:
file:/usr/local/tomcat/5.5.23/geoserver/temp/wfsshptemp0.5901345251513032/FAO_MAJOR.shp
by ShpFiles for deleting all files
2008-12-10 15:38:02,248 WARN [response.ShapeZipOutputFormat] - Error while
writing featuretype 'FAO_MAJOR' to shapefile.
org.geotools.data.DataSourceException: Cannot create a shapefile whose
geometry type is class com.vividsolutions.jts.geom.Geometry
at
org.geotools.data.shapefile.ShapefileDataStore.createSchema(ShapefileDataStore.java:800)
at
org.geoserver.wfs.response.ShapeZipOutputFormat.writeCollectionToShapefile(ShapeZipOutputFormat.java:224)
at
org.geoserver.wfs.response.ShapeZipOutputFormat.write(ShapeZipOutputFormat.java:109)
at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:711)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:215).....
I will come back to you concerning the improvement i found for Oracle, but
after having used it for almost half an hour, i can say that the display is
quicker, the management of different projections is much better too (4326,
antartica). I don't retrieve the wrong displays i had before.
Thanks
Sylvain
Andrea Aime-4 wrote:
springrider ha scritto:
Andrea,
I come back to you concerning this problem. i just download the last
stable
version 1.7.1 (which is a great improvement for Oracle-Thanks)
What improvements did you notice from the user side?
but i am
facing the same problem.
This is the URL i use on my development Geoserver which is 1.7.1:
http://193.43.36.238:8484/geoserver/wfs?request=getfeature&service=wfs&version=1.1.0&typeName=fifao:FAO_MAJOR&outputformat=SHAPE-ZIP
In that case i got a zip file less than 1kb.
When i use my production GeoServer which is 1.6.4 and pointing to the
same
database:
http://www.fao.org/figis/geoserver/wfs?request=getfeature&service=wfs&version=1.1.0&typeName=fifao:FAO_MAJOR&outputformat=SHAPE-ZIP
I got the correct Zip file. This zip generates trouble with ArcMap (See
screenshot:
http://www.nabble.com/file/p20936133/Zip_GS_ArcMap.jpg ) but at least, i
have a shapefile
Considering that the 2 GeoServer instances are pointing to the same DB, i
would tend to say that it is a GeoServer problem.
You are probably right, but I need more information solve it.
What oracle plugin are you using with GeoServer 1.7.1? Oracle or OracleNG?
What does the feature type panel report about the geometries in your
table, is it able to recognize the geometry type or not?
And finally, do you get any stack traces relevant to shapefile export
in your $GEOSERVER_DATA_DIR/logs/geoserver.log?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://www.nabble.com/SHAPE-ZIP-extraction-and-1.7.0-tp20444094p20936689.html
Sent from the GeoServer - User mailing list archive at Nabble.com.