Re: [Geoserver-users] What is wrong with the REST line - tells me it cant determine content type
Did you maybe mean "@swath.zip"? Brad From: Phil Scadden Sent: Friday, 26 October 2018 2:39 PM To: geoserver-users@lists.sourceforge.net Subject: [Geoserver-users] What is wrong with the REST line - tells me it cant determine content type curl -v -u admin:xxx -XPUT -H "Content-type:application/zip" --data-binary swath.zip http://myserver/geoserver/rest/workspaces/gns/swath/swath.imagemosaic gives error. "Could not determine format. Try setting the Content-type header" Geoserver 2.11.0 The header looks correct to me. A typo somewhere? Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents. ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] What is wrong with the REST line - tells me it cant determine content type
curl -v -u admin:xxx -XPUT -H "Content-type:application/zip" --data-binary swath.zip http://myserver/geoserver/rest/workspaces/gns/swath/swath.imagemosaic gives error. "Could not determine format. Try setting the Content-type header" Geoserver 2.11.0 The header looks correct to me. A typo somewhere? Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents. ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Imagemosaic spanning the dateline
Before I waste a lot of time on something impossible, I thought I would ask whether it is okay to have an image mosaic that crosses the dateline. None of the granules cross the 180 (more accurately, the data is split into tiles that don't cross the 180), but the mosaic itself will span a big hunk of the SW Pacific. CRS is 3857 for each tile. The reason I ask is the LL, UR coordinates for an envelope2d would violate the common assumption that LL x is < LR x that flat-earthers are so used to. Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents. ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Limited CRS Options of WMS
Hello, I am trying to limit the list of shown CRS for the WMS get capabilities of a single workspace to reduce the size of resulting xml for parsing on the front-end app side. I have found the Limited SRS list option in the WMS admin interface, added the following: 4326, 3857 This makes the change valid (at least in the xml) for: Going to geoserver/wms?=getCapabilities EPSG:4326 EPSG:3857 CRS:84 But both getCapabilities of a single workspace or a single layer do not respect that: Going to geoserver/wstest/test/wms?=getCapabilities I can really see the two CRS as the options of that particular layer, test test test WCS ImageMosaic EPSG:3857 CRS:84 but I still also recieve the basic full list of the WMS service itself. GeoServer Web Map Service A compliant implementation of WMS plus most of the SLD extension (dynamic styling). Can also generate PDF, SVG, KML, GeoRSS AUTO:42001 AUTO:42002 AUTO:42003 AUTO:42004 Etc... Should this change not be sufficient to remove the additional CRS from the resulting xml? Or is there a way to propagate this change to the layer separately that I missed? Best, Lubomír Bucek___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ORA-00907 with filter in getfeature request - geoserver 2.14.0
Hi, if you copy the oracle query from the log and run it in your oracle client, you should get the same error. Try to make it work directly in Oracle first. -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ImagePyramid and TIFF overviews
On Thu, Oct 25, 2018 at 1:04 PM Arnaud L. wrote: > Hi Daniele, > thanks a lot for your help ! > > Le 25/10/2018 à 12:19, Daniele Romagnoli a écrit : > > Levels=0.2,0.2;0.4,0.4;0.8,0.8 1.6,1.6;3.2,3.2;6.4,6.4 > > 12.8,12.8;25.6,25.6;51.2,51.2 > > > 102.4,102.4;204.8,204.8;409.6,409.6;819.2,819.2;1638.4,1638.4;3276.8,3276.8;6553.6,6553.6 > > LevelsNum=4 > > Envelope2D=-200,300 200,700 (I have copied your :-) ) > > LevelsDirs=0 1 2 3 > > > > Note the ";" char usage to specify available resolutions within the same > > pyramid level whilst the " " (whitespace) still separates different > levels > > Excellent tip ! I am not sure I would have figured it out by myself ! :) > > > Does it helps? > > A lot ! Thanks again ! > > Then I guess that you configure each level's "mosaic" in the same way, > i.e. your "0" dir's property file looks like : > > Levels=0.2,0.2 0.4,0.4 0.8,0.8 (no ";" here I guess) > Name=... > [...] > LevelsNum=3 > Envelope2D=-200,300 200,700 > > Right ? > > yes. that's right. no ";" around in mosaic configs. Regards, Daniele > Best regards > > -- > Arnaud > -- Regards, Daniele Romagnoli == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Daniele Romagnoli Senior 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 --- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail. ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ImagePyramid and TIFF overviews
Hi Daniele, thanks a lot for your help ! Le 25/10/2018 à 12:19, Daniele Romagnoli a écrit : Levels=0.2,0.2;0.4,0.4;0.8,0.8 1.6,1.6;3.2,3.2;6.4,6.4 12.8,12.8;25.6,25.6;51.2,51.2 102.4,102.4;204.8,204.8;409.6,409.6;819.2,819.2;1638.4,1638.4;3276.8,3276.8;6553.6,6553.6 LevelsNum=4 Envelope2D=-200,300 200,700 (I have copied your :-) ) LevelsDirs=0 1 2 3 Note the ";" char usage to specify available resolutions within the same pyramid level whilst the " " (whitespace) still separates different levels Excellent tip ! I am not sure I would have figured it out by myself ! :) Does it helps? A lot ! Thanks again ! Then I guess that you configure each level's "mosaic" in the same way, i.e. your "0" dir's property file looks like : Levels=0.2,0.2 0.4,0.4 0.8,0.8 (no ";" here I guess) Name=... [...] LevelsNum=3 Envelope2D=-200,300 200,700 Right ? Best regards -- Arnaud ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ORA-00907 with filter in getfeature request - geoserver 2.14.0
Unsure, the Oracle SQL encoder is the same as the PostGIS one, save the spatial part (they have the same superclass), the "like" encoding is basically the same, so not sure how this is happening. First, make sure that you are using the oracle plugin corresponding to the geoserver release (sometimes people use an older plugin with a newer geoserver, that causes troubles). If the issue is still there, open a ticket on the issue tracker, with a small example dataset and a request to make it happen. Cheers Andrea On Thu, Oct 25, 2018 at 11:13 AM Martin Zeller wrote: > On 25.10.2018 08:55, Martin Zeller wrote: > > > > we use geoserver 2.14.0 with oracle and postgis. A postgis getfeature > > request with filter works: > > > http://xxx:8080/geoserver/wfs?=getFeature=xxx:x_postgis=1.0.0=WFS=name= > > xmlns:ogc="http://ogc.org; > > xmlns:gml="http://www.opengis.net/gml;> > wildCard='*' > > singleChar='.' > > > escape='!'>name** > > > > Whereas a similar request to an oracle store doesn't work: > > > http://xxx:8080/geoserver_read/wfs?=getFeature=xxx:_oracle=1.0.0=WFS= > > xmlns:ogc="http://ogc.org; > > xmlns:gml="http://www.opengis.net/gml;> > wildCard='*' > > singleChar='.' > > > escape='!'>NAMEWien* > > > > This request results in an exception: > > java.io.IOException: Error occured calculating bounds for _oracle > > ORA-00907: missing right parenthesis > > > > Excerpt from the log file: > > > > Please note the problem in the resulting sql statement: ...FROM > > gisdb._oracleWHERE... > > > > Same problem with geoserver 2.13.3 > > > ___ > 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 > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- *Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.* ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ImagePyramid and TIFF overviews
Hi Arnaud, that should be possible. We are using it with some datasets. Let me quote an example of a property file I have around: Name=RGB Levels=0.2,0.2;0.4,0.4;0.8,0.8 1.6,1.6;3.2,3.2;6.4,6.4 12.8,12.8;25.6,25.6;51.2,51.2 102.4,102.4;204.8,204.8;409.6,409.6;819.2,819.2;1638.4,1638.4;3276.8,3276.8;6553.6,6553.6 LevelsNum=4 Envelope2D=-200,300 200,700 (I have copied your :-) ) LevelsDirs=0 1 2 3 Note the ";" char usage to specify available resolutions within the same pyramid level whilst the " " (whitespace) still separates different levels I have 4 levels in my pyramid. the first level has resolutions 0.2,0.2;0.4,0.4;0.8,0.8 So a 20 cm high res and 2 overviews (40 cm, 80 cm) the second level has resolutions 1.6,1.6;3.2,3.2;6.4,6.4 So a 1.6 m res plus 2 overviews (3.2 m and 6.4 m) . Last level is different 102.4,102.4;204.8,204.8;409.6,409.6;819.2,819.2;1638.4,1638.4;3276.8,3276.8;6553.6,6553.6 it has 102.4m res + 6 overviews. Does it helps? Regards, Daniele On Thu, Oct 25, 2018 at 11:54 AM Arnaud L. wrote: > Hi all > > Is it possible to build an ImagePyramid with GeoTIFFs with overviews ? > Actually, we have one raster folder per zoom level, and they are served > as an ImagePyramid (index is in PostGIS). > But since our dataset is updated very often, the process of recreating > the rasters is long. Disk usage is also suboptimal. > We have tried building GeoTIFF with overviews so that one TIFF could > serve 2 to 3 levels (its a maximum because the displayed content changes > every 2-3 zoom level) and are very satisfied with the result, so we > would like to replace our "one folder per zoom level" structure to a > "one folder per N zoom levels" structure with geotiff with 1 or 2 > overviews inside. > > Is this possible ? If so, how should I configure the Imagepyramid > properties file ? > For the moment, we have something like : > > Name=georasters_pyramid > Levels=0.15875,0.15875 0.3175,0.3175 0.635,0.635 1.27 1.27 > LevelsDirs=georasters_17 georasters_16 georasters_15 georasters_14 > LevelsNum=4 > Envelope2D=-200,300 200,700 > > Thanks a lot ! > > Best regards > > -- > Arnaud > > > ___ > 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 > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Regards, Daniele Romagnoli == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Daniele Romagnoli Senior 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 --- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail. ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] ImagePyramid and TIFF overviews
Hi all Is it possible to build an ImagePyramid with GeoTIFFs with overviews ? Actually, we have one raster folder per zoom level, and they are served as an ImagePyramid (index is in PostGIS). But since our dataset is updated very often, the process of recreating the rasters is long. Disk usage is also suboptimal. We have tried building GeoTIFF with overviews so that one TIFF could serve 2 to 3 levels (its a maximum because the displayed content changes every 2-3 zoom level) and are very satisfied with the result, so we would like to replace our "one folder per zoom level" structure to a "one folder per N zoom levels" structure with geotiff with 1 or 2 overviews inside. Is this possible ? If so, how should I configure the Imagepyramid properties file ? For the moment, we have something like : Name=georasters_pyramid Levels=0.15875,0.15875 0.3175,0.3175 0.635,0.635 1.27 1.27 LevelsDirs=georasters_17 georasters_16 georasters_15 georasters_14 LevelsNum=4 Envelope2D=-200,300 200,700 Thanks a lot ! Best regards -- Arnaud ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ORA-00907 with filter in getfeature request - geoserver 2.14.0
On 25.10.2018 08:55, Martin Zeller wrote: we use geoserver 2.14.0 with oracle and postgis. A postgis getfeature request with filter works: http://xxx:8080/geoserver/wfs?=getFeature=xxx:x_postgis=1.0.0=WFS=name=http://ogc.org; xmlns:gml="http://www.opengis.net/gml;>wildCard='*' singleChar='.' escape='!'>name** Whereas a similar request to an oracle store doesn't work: http://xxx:8080/geoserver_read/wfs?=getFeature=xxx:_oracle=1.0.0=WFS=http://ogc.org; xmlns:gml="http://www.opengis.net/gml;>wildCard='*' singleChar='.' escape='!'>NAMEWien* This request results in an exception: java.io.IOException: Error occured calculating bounds for _oracle ORA-00907: missing right parenthesis Excerpt from the log file: Please note the problem in the resulting sql statement: ...FROM gisdb._oracleWHERE... Same problem with geoserver 2.13.3 ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ORA-00907 with filter in getfeature request - geoserver 2.14.0
(nabble stripped the excerpt from the logfile) Caused by: java.io.IOException: Error occured calculating bounds for _oracle at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1360) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:514) ... 117 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1329) ... 118 more Caused by: Error : 907, Position : 102, Sql = SELECT SDO_AGGR_MBR(SDOGEOMETRY)FROM (SELECT * FROM ( SELECT * FROM gisdb._oracleWHERE (NAME LIKE 'Wien%' AND NAME IS NOT NULL )) WHERE ROWNUM <= 50) GT2_BOUNDS_, OriginalSql = SELECT SDO_AGGR_MBR(SDOGEOMETRY)FROM (SELECT * FROM ( SELECT * FROM gisdb._oracleWHERE (NAME LIKE 'Wien%' AND NAME IS NOT NULL )) WHERE ROWNUM <= 50) GT2_BOUNDS_, Error Msg = ORA-00907: missing right parenthesis at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] ORA-00907 with filter in getfeature request - geoserver 2.14.0
Hi, we use geoserver 2.14.0 with oracle and postgis. A postgis getfeature request with filter works: http://xxx:8080/geoserver/wfs?=getFeature=xxx:x_postgis=1.0.0=WFS=name=http://ogc.org; xmlns:gml="http://www.opengis.net/gml;>name** Whereas a similar request to an oracle store doesn't work: http://xxx:8080/geoserver_read/wfs?=getFeature=xxx:_oracle=1.0.0=WFS=http://ogc.org; xmlns:gml="http://www.opengis.net/gml;>NAMEWien* This request results in an exception: java.io.IOException: Error occured calculating bounds for _oracle ORA-00907: missing right parenthesis Excerpt from the log file: Please note the problem in the resulting sql statement: ...FROM gisdb._oracleWHERE... What's the problem? Thanks Martin -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ___ 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 If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users