Hi Andrea,
I hadn't set a schema. I guess this means I'll need to add a new layer for
each schema, even though its the same user reading it.
This does resolve the reading issue, however the MBR issue (
http://jira.codehaus.org/browse/GEOS-5517) is still evident even after
specifying a schema (note: there are only about 50,000 features in this
particular dataset).
Thanks,
Jonathan
On 27 December 2012 11:01, Andrea Aime <[email protected]> wrote:
> 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
>
> -------------------------------------------------------
>
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
------------------------------------------------------------------------------
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
