SQL being run SELECT * from ( SELECT FROM BOREHOLEVIEW ORDER BY
BOREHOLEVIEW.GML_ID ASC ) WHERE ROWNUM <= 5
On 29 Dec. 2017 23:06, "Ian Turton" <ijtur...@gmail.com> wrote:
> 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 <ga...@gnomeit.com> 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/owsExc
>> eptionReport.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/a64892
>> 2b85343e0181131725764da833997ffa9e)
>>
>>
>> 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-req
>> uesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> 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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
