Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Module Maintainer:

Jody Garnett


Construction of a epsg-oracle CRSAuthority that will work in a Java EE environment

Email Help:




The epsg-oracle plugin is an experiment focused on cleaning up the JDBC Authority abstract classes to ensure the DataSource can be provided.

IP Review


Some ideas on the use of DataSource in GeoTools (and how we can set up a testing environment are recorded here): J2EE and Connection Pools

In addition the following problems have been noted ...


  • AbstractAuthorityFactory - some features are just package-visible (org.geotools.referencing.factory)
  • BufferedAuthorityFactory had problem with put( Object, Object ) not caching


  • AuthorityCodes is only package visisble
  • BursaWolfInfo is only package visible
  • DataSource - (warning) this is WRONG we cannot extend DataSource on our own (we need to use one provided by others)
  • DefaultFactory requirements
    • Some kind of DATASOURCE_NAME to work in JBoss (should be configurable)
    • Require DEFAULT_BUFFER_MAX and DEFAULT_PRIORITY_DEC as constructor parameters, either as DefaultFactory(Hints, int, int) to expose the parent constructor, or as new Hints of their own
    • createFactory() needs to wrap the DataSource obtained from JNDI into a class that implements the local DataSource interface.
    • createFactory() cannot bind the DataSource into JNDI (will not always have permission)
    • createBackingStore() needs to close the JDBC connection obtained from the DataSource (thereby returning it to the pool)
    • FactoryUsingAnsiSQL - should not cache the connection (the DataSource will do that)
    • FactoryUsingOracleSQL - addition to 'AS', the Oracle reserved word 'FILE' is replaced in the query Strings. This necessary because one query uses 'FILE' to rename a column in a SELECT for a column. This factory is used by the <code>AbstractDataSource</code>
    • FactoryUsingSQL - also caches the COnnection instead of DataSource
    • TableInfo - not public

The following bug reports are important:

  • - EPSG DefaultFactory does not work in an EJB environment
    • Need to supply a DATASOURCE_NAME hint - should be of the form "java:EPSG" to keep JBoss happy
    • FactoryUsingSQL should not remove connection from a pool like FactoryUsingSQL does (need to connect and close on each use). Needed for a multi user environment like Java EE.
    • Need to either use a single factory (may become a bottleneck) or use a pool of factories (will need to fix the FactoryUsingSQL connection cache first)
  • - FactoryUsingSQL uses Oracle reserved word in query
    • fixed?
  • - Caching in BufferedAuthorityFactory does not work
    • fixed?

Outstanding Issues

This is a research module, and is not currently tracked using Jira. This is however associated with referencing:

T Key Summary Assignee Reporter P Status Resolution Created Updated Due
Bug GEOT-4319 NADCONTransform does not work with ClasspathGridShiftLocator Andrea Aime Lucas Madar Critical Open Unresolved Nov 15, 2012 Nov 15, 2012
Sub-task GEOT-3123 Add Find functionality to AbstractEpsgMediator Unassigned Jody Garnett Major Open Unresolved May 31, 2010 Jun 01, 2012
Bug GEOT-2902 Get back support for plate carré and similar projections Andrea Aime Andrea Aime Major Open Unresolved Dec 21, 2009 Jun 01, 2012
Improvement GEOT-2939 Add support for the Gall stereographics projection Andrea Aime Andrea Aime Major Open Unresolved Jan 31, 2010 Jun 01, 2012
Improvement GEOT-2933 Add support for the geostationary satellite projection Andrea Aime Andrea Aime Major Open Unresolved Jan 27, 2010 Jun 01, 2012
Bug GEOT-2934 CRS envelope transform may fail with an assertion if the target and source crs have an identity transform but different datum name Andrea Aime Andrea Aime Major Open Unresolved Jan 27, 2010 Jun 01, 2012
Improvement GEOT-3443 Need support for transformation from 2D to 3D CRS Unassigned Farrukh Najmi Major Open Unresolved Feb 20, 2011 Feb 22, 2011
Improvement GEOT-3467 MathTransform JTS Jody Garnett Jody Garnett Major Open Unresolved Mar 12, 2011 Mar 13, 2011
Improvement GEOT-2084 Consider making GeographicBoundingBoxImpl extend BoundingBox as well Simone Giannecchini Simone Giannecchini Major Open Unresolved Oct 18, 2008 Jul 13, 2010
Bug GEOT-2363 Postgres EPSG factory won't work against Postgres 8.3 Unassigned Andrea Aime Major Open Unresolved Mar 01, 2009 May 21, 2010
Bug GEOT-2144 ScriptTest failure on Linux w/ Java 6 Unassigned Jody Garnett Major Open Unresolved Nov 09, 2008 Jun 01, 2012
New Feature GEOT-2310 Add support for the azymuthal equidistant projection Unassigned Andrea Aime Major Open Unresolved Jan 27, 2009 Jun 01, 2012
Bug GEOT-2565 CRS.envelope fails if the area of validity spans the antimeridian Andrea Aime Andrea Aime Major Open Unresolved Jun 22, 2009 Oct 13, 2009
Bug GEOT-1862 Build Failure of JDK1.6.0_06 with no JAI or ImageIO Simone Giannecchini Jody Garnett Major Open Unresolved Jun 23, 2008 May 16, 2010
Bug GEOT-1553 CRS equals comparion used by WorldImageReader isn't working Simone Giannecchini Judd Taylor Major Open Unresolved Oct 29, 2007 Jun 01, 2012
Bug GEOT-1578 Flipped axis CRS do miss some information compared to the original ones Unassigned Andrea Aime Major Open Unresolved Nov 11, 2007 May 21, 2010
Bug GEOT-1704 FORCE_AXIS_ORDER_HONORING does not work if longitude first is provided as an hint instead as a system variable Unassigned Andrea Aime Major Open Unresolved Feb 11, 2008 May 21, 2010
Improvement GEOT-1745 MapProjection: relax coordinate checks/make them configurable Unassigned Andrea Aime Major Reopened Unresolved Mar 20, 2008 May 21, 2010
Bug GEOT-1783 OperationNotFoundException when sourceCRS is a ProjectedCRS + VerticalCRS Unassigned Martin Desruisseaux Major Open Unresolved Apr 24, 2008 Jun 01, 2012
Bug GEOT-1660 An unsupported prj file Unassigned Jody Garnett Major Reopened Unresolved Jan 09, 2008 Jun 01, 2012
Showing 20 out of 84 issues Refresh

  • No labels