Hello,
I have problems with the visualization (GetMap) of oracle data by geoserver.
The data seem to be correct on the oracle database. I importet the data
with shp2sdo by the following instruction:
shp2sdo2 wetter_wgs WETTER -g the_geom -i id -n 1 -s 4326
then I added the WETTER.sql to oracle and loaded the WETTER.dat into the table with sqlldr.
After defining the datastore in geoserver I tried to test it by a GetFeature-request.
The getfeature response of one feature from the geoserver (oracle datastore) looks like this:
<wfs:FeatureCollection xsi:schemaLocation=“http://www.openplans.org/topp http://localhost:8500/geoserver/wfs/DescribeFeatureType?typeName=topp:WETTER http://www.opengis.net/wfs http://localhost:8500/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd”>
gml:boundedBy
<gml:Box srsName=“http://www.opengis.net/gml/srs/epsg.xml#4326”>
<gml:coordinates decimal=“.” cs=“,” ts=" “>6.86594059,50.34881266 6.86594059,50.34881266</gml:coordinates>
</gml:Box>
</gml:boundedBy>
gml:featureMember
<topp:WETTER fid=“WETTER.1”>
topp:NUMMER506</topp:NUMMER>
topp:NAMENürburg</topp:NAME>
topp:HOEHE485</topp:HOEHE>
topp:POLYGONID0</topp:POLYGONID>
topp:SCALE1</topp:SCALE>
topp:ANGLE1000</topp:ANGLE>
topp:RELEVANZ8</topp:RELEVANZ>
topp:HOEHE_NEU446</topp:HOEHE_NEU>
topp:DATUM19990108</topp:DATUM>
topp:ART1</topp:ART>
topp:RICHTUNG274</topp:RICHTUNG>
topp:NEIGUNG2,0</topp:NEIGUNG>
topp:THE_GEOM
<gml:Point srsName=“http://www.opengis.net/gml/srs/epsg.xml#4326”>
<gml:coordinates decimal=”." cs=“,” ts=" ">6.86594059,50.34881266</gml:coordinates>
</gml:Point>
</topp:THE_GEOM>
</topp:WETTER>
</gml:featureMember>
</wfs:FeatureCollection>
When I want to use the GetMap-request in a browser the response is just a white picture but when I import this gml data in a GIS the geometry in presented
correctly.
The GetMap-request looks like this:
the log file “stdout_XXXXXX.log” from geoserver display the following messages:
16787469 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses’ strategy
16787469 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy PARTIAL-BUFFER
16787469 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.PartialBufferStrategy
16787469 [INFO] org.vfny.geoserver.servlets.AbstractService - Set buffer size to 50
16787469 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: org.vfny.geoserver.wms.requests.GetMapRequest@anonymised.com
16787828 [SCHWERWIEGEND] org.geotools.data.jdbc.JDBC1DataStore - Error Performing SQL query: SELECT “ID”, “THE_GEOM” FROM “WETTER” WHERE SDO_RELATE(“THE_GEOM”,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(6.31,49.04,8.38,49.04,8.38,50.73,6.31,50.73,6.31,49.04)),‘mask=anyinteract querytype=WINDOW’) = ‘TRUE’
16787828 [SCHWERWIEGEND] org.geotools.renderer.lite.StreamingRenderer$DefaultRenderListener - Exception rendering layer org.geotools.map.DefaultMapLayer@anonymised.com
16787969 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled
16788031 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses’ strategy
16788031 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy PARTIAL-BUFFER
16788031 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.PartialBufferStrategy
16788031 [INFO] org.vfny.geoserver.servlets.AbstractService - Set buffer size to 50
16788031 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: org.vfny.geoserver.wms.requests.GetMapRequest@anonymised.com
16788438 [SCHWERWIEGEND] org.geotools.data.jdbc.JDBC1DataStore - Error Performing SQL query: SELECT “ID”, “THE_GEOM” FROM “WETTER” WHERE SDO_RELATE(“THE_GEOM”,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(6.31,49.04,8.38,49.04,8.38,50.73,6.31,50.73,6.31,49.04)),‘mask=anyinteract querytype=WINDOW’) = ‘TRUE’
16788438 [SCHWERWIEGEND] org.geotools.renderer.lite.StreamingRenderer$DefaultRenderListener - Exception rendering layer org.geotools.map.DefaultMapLayer@anonymised.com
16788578 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled
Other layers (in shp format) are displayed correctly by the browser.
I read a lot about possibilities to eliminate problems with geoserver and oracle
in the mailing list and on http://docs.codehaus.org/display/GEOSDOC/Oracle+DataStore
but it did not help.
Where is the problem? Can anyone help me?
Regards
Michael