Class FactoryUsingAnsiSQL
- All Implemented Interfaces:
AuthorityFactory,CRSAuthorityFactory,CSAuthorityFactory,DatumAuthorityFactory,Factory,CoordinateOperationAuthorityFactory,Factory,RegistrableFactory
An EPSG factory for the database generated by SQL scripts rather than the MS-Access one.
- Since:
- 2.1
- Author:
- Rueben Schulz, Martin Desruisseaux, Didier Richard, John Grange
-
Nested Class Summary
Nested classes/interfaces inherited from class DirectEpsgFactory
DirectEpsgFactory.OperationOrder -
Field Summary
FieldsModifier and TypeFieldDescriptionMaps the MS-Access names to ANSI names.Fields inherited from class DirectEpsgFactory
ORDER_KEYFields inherited from class DirectAuthorityFactory
factoriesFields inherited from class ReferencingFactory
LOGGERFields inherited from class AbstractFactory
hints, MAXIMUM_PRIORITY, MINIMUM_PRIORITY, NORMAL_PRIORITY, priority -
Constructor Summary
ConstructorsConstructorDescriptionFactoryUsingAnsiSQL(Hints userHints, Connection connection) Constructs an authority factory using the specified connection.FactoryUsingAnsiSQL(Hints userHints, DataSource dataSource) Constructs an authority factory using the specified source. -
Method Summary
Methods inherited from class DirectEpsgFactory
createCoordinateOperation, createCoordinateReferenceSystem, createCoordinateSystem, createCoordinateSystemAxis, createDatum, createEllipsoid, createExtent, createFromCoordinateReferenceSystemCodes, createObject, createOperationMethod, createParameterDescriptor, createPrimeMeridian, createUnit, dispose, finalize, getAuthority, getAuthorityCodes, getBackingStoreDescription, getConnection, getDescriptionText, getIdentifiedObjectFinder, getImplementationHints, getValidationQuery, isConnectionValid, isPrimaryKey, setOperationOrder, setValidationQuery, shutdownMethods inherited from class AbstractAuthorityFactory
createCartesianCS, createCompoundCRS, createCylindricalCS, createDerivedCRS, createEllipsoidalCS, createEngineeringCRS, createEngineeringDatum, createGeocentricCRS, createGeodeticDatum, createGeographicCRS, createImageCRS, createImageDatum, createPolarCS, createProjectedCRS, createSphericalCS, createTemporalCRS, createTemporalDatum, createTimeCS, createVerticalCRS, createVerticalCS, createVerticalDatum, noSuchAuthorityCode, trimAuthorityMethods inherited from class ReferencingFactory
ensureNonNull, getVendorMethods inherited from class AbstractFactory
addImplementationHints, equals, getPriority, hashCode, onDeregistration, onRegistration, toStringMethods inherited from interface CRSAuthorityFactory
createCompoundCRS, createDerivedCRS, createEngineeringCRS, createGeocentricCRS, createGeographicCRS, createImageCRS, createProjectedCRS, createTemporalCRS, createVerticalCRSMethods inherited from interface CSAuthorityFactory
createCartesianCS, createCylindricalCS, createEllipsoidalCS, createPolarCS, createSphericalCS, createTimeCS, createVerticalCSMethods inherited from interface DatumAuthorityFactory
createEngineeringDatum, createGeodeticDatum, createImageDatum, createTemporalDatum, createVerticalDatum
-
Field Details
-
map
Maps the MS-Access names to ANSI names. Keys are MS-Access names including bracket. Values are ANSI names. Keys and values are case-sensitive. The default content of this map is:
Subclasses can modify this map in their constructor in order to provide a different mapping.MS-Access name ANSI name [Alias] epsg_alias [Extent] epsg_extent [Coordinate Axis] epsg_coordinateaxis [Coordinate Axis Name] epsg_coordinateaxisname [Coordinate_Operation] epsg_coordoperation [Coordinate_Operation Method] epsg_coordoperationmethod [Coordinate_Operation Parameter] epsg_coordoperationparam [Coordinate_Operation Parameter Usage] epsg_coordoperationparamusage [Coordinate_Operation Parameter Value] epsg_coordoperationparamvalue [Coordinate_Operation Path] epsg_coordoperationpath [Coordinate Reference System] epsg_coordinatereferencesystem [Coordinate System] epsg_coordinatesystem [Datum] epsg_datum [Naming System] epsg_namingsystem [Ellipsoid] epsg_ellipsoid [Prime Meridian] epsg_primemeridian [Supersession] epsg_supersession [Unit of Measure] epsg_unitofmeasure [CA.ORDER] coord_axis_order
-
-
Constructor Details
-
FactoryUsingAnsiSQL
Constructs an authority factory using the specified connection.- Parameters:
userHints- The underlying factories used for objects creation.connection- The connection to the underlying EPSG database.- Since:
- 2.2
-
FactoryUsingAnsiSQL
Constructs an authority factory using the specified source.- Parameters:
userHints- The underlying factories used for objects creation.dataSource- The connection to the underlying EPSG database.- Since:
- 2.5
-
-
Method Details
-
setSchema
Replaces the"epsg_"prefix by the specified schema name. If the removal of the"epsg_"prefix is not wanted, append it to the schema name (e.g."myschema.epsg_"). This method should be invoked at construction time only.- Parameters:
schema- The database schema in which the epsg tables are stored.- Since:
- 2.2
-
adaptSQL
Modifies the given SQL string to be suitable for non MS-Access databases. This replaces table and field names in the SQL with the new names in the SQL DDL scripts provided with EPSG database.- Overrides:
adaptSQLin classFactoryUsingSQL- Parameters:
statement- The statement in MS-Access syntax.- Returns:
- The SQL statement in ANSI syntax.
-