[Geoserver-users] Problem with multiple feature types in a data store

GeoServer GeoServer User
1

Hi All,

I need to set up GeoServer 1.6.4 on an empty DB (PostGRES with PostGIS). The relevant DB schema has 2 tables, each representing a feature type. I was able to define a data store but not the feature types. For some reason, the two feature types don’t show up in the pull-down list of feature types. The log file suggests that GeoServer was able to find the two tables, but that didn’t translate into feature types. Interestingly, if I remove one of the tables (either one) from the DB schema and then recreate the data source, the remaining table does show up as a feature type in the pull-down list of feature types (and I am automatically offered to define a feature type after defining the data store). Is this a bug or am I doing something wrong? The documentation states that a data source can have “one or more featureTypes” (http://geoserver.org/display/GEOSDOC/2+DataStore+Config).

Thanks,

Alex

2

risjak@anonymised.com ha scritto:

Hi All,

I need to set up GeoServer 1.6.4 on an empty DB (PostGRES with PostGIS). The relevant DB schema has 2 tables, each representing a feature type. I was able to define a data store but not the feature types. For some reason, the two feature types don't show up in the pull-down list of feature types. The log file suggests that GeoServer was able to find the two tables, but that didn't translate into feature types. Interestingly, if I remove one of the tables (either one) from the DB schema and then recreate the data source, the remaining table does show up as a feature type in the pull-down list of feature types (and I am automatically offered to define a feature type after defining the data store). Is this a bug or am I doing something wrong? The documentation states that a data source can have "one or more featureTypes" (http://geoserver.org/display/GEOSDOC/2+DataStore+Config).

The fact that you get the single feature type offered is just an
easier path, mainly designed for shapefiles. If you're not
seeing the other tables, it may just be that you're looking in the
wrong place? :wink:
The Feature Types panel shows only the
"registered" feature types, not all the ones available in the data
stores. In the same page, press the "New" link you can find at
top left of the screen, that should bring you to a dialog
that shows all the available ones and guides you thru the
registration of the new layer.

Hope this helps
Andrea