Hello,
Could any one please help me out in solving the problem to access the
Oracle Spatial(9i) data through WMS. I'm able to access and view the
map when the same data is requested through WFS. I'm getting a blank
map when a wms request is sent.
PRIMARY_OR_SECONDARY_ROADS is the featuretype i'm requesting for,
The request i sent is
On the tomcat stdout i could see the following errors:
11453 [FINE] org.vfny.geoserver.requests.readers.KvpRequestReader -
clean request is
VERSION=1.1.1&REQUEST=GetMap&SRS=EPSG:4326&BBOX=-13785974.775699,3887559.9
003044,-13343382.453985,4447803.345512&WIDTH=444&HEIGHT=562&LAYERS=topp:PRIMARY_
OR_SECONDARY_ROADS&STYLES=&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF&EX
CEPTIONS=application/vnd.ogc.se_xml
11469 [FINE] org.vfny.geoserver.requests.readers.KvpRequestReader -
returning parsed {VERSION=1.1.1, SRS=EPSG:4326,
EXCEPTIONS=application/vnd.ogc.se_xml,
LAYERS=topp:PRIMARY_OR_SECONDARY_ROADS,
BBOX=-13785974.775699,3887559.9003044,-13343382.453985,4447803.345512,
BGCOLOR=0xFFFFFF, HEIGHT=562, REQUEST=GetMap, WIDTH=4
44, FORMAT=image/png, TRANSPARENT=TRUE}
11484 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for
configured service responses' strategy
11484 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for
configured service strategy SPEED
11484 [FINE] org.vfny.geoserver.servlets.AbstractService - verifying
configured strategy
11484 [INFO] org.vfny.geoserver.servlets.AbstractService - Using
service strategy class org.vfny.geoserver.servlets.SpeedStrategy
11500 [FINE] org.vfny.geoserver.servlets.AbstractService - reading
request:
VERSION=1.1.1&REQUEST=GetMap&SRS=EPSG:4326&BBOX=-13785974.775699,3887559.9003044,-1
3343382.453985,4447803.345512&WIDTH=444&HEIGHT=562&LAYERS=topp:PRIMARY_OR_SECOND
ARY_ROADS&STYLES=&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF&EXCEPTIONS=
application/vnd.ogc.se_xml
11516 [FINE] org.vfny.geoserver.global.Data - getting type
topp:PRIMARY_OR_SECONDARY_ROADS
11516 [INFO] org.vfny.geoserver.servlets.AbstractService - handling
request: org.vfny.geoserver.requests.wms.GetMapRequest@anonymised.com
11531 [FINE] org.vfny.geoserver.servlets.AbstractService - strategy
is: org.vfny.geoserver.servlets.SpeedStrategy@anonymised.com
11781 [FINE] org.geotools.renderer.lite.LiteRenderer - creating new
lite renderer
11891 [CONFIG] org.vfny.geoserver.responses.wms.map.JAIMapResponse -
Supported JAIMapResponse's MIME Types: [image/x-portable-graymap,
image/jpeg, image/bmp, image/x-bmp, image/x-windows-bmp,
image/x-portable-pixmap, image/x-portable-anymap, image/png,
image/x-png, image/jp2, image/jpeg2000, image/tiff, image/vnd.wap.wbmp,
image/x-portable-bitmap, image/gif]
11922 [FINE] org.vfny.geoserver.responses.wms.map.GetMapDelegate -
query for map is Query:
feature type: PRIMARY_OR_SECONDARY_ROADS
[properties: GDO_GEOMETRY]
11922 [FINE] org.vfny.geoserver.responses.wms.map.JAIMapResponse -
setting up map
12078 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
12094 [FINE] org.vfny.geoserver.responses.wms.map.JAIMapResponse - map
setup
12281 [FINE] org.vfny.geoserver.responses.wms.map.JAIMapResponse -
setting to transparent
12281 [FINE] org.geotools.renderer.lite.LiteRenderer - Affine
Transform is AffineTransform[[0.001003180530292, 0.0,
13829.821486071047], [0.0, -0.001003135341979, 4461.748730056957]]
12297 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
12297 [FINE] org.geotools.renderer.lite.LiteRenderer - added attribute
GDO_GEOMETRY
12313 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
12313 [FINE] org.geotools.filter.SQLEncoderOracle - SQLEncoderOracle:
Geometric
Column is: GDO_GEOMETRY
12328 [FINE] org.geotools.filter.SQLEncoderOracle - SQLEncoderOracle:
Geometric
Column is: GDO_GEOMETRY
12328 [FINE] org.geotools.data.jdbc.JDBCDataStore - calling sql
builder with filter [ GDO_GEOMETRY bbox POLYGON ((-13785974.775699
3887559.9003044, -13785974.7
75699 4447803.345512, -13343382.453985 4447803.345512, -13343382.453985
3887559.9003044, -13785974.775699 3887559.9003044)) ]
12344 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL SRID:
12344 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT
MSLINK, GDO_GEOMETRY FROM PRIMARY_OR_SECONDARY_ROADS WHERE NOT
SDO_RELATE("GDO_GEOMETRY",MDSY
S.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDI
NATE_ARRAY(-1.3785974775699E7,3887559.9003044,-1.3785974775699E7,4447803.345512,
-1.3343382453985E7,4447803.345512,-1.3343382453985E7,3887559.9003044,-1.37859747
75699E7,3887559.9003044)),'mask=disjoint querytype=WINDOW') = 'TRUE'
12344 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to execure
query: SELECT MSLINK, GDO_GEOMETRY FROM PRIMARY_OR_SECONDARY_ROADS
WHERE NOT SDO_RELATE("G
DO_GEOMETRY",MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,
1),MDSYS.SDO_ORDINATE_ARRAY(-1.3785974775699E7,3887559.9003044,-1.3785974775699E
7,4447803.345512,-1.3343382453985E7,4447803.345512,-1.3343382453985E7,3887559.90
03044,-1.3785974775699E7,3887559.9003044)),'mask=disjoint
querytype=WINDOW') = 'TRUE'
12344 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
12391 [SEVERE] org.geotools.data.jdbc.JDBCDataStore - Error Performing
SQL query
12391 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Connection closed - adding to available connections.
12391 [WARNING] org.geotools.renderer.lite.LiteRenderer - Exception
org.geotools.data.DataSourceException: Error Performing SQL query
rendering layer org.geoto
ols.map.DefaultMapLayer@anonymised.com:
Error Performing SQL query at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStore.java:
861)
at
org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCDataStore.j
ava:624)
at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.j
ava:202)
at
org.geotools.renderer.lite.LiteRenderer.processStylers(LiteRenderer.j
ava:896)
at
org.geotools.renderer.lite.LiteRenderer.paint(LiteRenderer.java:498)
at
org.vfny.geoserver.responses.wms.map.JAIMapResponse.execute(JAIMapRes
ponse.java:343)
at
org.vfny.geoserver.responses.wms.map.GetMapDelegate.execute(GetMapDel
egate.java:148)
at
org.vfny.geoserver.responses.wms.map.GetMapDelegate.execute(GetMapDel
egate.java:108)
at
org.vfny.geoserver.responses.wms.GetMapResponse.execute(GetMapRespons
e.java:74)
at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService
.java:362)
at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.jav
a:235)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDispatche
r.java:137)
at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatcher.jav
a:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-13364: Layer Dimensionality does
not match
geometry dimensions
ORA-06512: at "MDSYS.SDO_3GL", line 41
ORA-06512: at "MDSYS.MD2", line 744
ORA-06512: at "MDSYS.SDO_3GL", line 121
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1250)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2529)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2857)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
640)
at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStore.java:
851)
... 40 more
12406 [FINE] org.vfny.geoserver.responses.wms.map.JAIMapResponse -
called rende
rer
12406 [FINE] org.vfny.geoserver.servlets.AbstractService - mime type
is: image/
png
12641 [INFO] org.vfny.geoserver.servlets.AbstractService - Service
handled
I'm using Geoserver 1.2.3. I'm able to solve this problem(i could view
the data if i use geoserver1.2.1 even with a WMS).
Thanks,
Vidya Katta
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com