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

Reply via email to