3dcitydb / importer-exporter

3D City Database client for high-performance import and export of 3D city model data
Apache License 2.0
126 stars 53 forks source link

Spatial-filtered Export failed under Oracle #262

Closed yaozhihang closed 2 years ago

yaozhihang commented 2 years ago

The Export with the following query failed:

<query xmlns="http://www.3dcitydb.org/importer-exporter/config">
  <typeNames>
    <typeName xmlns:bldg="http://www.opengis.net/citygml/building/2.0">bldg:Building</typeName>
  </typeNames>
  <filter>
    <intersects>
      <valueReference>bldg:boundedBy/bldg:GroundSurface/bldg:lod2MultiSurface</valueReference>
      <polygon>
        <exterior dimension="2">694173 5329252 694167 5329252 694149 5329250 694102 5329245 694173 5329252</exterior>
      </polygon>
    </intersects>
  </filter>
</query>

The error message is:

[07:55:18 ERROR] Failed to query the database.
[07:55:18 ERROR] Caused by: java.sql.SQLException: ORA-22901: VARRAY oder LOB-Attribute eines Objekttyps können nicht verglichen werden

[07:55:18 ERROR] Caused by: oracle.jdbc.OracleDatabaseException: ORA-22901: VARRAY oder LOB-Attribute eines Objekttyps können nicht verglichen werden

[07:55:18 WARN] Database export aborted.
clausnagel commented 2 years ago

Fixed with #264.