GeoServer
  1. GeoServer
  2. GEOS-439

ERROR in SVG GetMap with Oracle

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0 RC4
    • Fix Version/s: 1.4.0-RC4
    • Component/s: Oracle
    • Labels:
      None
    • Environment:
      Windows XP, Oracle 9i, Java SDK 1.4.0
    • Number of attachments :
      6

      Description

      I get this error when I request for a SVG map using Oracle:

      15549 [SEVERE] org.geotools.data.jdbc.JDBC1DataStore - Error Performing SQL query: SELECT "ID1", "TEXTMUNI", "TEXCOMAR", "CAT_MUNI", "COD_INE", "COMAR_INE", "ENCLAVE_N", "GEOMETRY", "X_UTM30", "Y_UTM30", "X_UTM29", "Y_UTM29" FROM "MUNICIPIOS" WHERE SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(600495.96,4187947.48,901017.12,4187947.48,901017.12,4505000.26,600495.96,4505000.26,600495.96,4187947.48)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'

      Executing that query on the database the error says that i need an spatial filter.
      In Oracle documentation says that SDO_RELATE needs spatial filter for the first parameter. In that sentence the fist parameter is a temporaly geometry that doesn't have spatial index, but the second parameter have a spatial index. If I execute the query using both parameters but in reverse order:
      SELECT "ID1", "TEXTMUNI", "TEXCOMAR", "CAT_MUNI", "COD_INE", "COMAR_INE", "ENCLAVE_N", "GEOMETRY", "X_UTM30", "Y_UTM30", "X_UTM29", "Y_UTM29" FROM "MUNICIPIOS" WHERE SDO_RELATE("GEOMETRY", MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(600495.96,4187947.48,901017.12,4187947.48,901017.12,4505000.26,600495.96,4505000.26,600495.96,4187947.48)),'mask=anyinteract querytype=WINDOW') = 'TRUE'

      the sql returns data correctly.

      If i request for JPEG or PNG map using the same database no errors are returned

      1. sql-encoder-oracle.patch
        3 kB
        Chris Holmes
      1. .PNG map.jpg
        52 kB
      2. .SVG map.jpg
        37 kB

        Issue Links

          Activity

          Hide
          Jose Luis Fernandez added a comment -

          Using Format=image/svg+xml

          Show
          Jose Luis Fernandez added a comment - Using Format=image/svg+xml
          Hide
          Jose Luis Fernandez added a comment -

          Contains:

          • SVG file
          • PNG file
          • SLD file
          Show
          Jose Luis Fernandez added a comment - Contains: SVG file PNG file SLD file
          Hide
          Andrea Aime added a comment -

          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

          Show
          Andrea Aime added a comment - 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
          Hide
          Andrea Aime added a comment -

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

          Show
          Andrea Aime added a comment - Fixed on the geoserver side with a workaround. A better fix is still needed in geotools.
          Hide
          Andrea Aime added a comment -

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

          Show
          Andrea Aime added a comment - This issue has been resolved for one month or more without complaints. Closing it.

            People

            • Assignee:
              Andrea Aime
              Reporter:
              Jose Luis Fernandez
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: