Menu
▾
▴
[Geoserver-devel] Oracle WMS SRS?
|
From: scott o <os...@ya...> - 2004-07-15 23:18:27
|
Hi -
I'm trying to test a WMS request with an Oracle
Spatial backend. The Oracle Spatial query appears to
require that the SDO_SRID parameter be defined within
the SDO_GEOMETRY parameters of the query if the target
layer has an SDO_SRID defined. The SRS parameter is
not being assigned to the SDO_SRID and NULL is passed
into the SQL query for the SDO_SRID parameter (look in
snippet below for: "About to execure query: SELECT
SOURCE, GID, ..."). The query works fine when issued
within the database if the NULL is replaced with
41177.
The problem is that the SRS parameter is not being
passed to the SDO_SRID field. I've tried valid EPSG
codes, which I expected to pass through, but all
attempts pass a NULL. Perhaps the problem is with the
SQLEncoderOracle filter (91527057 [FINE]
org.geotools.filter.SQLEncoderOracle - Using NULL
SRID:)?
I'm using the 1.2.0-rc2 release rebuilt with the
gt2-oracle-spatial.jar posted on the geo181 task
tracker (to overcome connection problems), Tomcat
4.1.24, and Oracle 8.1.7 (and 10g) on Solaris 8.
Here's a snippet of the catalina.out:
91485375 [FINE] org.vfny.geoserver.global.Data -
loading datastore NV_GEOMETRY
91527015 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader -
clean request is
request=GetMap&layers=sclgis:NV_GEOMETRY&bbox
=489153,5433000,529000,5460816&width=800&height=400&srs=EPSG:41177&styles=normal&Format=image/svg
91527017 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader -
returning parsed {SRS=EPSG:41177,
BBOX=489153,5433000,529000,5
460816, LAYERS=sclgis:NV_GEOMETRY, HEIGHT=400,
REQUEST=GetMap, STYLES=normal, WIDTH=800,
FORMAT=image/svg}
91527019 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking
for configured service responses' strategy
91527020 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking
for configured service strategy SPEED
91527022 [FINE]
org.vfny.geoserver.servlets.AbstractService -
verifying configured strategy
91527023 [INFO]
org.vfny.geoserver.servlets.AbstractService - Using
service strategy class
org.vfny.geoserver.servlets.SpeedStrategy
91527026 [FINE] org.vfny.geoserver.global.Data -
getting type sclgis:NV_GEOMETRY
91527028 [INFO]
org.vfny.geoserver.servlets.AbstractService - handling
request:
org.vfny.geoserver.requests.wms.GetMapRequest@8845df8
b
91527029 [FINE]
org.vfny.geoserver.servlets.AbstractService - strategy
is: org.vfny.geoserver.servlets.SpeedStrategy@1417095
91527031 [FINE]
org.vfny.geoserver.responses.wms.map.SVGMapResponse -
checking if can producer image/svg, returningtrue
91527042 [FINE]
org.vfny.geoserver.servlets.AbstractService - mime
type is: image/svg+xml
91527045 [FINE]
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG -
obtaining FeatureReader for NV_GEOMETRY
91527055 [FINE] org.geotools.data.jdbc.JDBCDataStore -
calling sql builder with filter [ GEOMETRY bbox
POLYGON ((489153 5433000, 4891
53 5460816, 529000 5460816, 529000 5433000, 489153
5433000)) ]
91527057 [FINE] org.geotools.filter.SQLEncoderOracle -
Using NULL SRID:
91527059 [FINE] org.geotools.data.jdbc.JDBCDataStore -
sql is SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY
WHERE SDO_GEOM.RELATE("GE
OMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(489153.0,5433000.0,
489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,489153.0,5433000.0)),0.001)
= 'FALSE'
91527061 [FINE] org.geotools.data.jdbc.JDBCDataStore -
About to execure query: SELECT SOURCE, GID, GEOMETRY
FROM NV_GEOMETRY WHERE SD
O_GEOM.RELATE("GEOMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(48
9153.0,5433000.0,489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,489153.0,5433000.0)),0.001)
= 'FALSE'
91527063 [FINE] org.geotools.data.jdbc.ConnectionPool
- Getting available connection.
91529255 [SEVERE] org.geotools.data.jdbc.JDBCDataStore
- Error Performing SQL query
91529258 [WARNING] org.geotools.data.jdbc.JDBCUtils -
Error closing JDBC Statement
91529259 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
- Connection closed - adding to available connections.
91529262 [FINE]
org.vfny.geoserver.responses.wms.GetMapResponse -
asking delegate for aborting the process
91529263 [INFO]
org.vfny.geoserver.servlets.AbstractService - Had an
undefined error: Error Performing SQL query
org.geotools.data.DataSourceException: Error
Performing SQL query
at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStore.java:850)
at
org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCDataStore.java:614)
at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:202)
at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.writeLayers(EncodeSVG.java:140)
at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.encode(EncodeSVG.java:57)
at
org.vfny.geoserver.responses.wms.map.SVGMapResponse.writeTo(SVGMapResponse.java:136)
at
org.vfny.geoserver.responses.wms.GetMapResponse.writeTo(GetMapResponse.java:134)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:418)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:232)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDispatcher.java:135)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatcher.java:106)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
|