incorrect format of Date-Parameter in SQL-Statement
---------------------------------------------------
Key: GEOT-2944
URL: http://jira.codehaus.org/browse/GEOT-2944
Project: GeoTools
Issue Type: Bug
Components: data arcsde
Affects Versions: 2.6.0
Environment: server Linux RHEL 2.6.18
client WinXP SP3
uDig1.2M9 --> geoserver-2.0.0 --> ArcSDE-Datastore-2.6 --> SDE92 on Oracle10g
Reporter: Rudi Hochmeister
Assignee: Gabriel Roldán
GetFeature-Request with a Date Filter results in an error, due to incorrect
format of Date-Parameter in SQL-Statement.
- In contrast: WFS-T inserts do function correctly ;-)
Request:
<GetFeature xmlns="http://www.opengis.net/wfs";
xmlns:gml="http://www.opengis.net/gml";
xmlns:ogc="http://www.opengis.net/ogc"; version="1.0.0"
service="WFS" outputFormat="GML2">
<Query typeName="vienna:VERKEHR.BSTP90_L">
<ogc:PropertyName>OBJEKT_ENDE</ogc:PropertyName>
<ogc:PropertyName>SHAPE</ogc:PropertyName>
<ogc:Filter>
<ogc:And>
<ogc:BBOX>
<ogc:PropertyName>SHAPE</ogc:PropertyName>
<gml:Box>
<gml:coordinates decimal="." cs="," ts="">
7776.933935982151,344470.20052501856
9439.645625907368,345322.11187164375</gml:coordinates>
</gml:Box>
</ogc:BBOX>
<ogc:PropertyIsGreaterThanOrEqualTo>
<ogc:PropertyName>OBJEKT_ENDE</ogc:PropertyName>
<ogc:Literal>2010-01-03T13:51:01</ogc:Literal>
</ogc:PropertyIsGreaterThanOrEqualTo>
</ogc:And>
<ogc:Filter></ogc:Filter>
</ogc:Filter>
</Query>
</GetFeature>
Error Log:
2010-02-03 13:42:33,420 WARN [org.geotools.arcsde.data.ArcSDEQuery] - Error
fetching row for VERKEHR.BSTP90_L[
Filter: [[ SHAPE bbox POLYGON ((7776.933935982151 344470.20052501856,
7776.933935982151 345322.11187164375, 9439.645625907368 345322.11187164375,
9439.645625
907368 344470.20052501856, 7776.933935982151 344470.20052501856)) ] AND [
OBJEKT_ENDE >= 2010-01-03T13:51:01 ]]
where clause sent: VERKEHR.BSTP90_L.OBJEKT_ENDE >= 'Sun Jan 03 14:51:01 CET
2010'
geometry filter:[ SHAPE bbox POLYGON ((7776.933935982151 344470.20052501856,
7776.933935982151 345322.11187164375, 9439.645625907368 345322.11187164375, 9439
.645625907368 344470.20052501856, 7776.933935982151 344470.20052501856)) ]
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE LEVEL
ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.session.Session$1.call(Session.java:200)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.k.v(Unknown Source)
at com.esri.sde.sdk.client.k.d(Unknown Source)
at com.esri.sde.sdk.client.SeQuery.fetch(Unknown Source)
at org.geotools.arcsde.session.Session$25.execute(Session.java:776)
at org.geotools.arcsde.session.Session$25.execute(Session.java:774)
at org.geotools.arcsde.session.Session$1.call(Session.java:187)
... 5 more
2010-02-03 13:42:33,420 ERROR [org.geotools.arcsde.data.ArcSDEAttributeReader]
- [SDE error -51][Error desc=DATABASE LEVEL ERROR OCCURRED.][Extended desc=
]
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE LEVEL
ERROR OCCURRED.][Extended desc=
]
at org.geotools.arcsde.session.Session$1.call(Session.java:200)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.k.v(Unknown Source)
at com.esri.sde.sdk.client.k.d(Unknown Source)
at com.esri.sde.sdk.client.SeQuery.fetch(Unknown Source)
at org.geotools.arcsde.session.Session$25.execute(Session.java:776)
at org.geotools.arcsde.session.Session$25.execute(Session.java:774)
at org.geotools.arcsde.session.Session$1.call(Session.java:187)
... 5 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
