I converted some shapfile data into ORACLE using shp2sdo,then i config them
in GEOSERVER. When i show them,it is blank.
The Error is:
Caused by: org.geotools.data.DataSourceException: Error Performing SQL
query: SE
LECT "GEOM" FROM "ZCXZCW_P" WHERE ((TRUE AND TRUE) AND
SDO_RELATE("GEOM",MDSYS.S
DO_GEOMETRY(2003,2437,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINAT
E_ARRAY(495489.6889135856,481643.29620508687,512910.36619871506,499776.343193325
7)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.jav
a:916)
at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore
.java:627)
at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollec
tion.java:83)
at
org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatur
eCollection.java:241)
at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCol
lection.java:211)
at
org.geotools.renderer.lite.StreamingRenderer.processStylers(Streaming
Renderer.java:1585)
... 57 more
Caused by: java.sql.SQLException: ORA-00920: 无效的关系运算符
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:
790)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1031)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
a:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1124)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1264)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.jav
a:905)
... 62 more
22 七月 09:26:29 INFO [geoserver.filters] - Not compressing output for
mimetype:
image/png
22 七月 09:26:30 INFO [geoserver.filters] - Compressing output for mimetype:
tex
t/html; charset=UTF-8
What it means? Can anyone help me?
Thanks!
--
View this message in context: http://www.nabble.com/GEOSERVER%2Boracle%2Bshapfile-tp18580778p18580778.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hi,
I don't see anything obviously wrong with the syntax of the query... My guess would be perhaps that its something to with version... and maybe a function not supported in a particular version. Just a guess.
More information about the version of Oracle you are using might be helpful. Also which context are you making this request. It sounds like you are making a WMS request and getting a blank map back?
-Justin
aureate820 wrote:
I converted some shapfile data into ORACLE using shp2sdo,then i config them
in GEOSERVER. When i show them,it is blank.
The Error is: Caused by: org.geotools.data.DataSourceException: Error Performing SQL
query: SE
LECT "GEOM" FROM "ZCXZCW_P" WHERE ((TRUE AND TRUE) AND
SDO_RELATE("GEOM",MDSYS.S
DO_GEOMETRY(2003,2437,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINAT
E_ARRAY(495489.6889135856,481643.29620508687,512910.36619871506,499776.343193325
7)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.jav
a:916)
at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore
.java:627)
at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollec
tion.java:83)
at
org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatur
eCollection.java:241)
at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCol
lection.java:211)
at
org.geotools.renderer.lite.StreamingRenderer.processStylers(Streaming
Renderer.java:1585)
... 57 more
Caused by: java.sql.SQLException: ORA-00920: 无效的关系运算符
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:
790)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1031)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
a:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1124)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1264)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:208)
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.jav
a:905)
... 62 more
22 七月 09:26:29 INFO [geoserver.filters] - Not compressing output for
mimetype:
image/png
22 七月 09:26:30 INFO [geoserver.filters] - Compressing output for mimetype:
tex
t/html; charset=UTF-8
What it means? Can anyone help me?
Thanks!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
aureate820 ha scritto:
I converted some shapfile data into ORACLE using shp2sdo,then i config them
in GEOSERVER. When i show them,it is blank.
...
Caused by: java.sql.SQLException: ORA-00920: 无效的关系运算符
Can you translate this error message from your language to english?
Cheers
Andrea