Miguel, are any of your tables denormalised? With joining, tables/views should be normalised: http://docs.geoserver.org/latest/en/user/data/app-schema/joining.html#database-design-guidelines
Handling of multivalued properties is detailed here (Rini, our expert on this topic, is back on Monday): http://docs.geoserver.org/latest/en/user/data/app-schema/feature-chaining.html If you still have problems, please reply attaching your mapping files for the affected types. Kind regards, Ben. On 02/04/13 22:09, Miguel R. Luaces wrote: > Dear all, > > I am trying to set up geoserver as a gazetteer according to the INSPIRE > data specification on geographical names. The geographical names are in > a postgresql/postgis database and I am using the app-schema plugin and > feature chaining to configure the feature type. > > If I don't set app-schema.joining = true, it works fine but it needs a > long time to complete a request. If I set app-schema.joining = true, it > doesn't work because all 'chained' features are nested within the first > feature instead of being nested within the correct one. That is: > > -- app-schema.joining = false > > <snm:NamedPlace gml:id="namedplace.5802"> > <snm:name> > <snm:GeographicalName>...</snm:GeographicalName> > </snm:name> > </snm:NamedPlace> > <snm:NamedPlace gml:id="namedplace.5802"> > <snm:name> > <snm:GeographicalName>...</snm:GeographicalName> > </snm:name> > </snm:NamedPlace> > [5000 snm:NamedPlace follow] > > -- app-schema.joining = true > > <snm:NamedPlace gml:id="namedplace.5802"> > <snm:name> > <snm:GeographicalName>...</snm:GeographicalName> > </snm:name> > [5000 snm:name follow] > </snm:NamedPlace> > <snm:NamedPlace gml:id="namedplace.5802"> > [no snm:name on the second and the following features] > </snm:NamedPlace> > [5000 snm:NamedPlace follow] > > You can see the non-working feature here (it needs a long time because > it produces a huge and wrong gml file): > > http://eiel.lbd.org.es/ideac/wfs?request=GetFeature&typename=snm:NamedPlace > <http://eiel.lbd.org.es/ideac/wfs?request=GetFeature&typename=snm:NamedPlace> > > Any ideas? I can send the configuration file, if you want. I do not know > whether it is polite or allowed on this list. > > Best regards, > Miguel -- Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
