Hi Andrea,
But then surely as I've explicitly declared a schema in the Store that
should be used? I guess expectations may be different between users, but
that's what I'd expect to happen. I don't normally include the schema
myself in any of my queries in any software I use - not even SQL Developer
where I've entered raw SQL - it is always added transparently.
So I think there's a case for doing so with GeoServer. Anyone else have an
opinion?
Cheers,
Jonathan
On 11 October 2013 16:51, Andrea Aime <[email protected]> wrote:
> On Fri, Oct 11, 2013 at 2:09 PM, Jonathan Moules <
> [email protected]> wrote:
>
>> Figured it out. Turns out GeoServer doesn't add the schema for Oracle SQL
>> Views. Created a JIRA issue for it as it seems inconsistent (the schema has
>> to be in the store declaration).
>> http://jira.codehaus.org/browse/GEOS-6084
>>
>> Seems more like it might be a design decision than an outright bug, but
>> reported anyway just in case. :-)
>>
>
> Indeed, GeoServer does not interpret or modifies the sql you provide, it
> uses it "as is" (minus the sql view params).
> So, it's up to you to specify the necessary schema names in the sql
>
> 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.
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
