The only change was to the oracle table
Oracle 10G
SQL being run SELECT * from ( SELECT FROM BOREHOLEVIEW ORDER BY
BOREHOLEVIEW.GML_ID ASC ) WHERE ROWNUM <= 5
WFS NAMESPACE http://xmlns.geosciml.org/geosciml-portrayal/2.0
Browser error
<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows"; xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance"; version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/ows
http://geology.data.vic.gov.au/nvcl/schemas/ows/1.0.0/owsExceptionReport.xsd
">
<ows:Exception exceptionCode="NoApplicableCode">
<ows:ExceptionText>
java.lang.RuntimeException: java.io.IOException java.io.IOException null
ORA-00936: missing expression
</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>
The vsersion of Geoserver that stopped working is
Build Information
- Version2.5.2
- Git Revision878d05129d090db388d1717ec136010ce104b2e3
- Build Date22-Jul-2014 09:05
- GeoTools Version11.2 (rev 59edb005ac690fabd8a0e02b898a82fac1618468)
- GeoWebCache Version1.5.3 (rev
1.5.x/a648922b85343e0181131725764da833997ffa9e)
On 29 December 2017 at 20:31, <br...@frogmouth.net> wrote:
> Gavin,
>
>
>
> This might need some more context. Perhaps you are trying to follow some
> kind of tutorial or example, but you haven’t indicated which one or where
> it is from.
>
>
>
> You talk about “both versions of Geoserver”, but we don’t know what those
> versions are (because there are a lot more than two…). It might also say
> what version of oracle you’re using, and telling us more about what changes
> you’ve made.
>
>
>
> I understand that you’re fairly deep in this, but we can’t see your screen
> from here, so its likely going to need a bit more background 😊
>
>
>
> Brad
>
>
>
> *From:* Gavin [mailto:ga...@gnomeit.com]
> *Sent:* Friday, 29 December 2017 5:36 PM
> *To:* geoserver-users@lists.sourceforge.net
> *Subject:* [Geoserver-users] Strange error after recreating table
>
>
>
> I'm trying to use the borehole portrayal 4, and 2
>
>
>
> I updated the oracle table but now both versions of Geoserver give me an
> oracle error ORA-00936 Missing Expression
>
>
>
> the generated sql from Geoserver is
>
>
>
> SELECT * from ( SELECT FROM BOREHOLEVIEW ORDER BY BOREHOLEVIEW.GML_ID ASC
> ) WHERE ROWNUM <= 5
>
>
>
> It appears that a second * or a list of columns is missing from the second
> SELECT statement
>
>
>
> Any pointers on where to look
>
>
>
> Regards
>
>
>
> Gavin
>
>
>
------------------------------------------------------------------------------
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
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
