On Thu, Dec 27, 2012 at 11:44 AM, Jonathan Moules <
[email protected]> wrote:
> HI List,
> My Oracle Store is set up fine (its just an Oracle NG).
> I then added a layer from the list and set it up with a style
> (default_polygon).
> I've left most of everything on the default as I don't know what they do.
> Its using 27700 SRS (what the data is).
>
> Having finally got everything set up, I try and connect to it via QGIS but
> get this error:
>
> Response: <?xml version="1.0" encoding="UTF-8"?><ServiceExceptionReport
> version="1.3.0" xmlns="http://www.opengis.net/ogc"; xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="
> http://www.opengis.net/ogc
> http://wppgeog3:8082/geoserver/schemas/wms/1.3.0/exceptions_1_3_0.xsd";>
> <ServiceException code="internalError">
> Rendering process failed
> java.io.IOException
> null
> ORA-00942: table or view does not exist
>
> </ServiceException></ServiceExceptionReport>
>
> The table in question definitely exists and the user definitely has rights
> to read it (its part of a Role which has those rights).
>
> Any suggestions?
>
Have you specified a database schema in the oracle store configuration
dialog?
It is unadvisable to use the store without it, especially if there are
multiple
tables in different schemas having the same name (since the store does not
have the internal machinery to tell them apart)
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
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/learnmore_122712
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
