On Tue, May 7, 2013 at 8:20 PM, Michael Moore <michael.mo...@flatrockgeo.com
> wrote:
> Geoserver 2.2.4 using Jetty on Windows Server 2008.
>
> We're pulling several layers from SQL Server and I'm trying to get a list
> of field names for each layer using WFS's DescribeFeatureType request.
>
> All layers are published in GeoServer with the same settings (Same polygon
> style, same SRS, etc.) but some layers don't list their field names in
> DescribeFeatureType and others do. Can anyone shed some light on why this
> might be?
>
> Eg. when I request
>
> http://myserver/geoserver/wfs?request=DescribeFeatureType&typeName=MNS:geofence_static
> I get:
>
> <xsd:schema elementFormDefault="qualified" targetNamespace="
> http://www.mydomain.net/tracking/MNS";>
> <xsd:import namespace="http://www.opengis.net/gml/3.2"; schemaLocation="
> http://myserver/geoserver/schemas/gml/3.2.1/gml.xsd"/>
> <xsd:complexType name="geofence_staticType">
> <xsd:complexContent>
> <xsd:extension base="gml:AbstractFeatureType">
> <xsd:sequence>
> <xsd:element maxOccurs="1" minOccurs="1"
> name="ogr_fid" nillable="false" type="xsd:int"/>
> <xsd:element maxOccurs="1" minOccurs="0"
> name="ogr_geometry" nillable="true" type="gml:GeometryPropertyType"/>
> <xsd:element maxOccurs="1" minOccurs="0"
> name="aeroway" nillable="true" type="xsd:string"/>
> </xsd:sequence>
> </xsd:extension>
> </xsd:complexContent>
> </xsd:complexType>
> <xsd:element name="geofence_static"
> substitutionGroup="gml:AbstractFeature" type="MNS:geofence_staticType"/>
> </xsd:schema>
>
> If I request
>
> http://myserver/geoserver/wfs?request=DescribeFeatureType&typeName=MNS:GeoFence
> I simply get:
>
> <xsd:schema elementFormDefault="qualified" targetNamespace="
> http://www.mydomain.net/tracking/MNS";>
> <xsd:import namespace="http://www.opengis.net/gml/3.2"; schemaLocation="
> http://myserver/geoserver/schemas/gml/3.2.1/gml.xsd"/>
> </xsd:schema>
>
>
> I can't see any reason that one is returning the field names, but not the
> other.
>
Impossible to say just by looking at the outputs.
A few questions:
* if you restart GeoServer and ask first about the GeoFence layer, do you
get a non empty response?
* what is the data types for the tables that won't show up (e.g., do you
have a CREATE TABLE for those?
* do they have any sort of special permission attached? (e.g., grants)
Cheers
Andrea
--
==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
