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
