GEOSERVER+oracle+shapfile

[aureate820]

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-4]

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@...

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[aureate820]

yes，may be it is a bug of GEOSERVER1.6.4.
but it hints: the lack of object when i open the data from oracle use  the geoaerver with the vertion of 1.5.4

Justin Deoliveira-4 wrote:

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
[e-mail]

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[aaime]

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

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[aureate820]

I converted some shapfile data into ORACLE using shp2sdo,then i config them in GEOSERVER of Vertion1.5.4. When i show them,it is blank.

The Error is:
GetMap Request
 version: 1.1.1
 output format: application/openlayers
 width height: 550,359
 bbox: Env[502076.38492496713 : 504873.94908673776, 488964.93726158055 : 493949.
710309533]
 layers: topp:ZCXZGG_P
 styles: point
236219 [信息] org.vfny.geoserver.servlets.AbstractService - Service handled
249969 [信息] org.vfny.geoserver.servlets.AbstractService - handling request: