Re: [Geoserver-users] App-schema not working with joining=true

Dear Ben, do you have an existing database schema, Yes. how do you map it to the generated deegree database schema? I first used the deegree wizard to generate the database schema. Then, I changed the deegree configuration file to use my database schema instead of the generated one. So I do

Re: [Geoserver-users] App-schema not working with joining=true

Hi Miguel, I was able to recreate the same problem reported earlier (http://jira.codehaus.org/browse/GEOS-5618). The problem in the JIRA issue was because of getID() not being handled properly with joining. The bug wasn't detected because all the joining unit tests aren't using getID() anymore,

Re: [Geoserver-users] App-schema not working with joining=true

On 10/04/13 17:42, Miguel R. Luaces wrote: Second, it has a wizard to generate the configuration and the database tables starting from an XML Schema. Miguel, do you have an existing database schema, and if so, how do you map it to the generated deegree database schema? Kind regards, -- Ben

Re: [Geoserver-users] App-schema not working with joining=true

Dear all, just to close the subject, I have decided to stop using Geoserver and start using deegree because the implementation of a WFS serving complex features is way much easy. In a quick comparison, Geoserver is much easier to use because it has a really nice user interface to configure the

Re: [Geoserver-users] App-schema not working with joining=true

On Wed, Apr 10, 2013 at 10:58 AM, Miguel R. Luaces lua...@lbd.org.eswrote: Dear all, just to close the subject, I have decided to stop using Geoserver and start using deegree because the implementation of a WFS serving complex features is way much easy. In a quick comparison, Geoserver is

Re: [Geoserver-users] App-schema not working with joining=true

Hi, Out of curiosity, what store are you using in deegree? one that works like app-schema, mapping table joins and columns to attributes in the xml schema? This one. If it's the latter, what makes it easier to use in deegree compared to the app-schema configuration? First, I could not

Re: [Geoserver-users] App-schema not working with joining=true

Hi, If you’re using 2.2.x, please use 2.3 instead and see if it fixes the problem. I am using geoserver 2.3. Best regards, Miguel -- Minimize network downtime and maximize team effectiveness. Reduce network

Re: [Geoserver-users] App-schema not working with joining=true

: geoserver-users@lists.sourceforge.net; Angreani, Rini (CESRE, Kensington) Subject: Re: [Geoserver-users] App-schema not working with joining=true Ben, thank you very much for your answer. are any of your tables denormalised? No. They are all normalised. I attach the SQl that creates the tables

Re: [Geoserver-users] App-schema not working with joining=true

Ben, thank you very much for your answer. are any of your tables denormalised? No. They are all normalised. I attach the SQl that creates the tables. There are four tables. The main one is namedplace, which has a one to many relationship with gegraphicalname, which in turn has two one to many

[Geoserver-users] App-schema not working with joining=true

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

Re: [Geoserver-users] App-schema not working with joining=true

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