org.geotools.referencing.factory.epsg
Class FactoryUsingOracleSQL

java.lang.Object
  org.geotools.factory.AbstractFactory
      org.geotools.referencing.factory.AbstractFactory
          org.geotools.referencing.factory.AbstractAuthorityFactory
              org.geotools.referencing.factory.epsg.FactoryUsingSQL
                  org.geotools.referencing.factory.epsg.FactoryUsingAnsiSQL
                      org.geotools.referencing.factory.epsg.FactoryUsingOracleSQL

All Implemented Interfaces:

org.opengis.referencing.AuthorityFactory, org.opengis.referencing.operation.CoordinateOperationAuthorityFactory, org.opengis.referencing.crs.CRSAuthorityFactory, org.opengis.referencing.cs.CSAuthorityFactory, org.opengis.referencing.datum.DatumAuthorityFactory, Factory, org.opengis.referencing.Factory, javax.imageio.spi.RegisterableService

public class FactoryUsingOracleSQL

extends FactoryUsingAnsiSQL

An EPSG factory suitable for Oracle SQL syntax.

Since:

2.1

Version:

$Id: FactoryUsingOracleSQL.java 17672 2006-01-19 00:25:55Z desruisseaux $

Author:

John Grange

To Do:

Since this class is constructed through the service provider API rather than directly instantiated by the user, we need some way to pass the schema information to this class. one possible approach is to set the schema in preferences. Maybe a better was is to look for a place in the Oracle DataSource for that.

Field Summary

Fields inherited from class org.geotools.referencing.factory.epsg.FactoryUsingAnsiSQL

map

Fields inherited from class org.geotools.referencing.factory.epsg.FactoryUsingSQL

connection

Fields inherited from class org.geotools.referencing.factory.AbstractAuthorityFactory

factories

Fields inherited from class org.geotools.referencing.factory.AbstractFactory

LOGGER

Fields inherited from class org.geotools.factory.AbstractFactory

hints, MAXIMUM_PRIORITY, MINIMUM_PRIORITY, NORMAL_PRIORITY, priority

Constructor Summary

FactoryUsingOracleSQL(FactoryGroup factories, java.sql.Connection connection)
Deprecated. Use FactoryUsingOracleSQL(Hints,Connection) instead.

FactoryUsingOracleSQL(FactoryGroup factories, java.sql.Connection connection, java.lang.String epsgSchema)
Deprecated. Use FactoryUsingOracleSQL(Hints,Connection,String) instead.

FactoryUsingOracleSQL(Hints hints, java.sql.Connection connection)
Constructs an authority factory using the specified connection.

FactoryUsingOracleSQL(Hints hints, java.sql.Connection connection, java.lang.String epsgSchema)
Constructs an authority factory using the specified connection to an EPSG database and a database schema.

Method Summary

protected java.lang.String

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

Methods inherited from class org.geotools.referencing.factory.epsg.FactoryUsingAnsiSQL

setSchema

Methods inherited from class org.geotools.referencing.factory.epsg.FactoryUsingSQL

createCoordinateOperation, createCoordinateReferenceSystem, createCoordinateSystem, createCoordinateSystemAxis, createDatum, createEllipsoid, createExtent, createFromCoordinateReferenceSystemCodes, createObject, createOperationMethod, createParameterDescriptor, createPrimeMeridian, createUnit, dispose, finalize, getAuthority, getAuthorityCodes, getBackingStoreDescription, getDescriptionText, isPrimaryKey, shutdown

Methods inherited from class org.geotools.referencing.factory.AbstractAuthorityFactory

createCartesianCS, createCompoundCRS, createCylindricalCS, createDerivedCRS, createEllipsoidalCS, createEngineeringCRS, createEngineeringDatum, createGeocentricCRS, createGeodeticDatum, createGeographicCRS, createImageCRS, createImageDatum, createPolarCS, createProjectedCRS, createSphericalCS, createTemporalCRS, createTemporalDatum, createTimeCS, createVerticalCRS, createVerticalCS, createVerticalDatum, getImplementationHints, noSuchAuthorityCode, onRegistration, trimAuthority

Methods inherited from class org.geotools.referencing.factory.AbstractFactory

ensureNonNull, getVendor

Methods inherited from class org.geotools.factory.AbstractFactory

onDeregistration

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.opengis.referencing.Factory

getVendor

Constructor Detail

FactoryUsingOracleSQL

public FactoryUsingOracleSQL(FactoryGroup factories,
                             java.sql.Connection connection)

Deprecated. Use FactoryUsingOracleSQL(Hints,Connection) instead.

Constructs an authority factory using the specified connection.

Parameters:

factories - The underlying factories used for objects creation.

connection - The connection to the underlying EPSG database.

FactoryUsingOracleSQL

public FactoryUsingOracleSQL(Hints hints,
                             java.sql.Connection connection)

Constructs an authority factory using the specified connection.

Parameters:

hints - The underlying factories used for objects creation.

connection - The connection to the underlying EPSG database.

Since:

2.2

FactoryUsingOracleSQL

public FactoryUsingOracleSQL(FactoryGroup factories,
                             java.sql.Connection connection,
                             java.lang.String epsgSchema)

Deprecated. Use FactoryUsingOracleSQL(Hints,Connection,String) instead.

Constructs an authority factory using the specified connection 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:

factories - The underlying factories used for objects creation.

connection - The connection to the underlying EPSG database.

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

FactoryUsingOracleSQL

public FactoryUsingOracleSQL(Hints hints,
                             java.sql.Connection connection,
                             java.lang.String epsgSchema)

Constructs an authority factory using the specified connection 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:

hints - The underlying factories used for objects creation.

connection - The connection to the underlying EPSG database.

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

Since:

2.2

Method Detail

adaptSQL

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

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

Overrides:

adaptSQL in class FactoryUsingAnsiSQL

Parameters:

statement - The statement in MS-Access syntax.

Returns:

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