Hi List,
I've come across something weird and wondered if anyone could help.
I'm creating a new SQL view. The query:
select * from TRO_ORDERS where DATE_FROM <= %from_date% and (DATE_TO >=
> %to_date% or DATE_TO is null)
----
With the "SQL view parameters" filled in correctly, I then press "refresh"
for it to load the attributes, but I get an Oracle error:
"ORA-00942: table or view does not exist"
However that table does exist. If I take the SQL generated from the logs
and put it directly into SQL Developer, it works fine with no error but I
get no results.
The SQL from the logs is:
select * from (select * from TRO_ORDERS where DATE_FROM <= 20130102 and
> (DATE_TO >= 20130102 or DATE_TO is null)) VTABLE where 1 = 0
If I trim this down (removing the stuff that GeoServe rappears to have
added) to:
> select * from TRO_ORDERS where DATE_FROM <= 20100102 and (DATE_TO >=
> 20100102 or DATE_TO is null)
That works and does return results.
Can anyone advise what's going on? GeoServer can add the TRO_ORDERS layer
just fine as a regular layer, so I'm not sure why it is having issues as a
SQL View.
I've had a similar SQL view working previously too, so I know it can work.
Thanks,
Jonathan
--
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
