ERROR in SVG GetMap with Oracle

This was fixed in RC5 or so, with Justin's improvements to the SVG outputter. If the problem remains reopen this issue.

Sorry, but I usually work with Geoserver1.3.0-RC6 and I have installed the 1.3-PR1 and the error doesn´t seem to be fixed.

When i request to Oracle Connections for SVG maps i always get the same result:
"Error Performing SQL query: SELECT....
...
Caused by: java.sql.SQLException: ORA-13226: interface not supported without a spatial index
"
I repeat that this only happends when a request for SVG maps with Oracle Connections. PNG, GIF and JPEG maps works fine.

The sql sentence it tries to execute and cause the error is:
SELECT "ID", "GEOMETRY", "IDNODO", "JERARQUIA", "CODNODO", "DESCRIPCION", "PADRE"
FROM "GEOZONA"
WHERE SDO_RELATE(
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(616860.7,4202460.0,885365.3,4202460.0,885365.3,4485499.0,616860.7,4485499.0,616860.7,4202460.0)),
"GEOMETRY",
'mask=anyinteract querytype=WINDOW'
) = 'TRUE'

I think this sentence it's wrong. In the function "SDO_RELATE" there are three parameters. The first one must have and spatial index, but in this sentence fist parameter can't have it because it's a temporaly geometry. But "GEOMETRY", the second parameter, have an spatial index.

If i put "GEOMETRY" as first parameter, and "MDSYS.SDO_GEOMETRY(...)" as second one, the sql sentence works fine. This is the reason I think there is an error in the construction of the sql sentence: in the "SDO_RELATE" the first parameter must be "GEOMETRY", and the second one must be "MDSYS.SDO_GEOMETRY(2003,....)"

Interesting. Apologies, I thought that the fix would do it, and didn't fully read the sql error.

Can you confirm that this works fine when returning png or jpeg? And if so attach the sql being performed for those? I want to try to figure out why the sql for the svg is different than for the jpeg/png, since I can't think of why it would be... Perhaps it's using a disjoint instead of a bbox or something.

I'm calling geoserver using the expresion

http://dpm-sbp-21:8085/geoserver/wms?version=1.3.0&request=getMap&srs=EPSG:23029&bbox=616860.7,4202460.0,885365.3,4485499.0&width=351&height=370&Format=image/svg+xml&SLD=http://dpm-sbp-21:8090/documentosGeoSanidad/SLDs/prueba.sld

When I change the expresion "Format=image/svg+xml" and use "Format=image/png", "Format=image/gif" or "Format=image/jpeg" geoserver returns the map (i'm sorry, no sql is showed in console when map is returned)

I'm going to attach a screenshot with the error generated in console by geoserver:

70483065 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy
70483080 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy PARTIAL-BUFFER
70483080 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.PartialBufferStrategy
70483080 [INFO] org.vfny.geoserver.servlets.AbstractService - Set buffer size to 50
70483111 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: org.vfny.geoserver.wms.requests.GetMapRequest@88468c22
70483174 [SEVERE] org.geotools.data.jdbc.JDBC1DataStore - Error Performing SQL query: SELECT "ID", "GEOMETRY", "IDNODO", "JERARQUIA", "CODNODO", "DESCRIPCION", "PADRE" FROM "GEOZONA" WHERE SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(616860.7,4202460.0,885365.3,4202460.0,885365.3,4485499.0,616860.7,4485499.0,616860.7,4202460.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'
70483174 [INFO] org.vfny.geoserver.wms.responses.map.SVGMapProducer - aborting SVG encoder
70483174 [INFO] org.vfny.geoserver.servlets.PartialBufferStrategy - OutputStream was successfully aborted.
70483174 [INFO] org.vfny.geoserver.servlets.AbstractService - Had an undefined error: Error Performing SQL query: SELECT "ID", "GEOMETRY", "IDNODO", "JERARQUIA", "CODNODO", "DESCRIPCION", "PADRE" FROM "GEOZONA" WHERE SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(616860.7,4202460.0,885365.3,4202460.0,885365.3,4485499.0,616860.7,4485499.0,616860.7,4202460.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'
org.vfny.geoserver.wms.WmsException: Error Performing SQL query: SELECT "ID", "GEOMETRY", "IDNODO", "JERARQUIA", "CODNODO", "DESCRIPCION", "PADRE" FROM "GEOZONA" WHERE SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(616860.7,4202460.0,885365.3,4202460.0,885365.3,4485499.0,616860.7,4485499.0,616860.7,4202460.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'
at org.vfny.geoserver.wms.WmsExceptionHandler.newServiceException(WmsExceptionHandler.java:64)
at org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:749)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:521)
at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:342)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:334)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:286)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "ID", "GEOMETRY", "IDNODO", "JERARQUIA", "CODNODO", "DESCRIPCION", "PADRE" FROM "GEOZONA" WHERE SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(616860.7,4202460.0,885365.3,4202460.0,885365.3,4485499.0,616860.7,4485499.0,616860.7,4202460.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:936)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
at org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
at org.vfny.geoserver.wms.responses.map.svg.EncodeSVG.writeLayers(EncodeSVG.java:206)
at org.vfny.geoserver.wms.responses.map.svg.EncodeSVG.encode(EncodeSVG.java:91)
at org.vfny.geoserver.wms.responses.map.SVGMapProducer.writeTo(SVGMapProducer.java:98)
at org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.java:224)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
... 23 more
Caused by: java.sql.SQLException: ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 62

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:1986)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1253)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2532)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:643)
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:925)
... 30 more

Ok, try the attached file, I think it should work. At least, it's a port from SDE which works right, I don't have an oracle instance to test it on.

Updated to be backwards compatible.

Your .jar file works, but I think still there is something wrong. I don't know if is a bug in oracle case or if it is normal in all cases.

When I get a PNG, GIF or JPG map each entity have his own style (defined in the .SLD file pased). However, if I use the same string to request a .SVG map all entities uses the same style (not defined in the .sld file pased). You can see screenshots attached.

I use the same string to call Geoserver in both cases (the only difference is the value of the parameter "Format"):

http://asi-dds-13:8085/geoserver/wms?version=1.3.0&request=getMap&srs=EPSG:23029&bbox=729659.0,4312216.5,734291.6,4314849.5&width=651&height=370&Format=image/png&SLD=http://asi-dds-13:8090/documentos/SLDs/prueba3.sld

http://asi-dds-13:8085/geoserver/wms?version=1.3.0&request=getMap&srs=EPSG:23029&bbox=729659.0,4312216.5,734291.6,4314849.5&width=651&height=370&Format=image/svg+xml&SLD=http://asi-dds-13:8090/documentos/SLDs/prueba3.sld

In the .SVG generated file all <g> nodes use "Default Styler" class (not defined in the .SLD file)

The attached file contains .SVGgenerated, .PNG generated and .SLD used.

¿Is this a normal operation?

Thanks in advance

Using:

• Format="image/png"
• Format="image/gif"
• Format="image/jpg"

Using Format=image/svg+xml

Contains:

• SVG file
• PNG file
• SLD file

Fixed on both 1.4.x (r 5544) and trunk (r5545) by swapping the geometry filter arguments... a proper fix should be made in the oracle datastore too

Fixed on the geoserver side with a workaround. A better fix is still needed in geotools.

This issue has been resolved for one month or more without complaints. Closing it.