Module Maintainer:

Jody Garnett

Status:

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

Email Help:

jgarnett@refractions.net

Plug-in:

CRSAuthority

User Docs:

EPSG Oracle Plugin

Research

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

Development

Actually Using Oracle

To develop this module you will need to follow the optional section in the developers guide for Oracle. This will place an oracle jdbc driver into your local maven repository where it can then be used during the online tests.

C:> cd C:\oracle\product\10.2.0\jdbc\lib
C:\oracle\product\10.2.0\jdbc\lib>mvn install:install-file -Dfile=ojdbc14.jar 
       -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=10.2.0 -Dpackaging=jar

The choice of maven profile (to use oracle or to not use oracle) is controlled with a oracle property.

mvn clean install -Doracle=true 

Or to set up for testing in eclipse:

mvn eclipse:eclipse -Doracle=true

Using Online Tests

The other thing you will need to do for online tests is place a oracle.properties file describing your database in the magic location below.

user=jody
password=***
url=jdbc:oracle:thin:@bilbi:1521:orcl

You can then run the online tests:

mvn -Doracle.jdbc=true test -P online

Ideas

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 ...

org.geotools.referencing.factory:

org.geotools.referencing.factory.epsg:

The following bug reports are important:

Outstanding Issues

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