Perhaps we could improve the joining setting by applying it per feature type, instead of per GeoServer instance. I raised this task, but I can't commit on working on it anytime soon. https://jira.codehaus.org/browse/GEOT-4596
-----Original Message----- From: Caradoc-Davies, Ben (CESRE, Kensington) Sent: Tuesday, 15 October 2013 9:47 AM To: snuffy Cc: geoserver-users@lists.sourceforge.net; Angreani, Rini (CESRE, Kensington) Subject: Re: [Geoserver-users] App-schema and CharacterString Type Aha! Because app-schema can use separate connections for different feature types, it should work with chaining across different databases, but only if joining is turned off. It looks like you have found a use-case that does not automatically turn off joining; this is a bug. You can manually turn off joining in your app-schema.properties file: http://docs.geoserver.org/latest/en/user/data/app-schema/joining.html#conditions Kind regards, Ben. On 15/10/13 07:11, snuffy wrote: > Attached is stack trace.. > > Appears to be having issue with sql.. > > I think I know where the issue might be.. it is possible it is trying > to join between two databases. > > (It was) > > I have two different databases and two different jdbc connections, > each project uses their own.. except.. > > An app-schema feature can only describe a single jdbc datasource, so > even though each db has their own version of the 'ci_contact' and > friends table, when app-schema does a query its locked into the one > jdbc datasource. > > I guess if I want to implement separate db's which share another > common featureType from an external namespace i'll need to have > separate geoservers or have it within a single database schema. > > Thanks > > > On 14 October 2013 17:34, Ben Caradoc-Davies > <ben.caradoc-dav...@csiro.au <mailto:ben.caradoc-dav...@csiro.au>> wrote: > > Do you have a full stack trace? > > > On 14/10/13 14:22, snuffy wrote: > > As a minor follow up to this. > > I've tried taking my 'company' schema and adding a CI_Contact entry. > > I believe something is not right in my xsd/xml. > > The error is listed below: > > <ows:ExceptionText> > java.lang.RuntimeException: Error applying mapping with > targetAttribute > company:contactInfo Error applying mapping with targetAttribute > company:contactInfo java.io.IOException null Schema 'person' > does not exist. > > > Have attached zip with relevant files. > > > -- > Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> > Software Engineer > CSIRO Earth Science and Resource Engineering > Australian Resources Research Centre > > -- Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
