Package oracle.spatial.util

Class Adapters

  • public class Adapters
extends java.lang.Object

    • Constructor Summary

      Constructors 
      Constructor Description
      Adapters()  

    • Method Summary

      All Methods Static Methods Concrete Methods Deprecated Methods 
      Modifier and Type Method Description
      static java.sql.Struct affineTransforms​(java.sql.Struct geom, java.lang.String translation, oracle.sql.NUMBER tx, oracle.sql.NUMBER ty, oracle.sql.NUMBER tz, java.lang.String scaling, java.sql.Struct Psc1, oracle.sql.NUMBER sx, oracle.sql.NUMBER sy, oracle.sql.NUMBER sz, java.lang.String rotation, java.sql.Struct P1, java.sql.Struct line1, oracle.sql.NUMBER angle, oracle.sql.NUMBER dir, java.lang.String shearing, oracle.sql.NUMBER SHxy, oracle.sql.NUMBER SHyx, oracle.sql.NUMBER SHxz, oracle.sql.NUMBER SHzx, oracle.sql.NUMBER SHyz, oracle.sql.NUMBER SHzy, java.lang.String reflection, java.sql.Struct Pref, java.sql.Struct lineR, oracle.sql.NUMBER dirR, java.lang.String planeR, oracle.spatial.type.SdoNumberArray n, oracle.spatial.type.SdoNumberArray bigD)  
      static java.lang.String anyInteract​(java.sql.Struct geom1, java.sql.Struct geom2, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static oracle.sql.NUMBER area​(java.sql.Struct geom, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct buffer​(java.sql.Struct geom, oracle.sql.NUMBER bufferWidth, oracle.sql.NUMBER sma, oracle.sql.NUMBER iflat, oracle.sql.NUMBER arcT)  
      static java.sql.Struct centroid_3d​(java.sql.Struct geom, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct closestPoints​(java.sql.Struct geom1, java.sql.Struct geom2, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct decodePolylineAsGeom​(java.sql.Clob geomClob, oracle.sql.NUMBER srid, oracle.sql.NUMBER noOfDigits)  
      static oracle.sql.NUMBER distance​(java.sql.Struct geom1, java.sql.Struct geom2, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.sql.Clob encodePolylineAsClob​(java.sql.Struct geom, oracle.sql.NUMBER noOfDigits)  
      static java.sql.Struct expandG3Dgeoms​(java.sql.Struct geom)  
      static java.sql.Struct extract3d​(java.sql.Struct geom, java.lang.String label)  
      static java.sql.Struct extrusion2​(java.sql.Struct polygon, oracle.spatial.type.SdoNumberArray grdHeight, oracle.spatial.type.SdoNumberArray height, oracle.sql.NUMBER tolerance, oracle.sql.NUMBER optional3dSrid)  
      static java.lang.String getlabelbyelement​(java.sql.Struct source_Geom, java.sql.Struct qry_Element, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct getNurbsApprox​(java.sql.Struct geom)  
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml)  
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml, java.lang.String srsNameSpace)  
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml, java.sql.Connection conn)
      Deprecated.
      Connection parameter is ignored; static default connection is used instead.
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml, java.sql.Connection conn, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml)  
      static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml, java.lang.String srsNameSpace)  
      static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml)
      Deprecated.
      Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob) instead.
      static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml, java.lang.String srsNameSpace)
      Deprecated.
      Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, String) instead.
      static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)
      Deprecated.
      Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, String, NUMBER) instead.
      static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml, oracle.sql.NUMBER coordOrder)
      Deprecated.
      Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, NUMBER) instead.
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml)  
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml, java.lang.String srsNameSpace)  
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml, java.sql.Connection conn)
      Deprecated.
      Connection parameter is ignored; static default connection is used instead.
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml, java.sql.Connection conn, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gmlToSTRUCT​(java.lang.String gml, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml)  
      static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml, java.lang.String srsNameSpace)  
      static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml, oracle.sql.NUMBER coordOrder)  
      static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml)
      Deprecated.
      Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob) instead.
      static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml, java.lang.String srsNameSpace)
      Deprecated.
      Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, String) instead.
      static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml, java.lang.String srsNameSpace, oracle.sql.NUMBER coordOrder)
      Deprecated.
      Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, String, NUMBER) instead.
      static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml, oracle.sql.NUMBER coordOrder)
      Deprecated.
      Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, NUMBER) instead.
      static java.lang.String inside3d​(java.sql.Struct geom1, java.sql.Struct geom2, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct kmlToSTRUCT​(java.lang.String kml)  
      static java.sql.Struct kmlToSTRUCT​(java.lang.String kml, java.sql.Connection conn)
      Deprecated.
      conn ignored; uses class static default connection.
      static java.sql.Struct kmlToSTRUCT​(oracle.jdbc.OracleClob kml)  
      static java.sql.Struct kmlToSTRUCT​(oracle.sql.CLOB kml)
      Deprecated.
      Use oracle.jdbc.OracleClob and kmlToSTRUCT(OracleClob) instead.
      static oracle.sql.NUMBER length​(java.sql.Struct geom, oracle.sql.NUMBER count_shared_edges, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static oracle.sql.BLOB pctrclip​(java.sql.Struct qry, java.sql.Struct attr_qry, oracle.sql.BLOB pts, oracle.sql.NUMBER npts, oracle.sql.NUMBER numdim, oracle.sql.BLOB trs, oracle.sql.NUMBER ntrs, oracle.sql.NUMBER tolerance, oracle.sql.NUMBER includeCustomDim)
      Deprecated.
      Use oracle.jdbc.OracleBlob and pctrclipJS(Struct, Struct, OracleBlob, NUMBER, NUMBER, OracleBlob, NUMBER, NUMBER, NUMBER) instead.
      static oracle.jdbc.OracleBlob pctrclipJS​(java.sql.Struct qry, java.sql.Struct attr_qry, oracle.jdbc.OracleBlob pts, oracle.sql.NUMBER npts, oracle.sql.NUMBER numdim, oracle.jdbc.OracleBlob trs, oracle.sql.NUMBER ntrs, oracle.sql.NUMBER tolerance, oracle.sql.NUMBER includeCustomDim)  
      static void readpts​(oracle.sql.BLOB ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr, oracle.sql.NUMBER includeCustomDim)
      Deprecated.
      Use oracle.jdbc.OracleBlob and readptsJS(OracleBlob, int, int, Ptclass[], NUMBER) instead.
      static void readptsJS​(oracle.jdbc.OracleBlob ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr, oracle.sql.NUMBER includeCustomDim)  
      protected static JGeometry ringUnion​(JGeometry g, double tol)  
      static java.sql.Struct ringUnionApprox​(java.sql.Struct polygon, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct simplifyVW​(java.sql.Struct geom, oracle.sql.NUMBER vthreshold, oracle.sql.NUMBER sma, oracle.sql.NUMBER iflat)  
      static oracle.sql.BLOB structToWkb​(java.sql.Struct geom)
      Deprecated.
      Use structToWkbJS(Struct) instead.
      static oracle.sql.BLOB structToWkb​(java.sql.Struct geom, java.sql.Connection conn)
      Deprecated.
      Use structToWkbJS(Struct, Connection) instead.
      protected static oracle.sql.BLOB structToWkb2​(java.sql.Struct geom, java.sql.Connection conn)
      Deprecated.
      Use structToWkb2JS(Struct, Connection) instead.
      protected static oracle.jdbc.OracleBlob structToWkb2JS​(java.sql.Struct geom, java.sql.Connection conn)  
      static oracle.jdbc.OracleBlob structToWkbJS​(java.sql.Struct geom)  
      static oracle.jdbc.OracleBlob structToWkbJS​(java.sql.Struct geom, java.sql.Connection conn)  
      static oracle.sql.CLOB structToWkt​(java.sql.Struct geom)
      Deprecated.
      Use structToWktJS(Struct) instead.
      static oracle.sql.CLOB structToWkt​(java.sql.Struct geom, java.sql.Connection conn)
      Deprecated.
      Use structToWktJS(Struct, Connection) instead.
      protected static oracle.sql.CLOB structToWkt2​(java.sql.Struct geom, java.sql.Connection conn)
      Deprecated.
      Use structToWkt2JS(Struct, Connection) instead.
      protected static oracle.jdbc.OracleClob structToWkt2JS​(java.sql.Struct geom, java.sql.Connection conn)  
      static oracle.jdbc.OracleClob structToWktJS​(java.sql.Struct geom)  
      static oracle.jdbc.OracleClob structToWktJS​(java.sql.Struct geom, java.sql.Connection conn)  
      static java.lang.String structToWktString​(java.sql.Struct geom)  
      protected static java.lang.String structToWktString2​(java.sql.Struct geom)  
      static java.lang.Object[] toGeo3DLRSInfo​(java.sql.Struct LRSgeom)
      This method accepts a Struct SDO_GEOMETRY which is 4D/3D LRS (point, line string or multi-line) geometry and disintegrates the Measure information and outputs an Object array with J3D_Geometry object and double array of measures.
      static java.sql.Struct toGeo3DLRSStruct​(java.lang.Object[] LRSobj)
      This method accepts an Object array with J3D_Geometry object and double array of measures and integrates them into Struct SDO_GEOMETRY which is 4D/3D LRS (point, line string or multi-line) geometry.
      static oracle.sql.NUMBER validate_layer_with_context_3D​(java.lang.String geomTableName, java.lang.String geomColumnName, java.lang.String resultTableName, oracle.sql.NUMBER commit_interval, java.lang.String conditional, oracle.sql.NUMBER chck3dsrid, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.lang.String validateGeom​(java.sql.Struct geom, java.lang.String conditional, oracle.sql.NUMBER chck3dsrid, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.lang.String validateWkb​(oracle.jdbc.OracleBlob wkb)  
      static java.lang.String validateWkb​(oracle.jdbc.OracleBlob wkb, java.sql.Connection conn)  
      static java.lang.String validateWkb​(oracle.sql.BLOB wkb)
      Deprecated.
      Use oracle.jdbc.OracleBlob and validateWkb(OracleBlob) instead.
      static java.lang.String validateWkb​(oracle.sql.BLOB wkb, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleBlob and validateWkb(OracleBlob, Connection) instead.
      static java.lang.String validateWkt​(java.lang.String wkt)  
      static java.lang.String validateWkt​(java.lang.String wkt, java.sql.Connection conn)  
      static java.lang.String validateWkt​(oracle.jdbc.OracleClob wkt)  
      static java.lang.String validateWkt​(oracle.jdbc.OracleClob wkt, java.sql.Connection conn)  
      static java.lang.String validateWkt​(oracle.sql.CLOB wkt)
      Deprecated.
      Use oracle.jdbc.OracleClob and validateWkt(OracleClob) instead.
      static java.lang.String validateWkt​(oracle.sql.CLOB wkt, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleClob and validateWkt(OracleClob, Connection) instead.
      static java.lang.String validateXMLRecord​(oracle.jdbc.OracleClob xml, java.lang.String schema)
      This method validateXSDXML is used to validate (schema XSD and its) XML instance.
      static java.lang.String validateXMLRecord​(oracle.sql.CLOB xml, java.lang.String schema)
      This method validateXSDXML is used to validate (schema XSD and its) XML instance.
      static oracle.sql.NUMBER validateXSDXMLLayer​(java.lang.String tableName, java.lang.String columnName, java.lang.String schema, java.lang.String resultTableName, oracle.sql.NUMBER commit_interval)
      This method validateXSDXMLLayer is used to validate (schema XSD and its) all XML instances from a table such as CSW 202 User Table.
      static oracle.sql.NUMBER volume​(java.sql.Struct geom, java.lang.String is_g3d, oracle.sql.NUMBER smajax, oracle.sql.NUMBER flattening, oracle.sql.NUMBER g3d_geog_crs_uom_factor, oracle.sql.NUMBER is_unit_radians, oracle.sql.NUMBER tolerance)  
      static java.sql.Struct wkbToSTRUCT​(oracle.jdbc.OracleBlob wkb)  
      static java.sql.Struct wkbToSTRUCT​(oracle.jdbc.OracleBlob wkb, java.sql.Connection conn)  
      static java.sql.Struct wkbToSTRUCT​(oracle.sql.BLOB wkb)
      Deprecated.
      Use oracle.jdbc.OracleClob and wkbToSTRUCT(OracleBlob) instead.
      static java.sql.Struct wkbToSTRUCT​(oracle.sql.BLOB wkb, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleClob and wkbToSTRUCT(OracleBlob, Connection) instead.
      protected static java.sql.Struct wkbToSTRUCT2​(oracle.jdbc.OracleBlob wkb, java.sql.Connection conn)  
      protected static java.sql.Struct wkbToSTRUCT2​(oracle.sql.BLOB wkb, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleClob and wkbToSTRUCT2(OracleBlob, Connection) instead.
      static java.sql.Struct wktToSTRUCT​(java.lang.String wkt)  
      static java.sql.Struct wktToSTRUCT​(java.lang.String wkt, java.sql.Connection conn)  
      static java.sql.Struct wktToSTRUCT​(oracle.jdbc.OracleClob wkt)  
      static java.sql.Struct wktToSTRUCT​(oracle.jdbc.OracleClob wkt, java.sql.Connection conn)  
      static java.sql.Struct wktToSTRUCT​(oracle.sql.CLOB wkt)
      Deprecated.
      Use oracle.jdbc.OracleClob and wktToSTRUCT(OracleClob) instead.
      static java.sql.Struct wktToSTRUCT​(oracle.sql.CLOB wkt, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleClob and wktToSTRUCT(OracleClob, Connection) instead.
      protected static java.sql.Struct wktToSTRUCT2​(java.lang.String wkt, java.sql.Connection conn)  
      protected static java.sql.Struct wktToSTRUCT2​(oracle.jdbc.OracleClob wkt, java.sql.Connection conn)  
      protected static java.sql.Struct wktToSTRUCT2​(oracle.sql.CLOB wkt, java.sql.Connection conn)
      Deprecated.
      Use oracle.jdbc.OracleClob and wktToSTRUCT2(OracleClob, Connection) instead.
      static void writepts​(oracle.sql.BLOB ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr, oracle.sql.NUMBER includeCustomDim)
      Deprecated.
      Use oracle.jdbc.OracleBlob and writeptsJS(OracleBlob, int, int, Ptclass[], NUMBER) instead.
      static void writeptsJS​(oracle.jdbc.OracleBlob ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr, oracle.sql.NUMBER includeCustomDim)  

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • Field Detail

      • m_conn

        protected static final java.sql.Connection m_conn

      • m_wkbAdapter

        protected static final WKB m_wkbAdapter

      • m_wktAdapter

        protected static final WKT m_wktAdapter

    • Constructor Detail

      • Adapters

        public Adapters()

    • Method Detail

      • wkbToSTRUCT

        public static java.sql.Struct wkbToSTRUCT​(oracle.sql.BLOB wkb)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and wkbToSTRUCT(OracleBlob) instead.
        Parameters:
        wkb - The BLOB WKB Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • wkbToSTRUCT

        public static java.sql.Struct wkbToSTRUCT​(oracle.sql.BLOB wkb,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and wkbToSTRUCT(OracleBlob, Connection) instead.
        Parameters:
        wkb - The BLOB WKB Object
        conn - The Database Connection
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • wkbToSTRUCT2

        protected static java.sql.Struct wkbToSTRUCT2​(oracle.sql.BLOB wkb,
                                              java.sql.Connection conn)
                                       throws java.sql.SQLException,
                                              GeometryExceptionWithContext
        Deprecated.
        Use oracle.jdbc.OracleClob and wkbToSTRUCT2(OracleBlob, Connection) instead.
        Parameters:
        wkb - The BLOB WKB Object
        conn - The Database Connection
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception
        GeometryExceptionWithContext - The GeometryExceptionWithContext Exception

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(oracle.sql.CLOB wkt)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and wktToSTRUCT(OracleClob) instead.
        Parameters:
        wkt - The CLOB WKT Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(oracle.sql.CLOB wkt,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and wktToSTRUCT(OracleClob, Connection) instead.
        Parameters:
        wkt - The CLOB WKT Object
        conn - The Database Connection
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • wktToSTRUCT2

        protected static java.sql.Struct wktToSTRUCT2​(oracle.sql.CLOB wkt,
                                              java.sql.Connection conn)
                                       throws java.sql.SQLException,
                                              GeometryExceptionWithContext
        Deprecated.
        Use oracle.jdbc.OracleClob and wktToSTRUCT2(OracleClob, Connection) instead.
        Parameters:
        wkt - The CLOB WKT Object
        conn - The Database Connection
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception
        GeometryExceptionWithContext - The GeometryExceptionWithContext Exception

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(java.lang.String wkt)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(java.lang.String wkt,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • kmlToSTRUCT

        public static java.sql.Struct kmlToSTRUCT​(java.lang.String kml)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • buffer

        public static java.sql.Struct buffer​(java.sql.Struct geom,
                                     oracle.sql.NUMBER bufferWidth,
                                     oracle.sql.NUMBER sma,
                                     oracle.sql.NUMBER iflat,
                                     oracle.sql.NUMBER arcT)
                              throws java.sql.SQLException,
                                     java.lang.Exception
        Throws:
        java.sql.SQLException
        java.lang.Exception

      • simplifyVW

        public static java.sql.Struct simplifyVW​(java.sql.Struct geom,
                                         oracle.sql.NUMBER vthreshold,
                                         oracle.sql.NUMBER sma,
                                         oracle.sql.NUMBER iflat)
                                  throws java.sql.SQLException,
                                         java.lang.Exception
        Throws:
        java.sql.SQLException
        java.lang.Exception

      • getNurbsApprox

        public static java.sql.Struct getNurbsApprox​(java.sql.Struct geom)
                                      throws java.sql.SQLException,
                                             java.lang.Exception
        Throws:
        java.sql.SQLException
        java.lang.Exception

      • anyInteract

        public static java.lang.String anyInteract​(java.sql.Struct geom1,
                                           java.sql.Struct geom2,
                                           java.lang.String is_g3d,
                                           oracle.sql.NUMBER smajax,
                                           oracle.sql.NUMBER flattening,
                                           oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                           oracle.sql.NUMBER is_unit_radians,
                                           oracle.sql.NUMBER tolerance)
                                    throws java.lang.Exception
        Throws:
        java.lang.Exception

      • distance

        public static oracle.sql.NUMBER distance​(java.sql.Struct geom1,
                                         java.sql.Struct geom2,
                                         java.lang.String is_g3d,
                                         oracle.sql.NUMBER smajax,
                                         oracle.sql.NUMBER flattening,
                                         oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                         oracle.sql.NUMBER is_unit_radians,
                                         oracle.sql.NUMBER tolerance)
                                  throws java.lang.Exception
        Throws:
        java.lang.Exception

      • length

        public static oracle.sql.NUMBER length​(java.sql.Struct geom,
                                       oracle.sql.NUMBER count_shared_edges,
                                       java.lang.String is_g3d,
                                       oracle.sql.NUMBER smajax,
                                       oracle.sql.NUMBER flattening,
                                       oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                       oracle.sql.NUMBER is_unit_radians,
                                       oracle.sql.NUMBER tolerance)
                                throws java.lang.Exception
        Throws:
        java.lang.Exception

      • area

        public static oracle.sql.NUMBER area​(java.sql.Struct geom,
                                     java.lang.String is_g3d,
                                     oracle.sql.NUMBER smajax,
                                     oracle.sql.NUMBER flattening,
                                     oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                     oracle.sql.NUMBER is_unit_radians,
                                     oracle.sql.NUMBER tolerance)
                              throws java.lang.Exception
        Throws:
        java.lang.Exception

      • volume

        public static oracle.sql.NUMBER volume​(java.sql.Struct geom,
                                       java.lang.String is_g3d,
                                       oracle.sql.NUMBER smajax,
                                       oracle.sql.NUMBER flattening,
                                       oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                       oracle.sql.NUMBER is_unit_radians,
                                       oracle.sql.NUMBER tolerance)
                                throws java.lang.Exception
        Throws:
        java.lang.Exception

      • validateGeom

        public static java.lang.String validateGeom​(java.sql.Struct geom,
                                            java.lang.String conditional,
                                            oracle.sql.NUMBER chck3dsrid,
                                            oracle.sql.NUMBER smajax,
                                            oracle.sql.NUMBER flattening,
                                            oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                            oracle.sql.NUMBER is_unit_radians,
                                            oracle.sql.NUMBER tolerance)
                                     throws java.lang.Exception
        Throws:
        java.lang.Exception

      • closestPoints

        public static java.sql.Struct closestPoints​(java.sql.Struct geom1,
                                            java.sql.Struct geom2,
                                            java.lang.String is_g3d,
                                            oracle.sql.NUMBER smajax,
                                            oracle.sql.NUMBER flattening,
                                            oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                            oracle.sql.NUMBER is_unit_radians,
                                            oracle.sql.NUMBER tolerance)
                                     throws java.lang.Exception
        Throws:
        java.lang.Exception

      • affineTransforms

        public static java.sql.Struct affineTransforms​(java.sql.Struct geom,
                                               java.lang.String translation,
                                               oracle.sql.NUMBER tx,
                                               oracle.sql.NUMBER ty,
                                               oracle.sql.NUMBER tz,
                                               java.lang.String scaling,
                                               java.sql.Struct Psc1,
                                               oracle.sql.NUMBER sx,
                                               oracle.sql.NUMBER sy,
                                               oracle.sql.NUMBER sz,
                                               java.lang.String rotation,
                                               java.sql.Struct P1,
                                               java.sql.Struct line1,
                                               oracle.sql.NUMBER angle,
                                               oracle.sql.NUMBER dir,
                                               java.lang.String shearing,
                                               oracle.sql.NUMBER SHxy,
                                               oracle.sql.NUMBER SHyx,
                                               oracle.sql.NUMBER SHxz,
                                               oracle.sql.NUMBER SHzx,
                                               oracle.sql.NUMBER SHyz,
                                               oracle.sql.NUMBER SHzy,
                                               java.lang.String reflection,
                                               java.sql.Struct Pref,
                                               java.sql.Struct lineR,
                                               oracle.sql.NUMBER dirR,
                                               java.lang.String planeR,
                                               oracle.spatial.type.SdoNumberArray n,
                                               oracle.spatial.type.SdoNumberArray bigD)
                                        throws java.lang.Exception
        Throws:
        java.lang.Exception

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml,
                                          java.lang.String srsNameSpace)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        @Deprecated
public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        Connection parameter is ignored; static default connection is used instead. Perhaps this is a bug.
        Parameters:
        gml - The String GML Object
        conn - The Database Connection
        Returns:
        Throws:
        java.sql.SQLException - The SQL Exception

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob) instead.
        Parameters:
        gml - The CLOB GML Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml,
                                          java.lang.String srsNameSpace)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, String) instead.
        Parameters:
        gml - The CLOB GML Object
        srsNameSpace - The SRS Namespace String Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml,
                                             java.lang.String srsNameSpace)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        @Deprecated
public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml,
                                             java.sql.Connection conn)
                                      throws java.sql.SQLException
        Deprecated.
        Connection parameter is ignored; static default connection is used instead. Perhaps this is a bug.
        Parameters:
        gml - The String GML Object
        conn - The Database Connection
        Returns:
        Throws:
        java.sql.SQLException - The SQL Exception

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml)
                                      throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob) instead.
        Parameters:
        gml - The CLOB GML Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml,
                                             java.lang.String srsNameSpace)
                                      throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, String) instead.
        Parameters:
        gml - The CLOB GML Object
        srsNameSpace - The SRS Namespace String Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • kmlToSTRUCT

        public static java.sql.Struct kmlToSTRUCT​(java.lang.String kml,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        conn ignored; uses class static default connection. Perhaps this is a bug.
        Parameters:
        kml - The String KML Object
        conn - The Database Connection
        Returns:
        Throws:
        java.sql.SQLException - The SQL Exception

      • kmlToSTRUCT

        public static java.sql.Struct kmlToSTRUCT​(oracle.sql.CLOB kml)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and kmlToSTRUCT(OracleClob) instead.
        Parameters:
        kml - The CLOB KML Object
        Returns:
        Struct
        Throws:
        java.sql.SQLException - The SQL Exception

      • structToWkb

        public static oracle.sql.BLOB structToWkb​(java.sql.Struct geom)
                                   throws java.sql.SQLException
        Deprecated.
        Use structToWkbJS(Struct) instead.
        Parameters:
        geom - The Struct Geometry Object
        Returns:
        BLOB
        Throws:
        java.sql.SQLException - The SQL Exception

      • structToWkb

        public static oracle.sql.BLOB structToWkb​(java.sql.Struct geom,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        Use structToWkbJS(Struct, Connection) instead.
        Parameters:
        geom - The Struct Geometry Object
        conn - The Database Connection
        Returns:
        BLOB
        Throws:
        java.sql.SQLException - The SQL Exception

      • structToWkt

        public static oracle.sql.CLOB structToWkt​(java.sql.Struct geom)
                                   throws java.sql.SQLException
        Deprecated.
        Use structToWktJS(Struct) instead.
        Parameters:
        geom - The Struct Geometry Object
        Returns:
        CLOB
        Throws:
        java.sql.SQLException - The SQL Exception

      • structToWktString

        public static java.lang.String structToWktString​(java.sql.Struct geom)
                                          throws java.sql.SQLException
        Parameters:
        geom - The Struct Geometry Object
        Returns:
        String
        Throws:
        java.sql.SQLException - The SQL Exception

      • structToWkt

        public static oracle.sql.CLOB structToWkt​(java.sql.Struct geom,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Deprecated.
        Use structToWktJS(Struct, Connection) instead.
        Parameters:
        geom - The Struct Geometry Object
        conn - The Database Connection
        Returns:
        CLOB
        Throws:
        java.sql.SQLException - The SQL Exception

      • validateWkt

        public static java.lang.String validateWkt​(oracle.sql.CLOB wkt)
        Deprecated.
        Use oracle.jdbc.OracleClob and validateWkt(OracleClob) instead.
        Parameters:
        wkt - The WKT BLOB Object
        Returns:
        String

      • validateWkt

        public static java.lang.String validateWkt​(oracle.sql.CLOB wkt,
                                           java.sql.Connection conn)
        Deprecated.
        Use oracle.jdbc.OracleClob and validateWkt(OracleClob, Connection) instead.
        Parameters:
        wkt - The WKT CLOB Object
        conn - The Database Connection
        Returns:
        String

      • validateWkt

        public static java.lang.String validateWkt​(java.lang.String wkt)

      • validateWkt

        public static java.lang.String validateWkt​(java.lang.String wkt,
                                           java.sql.Connection conn)

      • validateWkb

        public static java.lang.String validateWkb​(oracle.sql.BLOB wkb)
        Deprecated.
        Use oracle.jdbc.OracleBlob and validateWkb(OracleBlob) instead.
        Parameters:
        wkb - The WKB BLOB Object
        Returns:
        String

      • validateWkb

        public static java.lang.String validateWkb​(oracle.sql.BLOB wkb,
                                           java.sql.Connection conn)
        Deprecated.
        Use oracle.jdbc.OracleBlob and validateWkb(OracleBlob, Connection) instead.
        Parameters:
        wkb - The WKB BLOB Object
        conn - The Database Connection
        Returns:
        String

      • validate_layer_with_context_3D

        public static oracle.sql.NUMBER validate_layer_with_context_3D​(java.lang.String geomTableName,
                                                               java.lang.String geomColumnName,
                                                               java.lang.String resultTableName,
                                                               oracle.sql.NUMBER commit_interval,
                                                               java.lang.String conditional,
                                                               oracle.sql.NUMBER chck3dsrid,
                                                               oracle.sql.NUMBER smajax,
                                                               oracle.sql.NUMBER flattening,
                                                               oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                                               oracle.sql.NUMBER is_unit_radians,
                                                               oracle.sql.NUMBER tolerance)
                                                        throws java.sql.SQLSyntaxErrorException,
                                                               java.sql.SQLException,
                                                               java.lang.Exception
        Throws:
        java.sql.SQLSyntaxErrorException
        java.sql.SQLException
        java.lang.Exception

      • centroid_3d

        public static java.sql.Struct centroid_3d​(java.sql.Struct geom,
                                          oracle.sql.NUMBER tolerance)
                                   throws java.lang.Exception,
                                          java.sql.SQLException
        Throws:
        java.lang.Exception
        java.sql.SQLException

      • extrusion2

        public static java.sql.Struct extrusion2​(java.sql.Struct polygon,
                                         oracle.spatial.type.SdoNumberArray grdHeight,
                                         oracle.spatial.type.SdoNumberArray height,
                                         oracle.sql.NUMBER tolerance,
                                         oracle.sql.NUMBER optional3dSrid)
                                  throws java.lang.Exception,
                                         java.sql.SQLException
        Throws:
        java.lang.Exception
        java.sql.SQLException

      • ringUnionApprox

        public static java.sql.Struct ringUnionApprox​(java.sql.Struct polygon,
                                              oracle.sql.NUMBER tolerance)
                                       throws java.lang.Exception,
                                              java.sql.SQLException
        Throws:
        java.lang.Exception
        java.sql.SQLException

      • extract3d

        public static java.sql.Struct extract3d​(java.sql.Struct geom,
                                        java.lang.String label)
                                 throws java.lang.Exception
        Throws:
        java.lang.Exception

      • getlabelbyelement

        public static java.lang.String getlabelbyelement​(java.sql.Struct source_Geom,
                                                 java.sql.Struct qry_Element,
                                                 oracle.sql.NUMBER tolerance)
                                          throws java.lang.Exception
        Throws:
        java.lang.Exception

      • inside3d

        public static java.lang.String inside3d​(java.sql.Struct geom1,
                                        java.sql.Struct geom2,
                                        java.lang.String is_g3d,
                                        oracle.sql.NUMBER smajax,
                                        oracle.sql.NUMBER flattening,
                                        oracle.sql.NUMBER g3d_geog_crs_uom_factor,
                                        oracle.sql.NUMBER is_unit_radians,
                                        oracle.sql.NUMBER tolerance)
                                 throws java.lang.Exception
        Throws:
        java.lang.Exception

      • readpts

        public static void readpts​(oracle.sql.BLOB ptlob,
                           int numpts,
                           int ndim,
                           oracle.spatial.util.Adapters.Ptclass[] ptarr,
                           oracle.sql.NUMBER includeCustomDim)
                    throws java.sql.SQLException,
                           java.io.IOException
        Deprecated.
        Use oracle.jdbc.OracleBlob and readptsJS(OracleBlob, int, int, Ptclass[], NUMBER) instead.
        Parameters:
        ptlob - BLOB Object
        numpts - Number of Points
        ndim - Number of Dimensions
        ptarr - Point Array
        includeCustomDim - Include custom dimension
        Throws:
        java.sql.SQLException - The SQL Exception
        java.io.IOException - The IO Exception

      • writepts

        public static void writepts​(oracle.sql.BLOB ptlob,
                            int numpts,
                            int ndim,
                            oracle.spatial.util.Adapters.Ptclass[] ptarr,
                            oracle.sql.NUMBER includeCustomDim)
                     throws java.sql.SQLException,
                            java.io.IOException
        Deprecated.
        Use oracle.jdbc.OracleBlob and writeptsJS(OracleBlob, int, int, Ptclass[], NUMBER) instead.
        Parameters:
        ptlob - BLOB Object
        numpts - Number of Points
        ndim - Number of dimensions
        ptarr - Point Array
        includeCustomDim - Include custom dimension
        Throws:
        java.sql.SQLException - The SQL Exception
        java.io.IOException - The IO Exception

      • pctrclip

        public static oracle.sql.BLOB pctrclip​(java.sql.Struct qry,
                                       java.sql.Struct attr_qry,
                                       oracle.sql.BLOB pts,
                                       oracle.sql.NUMBER npts,
                                       oracle.sql.NUMBER numdim,
                                       oracle.sql.BLOB trs,
                                       oracle.sql.NUMBER ntrs,
                                       oracle.sql.NUMBER tolerance,
                                       oracle.sql.NUMBER includeCustomDim)
                                throws java.sql.SQLException,
                                       java.io.IOException,
                                       java.lang.Exception
        Deprecated.
        Use oracle.jdbc.OracleBlob and pctrclipJS(Struct, Struct, OracleBlob, NUMBER, NUMBER, OracleBlob, NUMBER, NUMBER, NUMBER) instead.
        Parameters:
        qry - The Query
        attr_qry - The attr Query
        pts - Points
        npts - Number of Points
        numdim - Dimension Number
        trs - BLOB Object
        ntrs - NUMBER Object
        tolerance - The tolerance
        includeCustomDim - Including custom dimension
        Returns:
        BLOB The BLOB Object
        Throws:
        java.sql.SQLException - The SQL Exception
        java.io.IOException - The IO Exception
        java.lang.Exception - The Exception

      • expandG3Dgeoms

        public static java.sql.Struct expandG3Dgeoms​(java.sql.Struct geom)
                                      throws java.lang.Exception
        Throws:
        java.lang.Exception

      • toGeo3DLRSInfo

        public static java.lang.Object[] toGeo3DLRSInfo​(java.sql.Struct LRSgeom)
                                         throws java.lang.Exception
        This method accepts a Struct SDO_GEOMETRY which is 4D/3D LRS (point, line string or multi-line) geometry and disintegrates the Measure information and outputs an Object array with J3D_Geometry object and double array of measures. This is the reverse process of integrateLRS method. If the double array of measures is null, that means the input geometry geomLRS is not LRS geometry.
        Parameters:
        LRSgeom - Struct SDO_GEOMETRY which is 4D/3D LRS (point, line string or multi-line) geometry
        Returns:
        Object[] array with 2 elements: J3D_Geometry object and double array of measures
        Throws:
        java.lang.Exception - The Exception

      • toGeo3DLRSStruct

        public static java.sql.Struct toGeo3DLRSStruct​(java.lang.Object[] LRSobj)
                                        throws java.lang.Exception
        This method accepts an Object array with J3D_Geometry object and double array of measures and integrates them into Struct SDO_GEOMETRY which is 4D/3D LRS (point, line string or multi-line) geometry. This is the reverse process of disintegrateLRS method.
        Parameters:
        LRSobj - Object[] array with 2 elements: J3D_Geometry object and double array of measures
        Returns:
        STRUCT SDO_GEOMETRY which is 4D/3D LRS (point, line string, multi-line) geometry
        Throws:
        java.lang.Exception - The Exception

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml,
                                          java.lang.String srsNameSpace,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(java.lang.String gml,
                                          java.sql.Connection conn,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Parameters:
        gml - The String GML Object
        conn - used for setConnection; class static default connection used for conversion to Struct. Perhaps this is a bug.
        coordOrder - The coordinate order
        Returns:
        Struct Object
        Throws:
        java.sql.SQLException - The SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, NUMBER) instead.
        Parameters:
        gml -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.sql.CLOB gml,
                                          java.lang.String srsNameSpace,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gmlToSTRUCT(OracleClob, String, NUMBER) instead.
        Parameters:
        gml -
        srsNameSpace -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml,
                                             java.lang.String srsNameSpace,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(java.lang.String gml,
                                             java.sql.Connection conn,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Parameters:
        gml -
        conn - uses this connection and also this class's static default connection. This is perhaps a bug.
        coordOrder -
        Returns:
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, NUMBER) instead.
        Parameters:
        gml -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.sql.CLOB gml,
                                             java.lang.String srsNameSpace,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Deprecated.
        Use oracle.jdbc.OracleClob and gml311ToSTRUCT(OracleClob, String, NUMBER) instead.
        Parameters:
        gml -
        srsNameSpace -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(oracle.jdbc.OracleClob wkt)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • wktToSTRUCT

        public static java.sql.Struct wktToSTRUCT​(oracle.jdbc.OracleClob wkt,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • wkbToSTRUCT

        public static java.sql.Struct wkbToSTRUCT​(oracle.jdbc.OracleBlob wkb)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • wkbToSTRUCT

        public static java.sql.Struct wkbToSTRUCT​(oracle.jdbc.OracleBlob wkb,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • structToWkbJS

        public static oracle.jdbc.OracleBlob structToWkbJS​(java.sql.Struct geom)
                                            throws java.sql.SQLException
        Parameters:
        geom -
        Returns:
        OracleBlob
        Throws:
        java.sql.SQLException

      • structToWkbJS

        public static oracle.jdbc.OracleBlob structToWkbJS​(java.sql.Struct geom,
                                                   java.sql.Connection conn)
                                            throws java.sql.SQLException
        Parameters:
        geom -
        conn -
        Returns:
        OracleBlob
        Throws:
        java.sql.SQLException

      • structToWkb2JS

        protected static oracle.jdbc.OracleBlob structToWkb2JS​(java.sql.Struct geom,
                                                       java.sql.Connection conn)
                                                throws java.sql.SQLException,
                                                       GeometryExceptionWithContext
        Parameters:
        geom -
        conn -
        Returns:
        OracleBlob
        Throws:
        java.sql.SQLException
        GeometryExceptionWithContext

      • structToWktJS

        public static oracle.jdbc.OracleClob structToWktJS​(java.sql.Struct geom)
                                            throws java.sql.SQLException
        Parameters:
        geom -
        Returns:
        OracleClob
        Throws:
        java.sql.SQLException

      • structToWktJS

        public static oracle.jdbc.OracleClob structToWktJS​(java.sql.Struct geom,
                                                   java.sql.Connection conn)
                                            throws java.sql.SQLException
        Parameters:
        geom -
        conn -
        Returns:
        OracleClob
        Throws:
        java.sql.SQLException

      • structToWkt2JS

        protected static oracle.jdbc.OracleClob structToWkt2JS​(java.sql.Struct geom,
                                                       java.sql.Connection conn)
                                                throws java.sql.SQLException,
                                                       GeometryExceptionWithContext
        Parameters:
        geom -
        conn -
        Returns:
        OracleClob
        Throws:
        java.sql.SQLException
        GeometryExceptionWithContext

      • validateWkb

        public static java.lang.String validateWkb​(oracle.jdbc.OracleBlob wkb)
        Parameters:
        wkb -
        Returns:
        String

      • validateWkb

        public static java.lang.String validateWkb​(oracle.jdbc.OracleBlob wkb,
                                           java.sql.Connection conn)
        Parameters:
        wkb -
        conn -
        Returns:
        String

      • validateWkt

        public static java.lang.String validateWkt​(oracle.jdbc.OracleClob wkt)
        Parameters:
        wkt -
        Returns:
        String

      • validateWkt

        public static java.lang.String validateWkt​(oracle.jdbc.OracleClob wkt,
                                           java.sql.Connection conn)
        Parameters:
        wkt -
        conn -
        Returns:
        String

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml)
                                      throws java.sql.SQLException
        Parameters:
        gml -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Parameters:
        gml -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml,
                                             java.lang.String srsNameSpace)
                                      throws java.sql.SQLException
        Parameters:
        gml -
        srsNameSpace -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gml311ToSTRUCT

        public static java.sql.Struct gml311ToSTRUCT​(oracle.jdbc.OracleClob gml,
                                             java.lang.String srsNameSpace,
                                             oracle.sql.NUMBER coordOrder)
                                      throws java.sql.SQLException
        Parameters:
        gml -
        srsNameSpace -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml)
                                   throws java.sql.SQLException
        Parameters:
        gml -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Parameters:
        gml -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml,
                                          java.lang.String srsNameSpace)
                                   throws java.sql.SQLException
        Parameters:
        gml -
        srsNameSpace -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • gmlToSTRUCT

        public static java.sql.Struct gmlToSTRUCT​(oracle.jdbc.OracleClob gml,
                                          java.lang.String srsNameSpace,
                                          oracle.sql.NUMBER coordOrder)
                                   throws java.sql.SQLException
        Parameters:
        gml -
        srsNameSpace -
        coordOrder -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • kmlToSTRUCT

        public static java.sql.Struct kmlToSTRUCT​(oracle.jdbc.OracleClob kml)
                                   throws java.sql.SQLException
        Parameters:
        kml -
        Returns:
        Struct
        Throws:
        java.sql.SQLException

      • pctrclipJS

        public static oracle.jdbc.OracleBlob pctrclipJS​(java.sql.Struct qry,
                                                java.sql.Struct attr_qry,
                                                oracle.jdbc.OracleBlob pts,
                                                oracle.sql.NUMBER npts,
                                                oracle.sql.NUMBER numdim,
                                                oracle.jdbc.OracleBlob trs,
                                                oracle.sql.NUMBER ntrs,
                                                oracle.sql.NUMBER tolerance,
                                                oracle.sql.NUMBER includeCustomDim)
                                         throws java.sql.SQLException,
                                                java.io.IOException,
                                                java.lang.Exception
        Parameters:
        qry -
        attr_qry -
        pts -
        npts -
        numdim -
        trs -
        ntrs -
        tolerance -
        includeCustomDim -
        Returns:
        OracleBlob
        Throws:
        java.sql.SQLException
        java.io.IOException
        java.lang.Exception

      • readptsJS

        public static void readptsJS​(oracle.jdbc.OracleBlob ptlob,
                             int numpts,
                             int ndim,
                             oracle.spatial.util.Adapters.Ptclass[] ptarr,
                             oracle.sql.NUMBER includeCustomDim)
                      throws java.sql.SQLException,
                             java.io.IOException
        Parameters:
        ptlob -
        numpts -
        ndim -
        ptarr -
        includeCustomDim -
        Throws:
        java.sql.SQLException
        java.io.IOException

      • writeptsJS

        public static void writeptsJS​(oracle.jdbc.OracleBlob ptlob,
                              int numpts,
                              int ndim,
                              oracle.spatial.util.Adapters.Ptclass[] ptarr,
                              oracle.sql.NUMBER includeCustomDim)
                       throws java.sql.SQLException,
                              java.io.IOException
        Parameters:
        ptlob -
        numpts -
        ndim -
        ptarr -
        includeCustomDim -
        Throws:
        java.sql.SQLException
        java.io.IOException

      • validateXMLRecord

        public static java.lang.String validateXMLRecord​(oracle.sql.CLOB xml,
                                                 java.lang.String schema)
                                          throws java.lang.Exception
        This method validateXSDXML is used to validate (schema XSD and its) XML instance. This method does not benefit from oracle.spatial.util.XMLValidator2 caching.
        Parameters:
        xml - The CLOB object for the XML to be validated.
        schema - The URL for the XSD to be validated.
        Returns:
        String The status of the XML validated against its XSD: TRUE/NULL/Error Message
        Throws:
        java.lang.Exception

      • validateXMLRecord

        public static java.lang.String validateXMLRecord​(oracle.jdbc.OracleClob xml,
                                                 java.lang.String schema)
                                          throws java.lang.Exception
        This method validateXSDXML is used to validate (schema XSD and its) XML instance. This method does not benefit from oracle.spatial.util.XMLValidator2 caching.
        Parameters:
        xml - The Clob object for the XML to be validated.
        schema - The URL for the XSD to be validated.
        Returns:
        String The status of the XML validated against its XSD: TRUE/NULL/Error Message
        Throws:
        java.lang.Exception

      • validateXSDXMLLayer

        public static oracle.sql.NUMBER validateXSDXMLLayer​(java.lang.String tableName,
                                                    java.lang.String columnName,
                                                    java.lang.String schema,
                                                    java.lang.String resultTableName,
                                                    oracle.sql.NUMBER commit_interval)
                                             throws java.sql.SQLSyntaxErrorException,
                                                    java.sql.SQLException,
                                                    java.lang.Exception
        This method validateXSDXMLLayer is used to validate (schema XSD and its) all XML instances from a table such as CSW 202 User Table. This is another API. This method benefits from oracle.spatial.util.XMLValidator2 caching. -- Open a resultset to fetch each rowid, XML instance "columnName" from the "tableName" -- For each XML instance in resultset. do: -- call your XMLValidator2.schemaValidate -- insert rowid, validate_result(Nothing(TRUE)/NULL/Error Message) into resultTableName if (commit_count == commit_interval) then "commit" and reset the commit_count counter. -- End of for loop (dont raise any exceptions in this loop) -- Update resultTableName set columnName= %s the row "Rows Processed " + tot_XMLInstances_processed_count into the resultTableName.
        Parameters:
        tableName - owner.table name which has the Clob objects for the XMLs to be validated.
        columnName - Name of the column that has the Clob objects for the XMLs to be validated. (XMLType column)
        schema - The URL for the XSD to be validated. The XSD is fetched from table MDSYS.SDO_XSD_TABLE in oracle.spatial.util.SchemaEntityResolver class.
        resultTableName - Table name where results of XSD/XML validations are stored (Nothing means TRUE/NULL for NULL XML Object/Error Message).
        commit_interval -
        Returns:
        NUMBER The total number of XML Instances processed.
        Throws:
        java.sql.SQLSyntaxErrorException
        java.sql.SQLException
        java.lang.Exception

      • encodePolylineAsClob

        public static java.sql.Clob encodePolylineAsClob​(java.sql.Struct geom,
                                                 oracle.sql.NUMBER noOfDigits)
                                          throws java.sql.SQLException,
                                                 java.lang.Exception
        Throws:
        java.sql.SQLException
        java.lang.Exception

      • decodePolylineAsGeom

        public static java.sql.Struct decodePolylineAsGeom​(java.sql.Clob geomClob,
                                                   oracle.sql.NUMBER srid,
                                                   oracle.sql.NUMBER noOfDigits)
                                            throws java.sql.SQLException,
                                                   java.lang.Exception
        Throws:
        java.sql.SQLException
        java.lang.Exception