liquibase.ext.spatial.sqlgenerator

Class OracleSpatialUtils

java.lang.Object

liquibase.ext.spatial.sqlgenerator.OracleSpatialUtils

public class OracleSpatialUtils
extends Object

OracleSpatialUtils provides utility methods for Oracle Spatial.

Field Summary

Fields

Modifier and Type	Field and Description
static String	EPSG_TO_ORACLE_FUNCTION The Oracle function that converts an EPSG SRID to the corresponding Oracle SRID.

Method Summary

Methods

Modifier and Type	Method and Description
static String	getOracleSrid(String srid, Database database) Converts the given EPSG SRID to the corresponding Oracle SRID.
static String	getOracleWkt(String wkt) Converts the given Well-Known Text string to one that will work in Oracle.
static String	loadOracleSrid(String srid, Database database) Queries to the database to convert the given EPSG SRID to the corresponding Oracle SRID.

Methods inherited from class java.lang.Object

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

Field Detail

EPSG_TO_ORACLE_FUNCTION

public static final String EPSG_TO_ORACLE_FUNCTION

The Oracle function that converts an EPSG SRID to the corresponding Oracle SRID.

See Also:

Constant Field Values

Method Detail

getOracleWkt

public static String getOracleWkt(String wkt)

Converts the given Well-Known Text string to one that will work in Oracle. If the string is greater than 4000 characters, the string is broken into pieces where each piece is converted to a CLOB. The CLOB handling assumes that the result will be wrapped in single quotes so it wraps the result in "' || TO_CLOB(...) || '".

Parameters:

wkt - the Well-Known Text string to convert.

Returns:

the original WKT or a TO_CLOB concatenation of the WKT.

getOracleSrid

public static String getOracleSrid(String srid,
                   Database database)

Converts the given EPSG SRID to the corresponding Oracle SRID.

Parameters:

srid - the EPSG SRID.

database - the database instance.

Returns:

the corresponding Oracle SRID.

loadOracleSrid

public static String loadOracleSrid(String srid,
                    Database database)

Queries to the database to convert the given EPSG SRID to the corresponding Oracle SRID.

Parameters:

srid - the EPSG SRID.

database - the database instance.

Returns:

the corresponding Oracle SRID.