Re: [Geoserver-users] Oracle Doesn't work

[Jonathan M. <jon...@wa...>]

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 <and...@ge...> wrote:

> On Thu, Dec 27, 2012 at 11:44 AM, Jonathan Moules <
> jon...@wa...> 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.