I was hoping I could move forward using GML3, but the output says 0 features
despite then including them!
<wfs:FeatureCollection numberOfFeatures="0" ...>
<gml:featureMembers>
<gml:boundedBy/>
<myns:test_sql_view gml:id="test_sql_view.fid-7b81134_12ca359e616_db5"/>
<myns:test_sql_view gml:id="test_sql_view.fid-7b81134_12ca359e616_db6"/>
..
<gml:featureMembers>
</wfs:FeatureCollection>
I guess I'll see if I can get the openlayers gml parser to ignore the
numberOfFeatures until I can get this sorted out
charles
----- Original Message -----
GML3: Seems to return valid results (although I have not gone and tried this in
my app) but do get odd errors in the logs. I don't have a column named dead_end
and this query seems completely unrelated (but perhaps some other query I once
might have had - could I have some corruption somewhere?)
2010-12-02 11:28:53,102 DEBUG [org.geotools.jdbc] - Gathering sql view result
structure: select * from (select l.* from links l, vertices_tmp t
where (l.source = t.id or l.target = t.id) and t.cnt=1) as "vtable" LIMIT 0
2010-12-02 11:28:53,103 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2010-12-02 11:28:53,103 WARN [org.geoserver.wfs] - Could not load underlying
feature type for type dead_end
java.io.IOException: Error looking up primary key
at org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:913)
at org.geotools.jdbc.JDBCFeatureSource.<init>(JDBCFeatureSource.java:81)
at
org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:767)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:384)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:349)
at
org.geotools.data.store.ContentDataStore.getSchema(ContentDataStore.java:334)
at
org.geotools.jdbc.JDBCDataStore.addVirtualTable(JDBCDataStore.java:277)
at
org.geoserver.catalog.ResourcePool.getFeatureType(ResourcePool.java:634)
at
org.geoserver.catalog.ResourcePool.getFeatureType(ResourcePool.java:597)
at
org.geoserver.catalog.impl.FeatureTypeInfoImpl.getFeatureType(FeatureTypeInfoImpl.java:86)
at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:144)
at $Proxy11.getFeatureType(Unknown Source)
at
org.geoserver.wfs.xml.v1_1_0.WFSConfiguration.configureContext(WFSConfiguration.java:226)
at org.geotools.xml.Configuration.setupContext(Configuration.java:619)
at org.geotools.xml.Encoder.<init>(Encoder.java:229)
at
org.geoserver.wfs.xml.GML3OutputFormat.write(GML3OutputFormat.java:149)
at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:139)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:775)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:233)
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:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:48)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
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:275)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERROR: column t.cnt does not exist
Position: 105
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.jdbc.JDBCFeatureSource.getColumnMetadata(JDBCFeatureSource.java:681)
at org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:881)
... 75 more
2010-12-02 10:51:36,545 DEBUG [org.geoserver.wfs] - Unable to find user-defined
schema location for: http://myns.org/. Using a built schema location by
default:
http://test.myns.com:8083/geoserver/wfs?service=WFS&version=1.1.0&request=DescribeFeatureType&typeName=myns%3Atest_sql_view
2010-12-02 10:51:36,547 WARN [org.geotools.jdbc] - Failed to use
ST_Estimated_Extent, falling back on envelope aggregation
org.postgresql.util.PSQLException: ERROR: relation "public.test_sql_view" does
not exist
Where: SQL statement "SELECT has_table_privilege((SELECT usesysid FROM
pg_user WHERE usename = session_user), 'public.test_sql_view', 'select')"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.postgis.PostGISDialect.getOptimizedBounds(PostGISDialect.java:208)
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1086)
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:468)
at
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:369)
at
org.geotools.data.store.ContentFeatureCollection.getBounds(ContentFeatureCollection.java:273)
at
org.geoserver.wfs.xml.v1_1_0.FeatureCollectionTypeBinding.getProperty(FeatureCollectionTypeBinding.java:180)
at
org.geotools.xml.impl.GetPropertyExecutor.visit(GetPropertyExecutor.java:91)
at
org.geotools.xml.impl.BindingWalker$BindingExecutionChain.execute(BindingWalker.java:215)
at org.geotools.xml.impl.BindingWalker.walk(BindingWalker.java:181)
at
org.geotools.xml.impl.BindingVisitorDispatch.walk(BindingVisitorDispatch.java:44)
at
org.geotools.xml.impl.BindingVisitorDispatch.walk(BindingVisitorDispatch.java:29)
at
org.geotools.xml.impl.BindingPropertyExtractor.properties(BindingPropertyExtractor.java:83)
at org.geotools.xml.Encoder.encode(Encoder.java:904)
at org.geotools.xml.Encoder.encode(Encoder.java:561)
at
org.geoserver.wfs.xml.GML3OutputFormat.write(GML3OutputFormat.java:199)
at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:139)
2010-12-02 11:28:53,107 DEBUG [org.geotools.jdbc] - Retriving bounding box:
SELECT ST_AsText(ST_Force_2D(Envelope(ST_Extent("the_geom"::geometry))))FROM (
SELECT * FROM (select * from links) as "vtable" LIMIT 50) as "GT2_BOUNDS_"
2010-12-02 11:28:53,109 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2010-12-02 11:28:53,109 DEBUG [org.geotools.xml] - [ class
org.geotools.geometry.DirectPosition2D ] is not of type class
[Ljava.lang.Double;
2010-12-02 11:28:53,109 DEBUG [org.geotools.xml] - [ class
org.geotools.geometry.DirectPosition2D ] is not of type class
[Ljava.lang.Double;
2010-12-02 11:28:53,110 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2010-12-02 11:28:53,110 DEBUG [org.geotools.jdbc] - SELECT
"gid","link_id","st_name","feat_id","ref_in_id","nref_in_id","func_class","speed_cat","fr_spd_lim","to_spd_lim","to_lanes","from_lanes","dir_travel","route_type","dironsign","source_zlevel","target_zlevel","source","target","length","x1","y1","x2","y2","normalized","st_name_added","dironsign_added","ramp",encode(ST_AsBinary(ST_Force_2D("the_geom")),'base64')
as "the_geom" FROM (select * from links) as "vtable" LIMIT 50
2010-12-02 11:28:53,112 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,112 DEBUG [org.geotools.jdbc] - 1 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,112 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,112 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,112 DEBUG [org.geotools.xml] - _Feature is abstract
2010-12-02 11:28:53,113 DEBUG [org.geotools.xml] - [ class
org.geotools.geometry.DirectPosition2D ] is not of type class
[Ljava.lang.Double;
2010-12-02 11:28:53,113 DEBUG [org.geotools.xml] - [ class
org.geotools.geometry.DirectPosition2D ] is not of type class
[Ljava.lang.Double;
2010-12-02 11:28:53,115 DEBUG [org.geotools.xml] - [ class
[Lorg.opengis.geometry.DirectPosition; ] is not of type class
[Ljava.lang.Double;
2010-12-02 11:28:53,115 DEBUG [org.geotools.jdbc] - 3 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,115 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,115 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,115 DEBUG [org.geotools.jdbc] - 0 is not of type
java.lang.Short, attempting conversion
2010-12-02 11:28:53,116 DEBUG [org.geotools.xml] - _Feature is abstract
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users