If someone is searching for the "Joining queries are only supported on JDBC data stores"-error, have a look at https://sourceforge.net/p/geoserver/mailman/message/35922112/. You have to change the parameter "app-schema.joining" in the WEB-INF/classes/app-schema.properties.
On Mon, 2017-07-24 at 14:00 +0200, Markus Jackenkroll wrote: > Hey, > > in the layer list there is one with the name "fmis:Fertilization" from > the store "fmis_Fertilization". The layer name seem to remain from my > older configurations. As you said, I published the layer again. Now > there is a layer "fmis:Crop". Requesting this I got the exception: > "Joining queries are only supported on JDBC data stores". This seem to > be a complete different response and my first problem seem to be solved. > I will change my data source or change the mapping and hopefully do it. > Thanks a lot for supporting!!! > > KR > Markus > > On Mon, 2017-07-24 at 09:03 +0100, Nuno Oliveira wrote: > > The filenames don't influential the layers names. > > The error you get (it seems to me) is that GeoServer is not finding the > > fmis:Crop layer. > > When you got t GeoServer list layers, what names do you see ? > > When you got the app-schema store and lick on publish layer what do you see > > ? > > > > On 07/20/2017 09:13 PM, Markus Jackenkroll wrote: > > > I did so and get: > > > <ows:ExceptionText>Feature type fmis:Crop unknown</ows:ExceptionText> > > > > > > I am not sure, but my directories and filenames are all named > > > "fmis_Fertilization". Do I have to change that? > > > > > > > > > > > > Zitat von Nuno Oliveira <nuno.olive...@geo-solutions.it>: > > > > > >> The example request you show is targeting fmsi:Fertilization type: > > >> http://mygeoserver.uni-hohenheim.de:8080/geoserver/wfs?service=WFS&Version=1.1.0&Request=GetFeature&typeName=fmis:Fertilization > > >> > > >> You probably want to use fmis:Crop as the type name parameter. > > >> > > >> On 07/19/2017 09:12 PM, Markus Jackenkroll wrote: > > >>> Hey, > > >>> > > >>> you are right. I changed the target attribute of the ID mapping: > > >>> ... > > >>> <attributeMappings> > > >>> <AttributeMapping> > > >>> <targetAttribute> > > >>> fmis:Crop > > >>> </targetAttribute> > > >>> <idExpression> > > >>> <OCQL>ID</OCQL> > > >>> </idExpression> > > >>> </AttributeMapping> > > >>> ... > > >>> After restarting the tomcat the request still gives the same result > > >>> (fmis:Fertilization not found). I searched for the fmis:Fertilization > > >>> expression to all files but could not find it anywhere. I deleted the > > >>> cache of tomcat (work/Catalina/...) and browser as well. I does not > > >>> result in a change. > > >>> > > >>> Regards, > > >>> Markus > > >>> > > >>> > > >>> > > >>> Zitat von Nuno Oliveira <nuno.olive...@geo-solutions.it>: > > >>> > > >>>> Hi, > > >>>> > > >>>> You are using fmis:Fertilization as the target element on the ID > > >>>> mapping. > > >>>> When using the idExpression the target attribute must be an existing > > >>>> element > > >>>> in this case it should be fmis:Crop. > > >>>> > > >>>> Regards, > > >>>> > > >>>> Nuno Oliveira > > >>>> > > >>>> On 07/17/2017 03:07 PM, Markus Jackenkroll wrote: > > >>>>> Dear list, > > >>>>> > > >>>>> I implemented my own application schema on geoserver. The user > > >>>>> interface > > >>>>> shows workspace, store and layer as enabled. Next, I tried to request > > >>>>> the WFS by > > >>>>> http://mygeoserver.uni-hohenheim.de:8080/geoserver/wfs?service=WFS&Version=1.1.0&Request=GetFeature&typeName=fmis:Fertilization. > > >>>>> > > >>>>> It responded with an error: > > >>>>> Error occurred getting features > > >>>>> http://myserver.uni-hohenheim.de/XSD:Fertilization not found. > > >>>>> Available: > > >>>>> [http://myserver.uni-hohenheim.de/XSD:Crop] > > >>>>> > > >>>>> I suspect the error in the mapping: > > >>>>> ... > > >>>>> <typeMappings> > > >>>>> <FeatureTypeMapping> > > >>>>> <sourceDataStore>datastoreshp</sourceDataStore> > > >>>>> <sourceType>Fertilization</sourceType> > > >>>>> <targetElement>fmis:Crop</targetElement> > > >>>>> <attributeMappings> > > >>>>> <AttributeMapping> > > >>>>> <targetAttribute> > > >>>>> fmis:Fertilization > > >>>>> </targetAttribute> > > >>>>> <idExpression> > > >>>>> <OCQL>ID</OCQL> > > >>>>> </idExpression> > > >>>>> </AttributeMapping> > > >>>>> ... > > >>>>> > > >>>>> "fmis" is the namespace, "Fertilization" the schema and "Crop" is the > > >>>>> element in the mapped XSD. By "datastoreshp" I connect to a shape > > >>>>> which > > >>>>> feature class is named "Fertilization". > > >>>>> > > >>>>> Do you have an idea what is causing this behaviour? > > >>>>> > > >>>>> Best > > >>>>> Markus > > >>>>> > > >>>>> > > >>>>> ------------------------------------------------------------------------------ > > >>>>> Check out the vibrant tech community on one of the world's most > > >>>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >>>>> _______________________________________________ > > >>>>> Geoserver-users mailing list > > >>>>> > > >>>>> Please make sure you read the following two resources before posting > > >>>>> to this list: > > >>>>> - Earning your support instead of buying it, but Ian Turton: > > >>>>> http://www.ianturton.com/talks/foss4g.html#/ > > >>>>> - The GeoServer user list posting guidelines: > > >>>>> http://geoserver.org/comm/userlist-guidelines.html > > >>>>> > > >>>>> Geoserver-users@lists.sourceforge.net > > >>>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > >>>>> > > >>>> > > >>>> -- > > >>>> Regards, > > >>>> Nuno Oliveira > > >>>> == > > >>>> GeoServer Professional Services from the experts! Visit > > >>>> http://goo.gl/it488V for more information. > > >>>> == > > >>>> > > >>>> Nuno Miguel Carvalho Oliveira > > >>>> @nmcoliveira > > >>>> Software Engineer > > >>>> > > >>>> GeoSolutions S.A.S. > > >>>> Via di Montramito 3/A > > >>>> 55054 Massarosa (LU) > > >>>> Italy > > >>>> phone: +39 0584 962313 > > >>>> fax: +39 0584 1660272 > > >>>> > > >>>> http://www.geo-solutions.it > > >>>> http://twitter.com/geosolutions_it > > >>>> > > >>>> ------------------------------------------------------- > > >>>> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 > > >>>> Le informazioni contenute in questo messaggio di posta elettronica e/o > > >>>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. > > >>>> Il loro utilizzo è consentito esclusivamente al destinatario del > > >>>> messaggio, per le finalità indicate nel messaggio stesso. Qualora > > >>>> riceviate questo messaggio senza esserne il destinatario, Vi preghiamo > > >>>> cortesemente di darcene notizia via e-mail e di procedere alla > > >>>> distruzione del messaggio stesso, cancellandolo dal Vostro sistema. > > >>>> Conservare il messaggio stesso, divulgarlo anche in parte, > > >>>> distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità > > >>>> diverse, costituisce comportamento contrario ai principi dettati dal > > >>>> D.Lgs. 196/2003. > > >>>> The information in this message and/or attachments, is intended solely > > >>>> for the attention and use of the named addressee(s) and may be > > >>>> confidential or proprietary in nature or covered by the provisions of > > >>>> privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New > > >>>> Data Protection Code).Any use not in accord with its purpose, any > > >>>> disclosure, reproduction, copying, distribution, or either > > >>>> dissemination, either whole or partial, is strictly forbidden except > > >>>> previous formal approval of the named addressee(s). If you are not the > > >>>> intended recipient, please contact immediately the sender by > > >>>> telephone, fax or e-mail and delete the information in this message > > >>>> that has been received in error. The sender does not give any warranty > > >>>> or accept liability as the content, accuracy or completeness of sent > > >>>> messages and accepts no responsibility for changes made after they > > >>>> were sent or for other risks which arise as a result of e-mail > > >>>> transmission, viruses, etc. > > >>>> > > >>>> > > >>>> ------------------------------------------------------------------------------ > > >>>> Check out the vibrant tech community on one of the world's most > > >>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >>>> _______________________________________________ > > >>>> Geoserver-users mailing list > > >>>> > > >>>> Please make sure you read the following two resources before posting > > >>>> to this list: > > >>>> - Earning your support instead of buying it, but Ian Turton: > > >>>> http://www.ianturton.com/talks/foss4g.html#/ > > >>>> - The GeoServer user list posting guidelines: > > >>>> http://geoserver.org/comm/userlist-guidelines.html > > >>>> > > >>>> Geoserver-users@lists.sourceforge.net > > >>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > >>> > > >>> > > >>> > > >>> > > >>> ------------------------------------------------------------------------------ > > >>> Check out the vibrant tech community on one of the world's most > > >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >>> _______________________________________________ > > >>> Geoserver-users mailing list > > >>> > > >>> Please make sure you read the following two resources before posting to > > >>> this list: > > >>> - Earning your support instead of buying it, but Ian Turton: > > >>> http://www.ianturton.com/talks/foss4g.html#/ > > >>> - The GeoServer user list posting guidelines: > > >>> http://geoserver.org/comm/userlist-guidelines.html > > >>> > > >>> Geoserver-users@lists.sourceforge.net > > >>> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > >> > > >> -- > > >> Regards, > > >> Nuno Oliveira > > >> == > > >> GeoServer Professional Services from the experts! Visit > > >> http://goo.gl/it488V for more information. > > >> == > > >> > > >> Nuno Miguel Carvalho Oliveira > > >> @nmcoliveira > > >> Software Engineer > > >> > > >> GeoSolutions S.A.S. > > >> Via di Montramito 3/A > > >> 55054 Massarosa (LU) > > >> Italy > > >> phone: +39 0584 962313 > > >> fax: +39 0584 1660272 > > >> > > >> http://www.geo-solutions.it > > >> http://twitter.com/geosolutions_it > > >> > > >> ------------------------------------------------------- > > >> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 > > >> Le informazioni contenute in questo messaggio di posta elettronica e/o > > >> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il > > >> loro utilizzo è consentito esclusivamente al destinatario del messaggio, > > >> per le finalità indicate nel messaggio stesso. Qualora riceviate questo > > >> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di > > >> darcene notizia via e-mail e di procedere alla distruzione del messaggio > > >> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio > > >> stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, > > >> copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento > > >> contrario ai principi dettati dal D.Lgs. 196/2003. > > >> The information in this message and/or attachments, is intended solely > > >> for the attention and use of the named addressee(s) and may be > > >> confidential or proprietary in nature or covered by the provisions of > > >> privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data > > >> Protection Code).Any use not in accord with its purpose, any disclosure, > > >> reproduction, copying, distribution, or either dissemination, either > > >> whole or partial, is strictly forbidden except previous formal approval > > >> of the named addressee(s). If you are not the intended recipient, please > > >> contact immediately the sender by telephone, fax or e-mail and delete > > >> the information in this message that has been received in error. The > > >> sender does not give any warranty or accept liability as the content, > > >> accuracy or completeness of sent messages and accepts no responsibility > > >> for changes made after they were sent or for other risks which arise as > > >> a result of e-mail transmission, viruses, etc. > > >> > > >> > > >> ------------------------------------------------------------------------------ > > >> Check out the vibrant tech community on one of the world's most > > >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >> _______________________________________________ > > >> Geoserver-users mailing list > > >> > > >> Please make sure you read the following two resources before posting to > > >> this list: > > >> - Earning your support instead of buying it, but Ian Turton: > > >> http://www.ianturton.com/talks/foss4g.html#/ > > >> - The GeoServer user list posting guidelines: > > >> http://geoserver.org/comm/userlist-guidelines.html > > >> > > >> Geoserver-users@lists.sourceforge.net > > >> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > Check out the vibrant tech community on one of the world's most > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > _______________________________________________ > > > Geoserver-users mailing list > > > > > > Please make sure you read the following two resources before posting to > > > this list: > > > - Earning your support instead of buying it, but Ian Turton: > > > http://www.ianturton.com/talks/foss4g.html#/ > > > - The GeoServer user list posting guidelines: > > > http://geoserver.org/comm/userlist-guidelines.html > > > > > > Geoserver-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to this > list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Markus Jackenkroll Institut für Phytomedizin (360), Fachgebiet Herbologie Universität Hohenheim, 70599 Stuttgart Tel.: 0711 - 459-22938, Fax.: 0711 - 459-22408 Email: m.jackenkr...@uni-hohenheim.de Web: https://sengis.uni-hohenheim.de/ Office hours only on Mondays ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
