If you turn logging upto Geotools-Developer and run this again you should
see the actual SQL being sent to Oracle in the log file, can you add that
here?
Ian
On 29 December 2017 at 12:02, Gavin <[email protected]> wrote:
> 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/a648922b85343e0181131725764da8
> 33997ffa9e)
>
>
> On 29 December 2017 at 20:31, <[email protected]> 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:[email protected]]
>> *Sent:* Friday, 29 December 2017 5:36 PM
>> *To:* [email protected]
>> *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
>
>
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Ian Turton
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
