Hello,
I use geoserver 2.2.4 with the oracle plugin and Oracle 11g. If I make a layer
from an Oracle table, Geoserver retrieves data with queries like
SELECT * FROM (SELECT
ID,CODE,TUNNEL_CODE,NUMBER,LINE,TYPE,TECHNICAL_ROOM_ID,EMERGENCY_RECESS_ID,NAME_FR,NAME_NL,NOTES,EMERGENCY_EXIT_ID,TUNNEL_SECTION_ID,VIEWING_CAMERA,GEOMETRY
as GEOMETRY FROM EMERGENCY_PHONE) WHERE ROWNUM <= 50
In my case, as NUMBER is a reserved word (even if it is actually the column
name), it leads to an oracle error 'missing expression'.
As geoserver oracle plugin cannot prevent such things, it should protect every
table or column name by double quotes.
I think that the fix would be simple.
Thanks
Vincent
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
