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