Hi John,
I am working on the same problem. And I have the same error ORA-01861.
It seems that when mapserver runs doesn't takes the NLS_DATE_FORMAT
definition
(I made a new definition according with mapserver YYYY-MM-DD format)
and the session still use the Oracle default 'dd-mmm-yyyy'.
I spent 1 day but no results or any work-around.
my configuration is linux rhes + apache and the db server runs an oracle
10.2.
ciao
John Cartwright wrote:
Thanks for your reply, David. I can get the same data to work fine in
postgres, but when using oracle I see the error:
msDrawMap(): Image handling error. Failed to draw layer named
'Hurricanes'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
ORA-01861: literal does not match format string
. Query statement: SELECT OBJECTID, SHAPE FROM HYDRO.HURRICANES_TSQP
WHERE (hurr_date >= '2004-01-01' AND hurr_date <=
'2004-12-31') AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003,
8307,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,90)
),'querytype=window') = 'TRUE' . Check your data
statement.
Seems to be an oracle-specific time formatting problem.
-- john
David William Bitner wrote:
John --
I have not used WMS-T with Oracle, but have you seen the docs for
using WMS-T with postgis?
http://mapserver.gis.umn.edu/docs/howto/wms_time_support/#example-of-wms-t-with-postgis-tile-index-for-raster-imagery
David
On 5/29/07, *John Cartwright * <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hello All,
I've having trouble getting the time requests passed to Oracle in
a way
that it understands. Has anyone done this successfully?
Thanks!
-- john
--
************************************
David William Bitner
--
------------------------------------------------
Giorgio LibertÃ
European Commission - DG Joint Research Center
Institute for Environment and Sustainability
Land Management & Natural Hazards Unit
TP 261, via Fermi
Ispra (VA), 21020 Italy
e-mail: [EMAIL PROTECTED]
Web: http://effis.jrc.it
http://forest.jrc.it
Phone: +39 0332 785309
Fax: +39 0332 786165
Mobile: +39 340 2566207
------------------------------------------------
The views expressed are purely those of the writer and may not in
any circumstances be regarded as stating an official position of
the European Commission.
