Re: [Geoserver-users] Strange error after recreating table

2017-12-29 Thread Gavin 
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"  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  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
>> 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">
>> 
>> 
>> java.lang.RuntimeException: java.io.IOException java.io.IOException null
>> ORA-00936: missing expression
>> 
>> 
>> 
>>
>>
>> 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,  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

Re: [Geoserver-users] Strange error after recreating table

2017-12-29 Thread Ian Turton 
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  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
> 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">
> 
> 
> java.lang.RuntimeException: java.io.IOException java.io.IOException null
> ORA-00936: missing expression
> 
> 
> 
>
>
> 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,  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
>
>


-- 
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

Re: [Geoserver-users] Strange error after recreating table

2017-12-29 Thread Gavin 
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
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
">


java.lang.RuntimeException: java.io.IOException java.io.IOException null
ORA-00936: missing expression





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,  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

Re: [Geoserver-users] Strange error after recreating table

2017-12-29 Thread bradh 
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