org.geotools.cs
Class CoordinateSystemOracleEPSGFactory

java.lang.Object
  org.geotools.cs.CoordinateSystemAuthorityFactory
      org.geotools.cs.CoordinateSystemEPSGFactory
          org.geotools.cs.CoordinateSystemModifiedEPSGFactory
              org.geotools.cs.CoordinateSystemOracleEPSGFactory

Deprecated. Replaced by FactoryUsingOracleSQL.

public class CoordinateSystemOracleEPSGFactory

extends CoordinateSystemModifiedEPSGFactory

An EPSG factory suitable for Oracle SQL syntax.

Version:

$Id: CoordinateSystemOracleEPSGFactory.java 13813 2005-05-26 01:01:13Z desruisseaux $

Author:

John Grange

Field Summary

Fields inherited from class org.geotools.cs.CoordinateSystemModifiedEPSGFactory

map

Fields inherited from class org.geotools.cs.CoordinateSystemEPSGFactory

connection

Fields inherited from class org.geotools.cs.CoordinateSystemAuthorityFactory

factory

Constructor Summary

CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory, java.sql.Connection connection)
Deprecated. Construct an authority factory using the specified connection.

CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory, java.sql.Connection connection, java.lang.String epsgSchema)
Deprecated. Construct an authority factory using the specified connection and a database schema.

CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory, java.lang.String url, java.lang.String driver)
Deprecated. Construct an authority factory using the specified URL to an EPSG database.

CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory, java.lang.String url, java.lang.String driver, java.lang.String epsgSchema)
Deprecated. Construct an authority factory using the specified URL to an EPSG database and a database schema.

Method Summary

protected java.lang.String

adaptSQL(java.lang.String statement) Deprecated. Modifies the given SQL string to be suitable for an Oracle databases.

Methods inherited from class org.geotools.cs.CoordinateSystemEPSGFactory

createCompoundCoordinateSystem, createCoordinateSystem, createDatum, createEllipsoid, createGeographicCoordinateSystem, createObject, createPrimeMeridian, createProjectedCoordinateSystem, createUnit, createVerticalCoordinateSystem, dispose, getAuthority, getDefault, main, replaceAxisUnit

Methods inherited from class org.geotools.cs.CoordinateSystemAuthorityFactory

createHorizontalCoordinateSystem, createHorizontalDatum, createVerticalDatum

Methods inherited from class java.lang.Object

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

Constructor Detail

CoordinateSystemOracleEPSGFactory

public CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory,
                                         java.sql.Connection connection)

Deprecated.

Construct an authority factory using the specified connection.

Parameters:

factory - The underlying factory used for objects creation.

connection - The connection to the underlying EPSG database.

CoordinateSystemOracleEPSGFactory

public CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory,
                                         java.sql.Connection connection,
                                         java.lang.String epsgSchema)

Deprecated.

Construct an authority factory using the specified connection and a database schema. If the database schema is not supplied, or it is null or an empty string, then the tables are assumed to be in the same schema as the user which is being used to connect to the database. You MUST ensure that the connecting user has permissions to select from all the tables in the epsg user schema.

Parameters:

factory - The underlying factory used for objects creation.

connection - The connection to the underlying EPSG database.

epsgSchema - The database schema in which the epsg tables are stored (optional).

CoordinateSystemOracleEPSGFactory

public CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory,
                                         java.lang.String url,
                                         java.lang.String driver)
                                  throws java.sql.SQLException

Deprecated.

Construct an authority factory using the specified URL to an EPSG database.

Parameters:

factory - The underlying factory used for objects creation.

url - The url to the EPSG database.

driver - An optional driver to load, or null if none. This is a convenience argument for the following pseudo-code:

Class.forName(driver).newInstance();

A message is logged to "org.geotools.cts" stating if the loading succeeded of failed. This argument needs to be non-null only once for a specific driver.

Throws:

java.sql.SQLException - if the constructor failed to connect to the EPSG database.

CoordinateSystemOracleEPSGFactory

public CoordinateSystemOracleEPSGFactory(CoordinateSystemFactory factory,
                                         java.lang.String url,
                                         java.lang.String driver,
                                         java.lang.String epsgSchema)
                                  throws java.sql.SQLException

Deprecated.

Construct an authority factory using the specified URL to an EPSG database and a database schema. If the database schema is not supplied, or it is null or an empty string, then the tables are assumed to be in the same schema as the user which is being used to connect to the database. You MUST ensure that the connecting user has permissions to select from all the tables in the epsg user schema.

Parameters:

factory - The underlying factory used for objects creation.

url - The url to the EPSG database.

driver - An optional driver to load, or null if none. This is a convenience argument for the following pseudo-code:

Class.forName(driver).newInstance();

A message is logged to "org.geotools.cts" stating if the loading succeeded of failed. This argument needs to be non-null only once for a specific driver.

epsgSchema - The database schema in which the epsg tables are stored (optional).

Throws:

java.sql.SQLException - if the constructor failed to connect to the EPSG database.

Method Detail

adaptSQL

protected java.lang.String adaptSQL(java.lang.String statement)

Deprecated.

Modifies the given SQL string to be suitable for an Oracle databases. This removes " as " elements from the SQL statements as these don't work in oracle.

Overrides:

adaptSQL in class CoordinateSystemModifiedEPSGFactory

Parameters:

statement - The statement in MS-Access syntax.

Returns:

The SQL statement to use, suitable for an Oracle database.