Recent Development

For the 2.2.x branch the Oracle module has:

• Fixed several issues with the SDO utility class
• Started using the SDO Utility class for FeatureSource opperations, this work will be completed for the 2.2.x release

There are also several warnings that must be made:

• you need to download a driver from oracle directly, we have not obtained rights to distribute their jdbc driver
• the createSchema method does not yet work
• the SRID mapping to CRS works for our test server, but I have no idea what you need to do to set it up for yourself
• the use of the oracle metadata to optimize opperations such as getBounds has only just begun

In short if you are a volunteer, we would love your help.

Outstanding Issues

The module maintainer will take care of assigning these issues to developers:

Errors were reported by the JIRA trusted connection.

• Unrecognized application: confluence:8447594

jira.codehaus.org (27 issues)
T	Key	Summary	Assignee	Reporter	Pr	Status	Res	Created	Updated	Due
	GEOT-1828	throws exception while updating multiple geometry column feature. Bug in OracleFeatureWriter.doUpdate() method	Andrea Aime	Profii		Open	UNRESOLVED	May 21, 2008	May 21, 2008
	GEOT-938	Select "null" while reading feature collection from oracle	Andrea Aime	Alessio Soldano		Open	UNRESOLVED	Aug 30, 2006	Jul 06, 2007
	GEOT-704	TableScan prevention - Use the Metadata	Andrea Aime	Jody Garnett		Open	UNRESOLVED	Oct 03, 2005	Aug 01, 2007
	GEOT-744	OracleDataStore isNillable and others, not set	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 27, 2005	Jul 06, 2007
	GEOT-719	OracleDataStore.getTypeNames() returns non accessible tables	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 11, 2005	Jul 06, 2007
	GEOT-1044	Oracle sql encoder assumes 0 as lack of SRID, but it may not be so	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Nov 27, 2006	Jul 06, 2007
	GEOT-711	Implement createSchema()	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 05, 2005	Jul 06, 2007
	GEOT-553	Shapefile not saved properly in Oracle 9i/10g	Andrea Aime	sandy		Open	UNRESOLVED	Jun 01, 2005	Jul 06, 2007
	GEOT-802	"No CRS for srid.."	Andrea Aime	Vitaliy		Open	UNRESOLVED	Jan 30, 2006	Jul 06, 2007
	GEOT-826	GeomtryFilter strange behavior after reprojecting	Andrea Aime	Justin Smith		Open	UNRESOLVED	Mar 23, 2006	Jul 06, 2007
	GEOT-709	Support or at least report for old geometry fields (ake old GTYPE)	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 05, 2005	Jul 06, 2007
	GEOT-729	OracleDataStore doesn't work for floats with Oracle before 10.x	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 14, 2005	Jul 06, 2007
	GEOT-724	org.geotools.data.oracle.sdo.SDO crash for EMPTY Geometries	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 13, 2005	Jul 06, 2007
	GEOT-463	Update and delete does not work correctly with database oracle 10g	Andrea Aime	LeTrung		Open	UNRESOLVED	Mar 09, 2005	Jul 06, 2007
	GEOT-725	OracleDataStore doesn't support temporal attributes	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 13, 2005	Jul 06, 2007
	GEOT-393	Geometry Converter Interface	Andrea Aime	Chris Holmes		Open	UNRESOLVED	Feb 01, 2005	Jul 06, 2007
	GEOT-1353	Querying Date-Value on Oracledatastore fails	Andrea Aime	Tim Englich		Open	UNRESOLVED	Jun 21, 2007	Jul 06, 2007
	GEOT-931	Oracle feature writer may not handle null geometries properly	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Aug 21, 2006	Oct 30, 2007
	GEOT-1507	Check for availability of EXTENT_OF and fall back transparently on SDO_AGGR_MBR	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Oct 11, 2007	Oct 11, 2007
	GEOT-1756	Very slow insertion times on jdbc datastores	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Apr 01, 2008	Apr 01, 2008
	GEOT-1739	Oracle datastore encoders PropertyIsLike into a case insensitive search	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Mar 18, 2008	May 23, 2008
	GEOT-1689	if DESC tablename -> SDO_GEOMETRY() then geofield is detected (in geoserver 1.6.0 rc3)	Andrea Aime	Eduard Witteveen		Open	UNRESOLVED	Jan 24, 2008	May 23, 2008
	GEOT-717	Filter expression with numeric literals	Andrea Aime	Jürgen Link		Open	UNRESOLVED	Oct 09, 2005	May 23, 2008
	GEOT-1940	Oracle datastore is not able to properly return data when the bbox filter exceeds the world bounds	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Jul 31, 2008	Jul 31, 2008
	GEOT-1986	Add loose bbox capabilities to Oracle datastore	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Aug 28, 2008	Aug 28, 2008
	GEOT-720	OracleDataStore doesn't always correctly handle mixed-case table and field names	Andrea Aime	Paolo Rizzi		Open	UNRESOLVED	Oct 11, 2005	Jul 06, 2007
	GEOT-714	Need to support MultiString, MulitPoint, MultiPolygon in SQLEncoderOracle	Andrea Aime	Marc Risney		Reopened	UNRESOLVED	Oct 06, 2005	Oct 30, 2007

Remember that the module maintainer is a volunteer, and if you do have access to oracle please jump on the developers list and help out. Patches may be attached to the above issues for review by the module maintainer.

Although not the responsibility of the geotools module maintainer additional or related issues may be found in the following list:

Errors were reported by the JIRA trusted connection.

• Unrecognized application: confluence:8447594

jira.codehaus.org (4 issues)
T	Key	Summary	Assignee	Reporter	Pr	Status	Res	Created	Updated	Due
	UDIG-1224	oracle spatial rendering problem	Jody Garnett	Andreas Schild		Open	UNRESOLVED	Mar 15, 2007	Mar 15, 2007
	UDIG-844	Oracle spatial resources inactive	Unassigned	Jeffrey C Bernard		Open	UNRESOLVED	Jun 14, 2006	Sep 22, 2006
	UDIG-1103	Confirm IService handles CONNECTED / NOTCONNECTED status	Unassigned	Jody Garnett		Open	UNRESOLVED	Nov 22, 2006	Aug 27, 2008
	UDIG-615	When selecting schema with different username than login username the table is not found	Unassigned	jukka sirviö		Open	UNRESOLVED	Sep 15, 2005	Aug 27, 2008

Errors were reported by the JIRA trusted connection.

• Unrecognized application: confluence:8447594

jira.codehaus.org (16 issues)
T	Key	Summary	Assignee	Reporter	Pr	Status	Res	Created	Updated	Due
	GEOS-1715	oracle 9i not working: DESC tablename returns SDO_GEOMETRY() which is unknown	Andrea Aime	Eduard Witteveen		Open	UNRESOLVED	Jan 29, 2008	Feb 05, 2008
	GEOS-1302	USER_SDO_GEOM_METADATA not being read when login is not data owner	Andrea Aime	Jeff Hobbs		Open	UNRESOLVED	Aug 24, 2007	Aug 25, 2007
	GEOS-1347	Unable to create feature type for empty oracle table	Andrea Aime	Tom Dean		Open	UNRESOLVED	Sep 19, 2007	Oct 15, 2007
	GEOS-1349	describe feature type returns an exception for oracle table with only 1 feature	Andrea Aime	Tom Dean		Open	UNRESOLVED	Sep 19, 2007	Oct 10, 2007
	GEOS-1742	Bug in Date format for WFS over Oracle 10g datastore	Andrea Aime	Patrick O'brian		Open	UNRESOLVED	Feb 12, 2008	Feb 12, 2008
	GEOS-1889	WFS-T / Oracle: can't insert a feature with attribute data only	Andrea Aime	Charles Bates		Open	UNRESOLVED	Apr 29, 2008	Apr 29, 2008
	GEOS-1881	WFS_getFeature ServiceException	Andrea Aime	Rudi Hochmeister		Open	UNRESOLVED	Apr 22, 2008	Apr 29, 2008
	GEOS-1879	Oracle datastore documentation is out of date	Mike Pumphrey	Andrea Aime		Open	UNRESOLVED	Apr 22, 2008	May 20, 2008
	GEOS-1762	Turn "fast bbox" into a datastore hint	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Feb 22, 2008	Jun 12, 2008
	GEOS-402	Oracle duplicate attributeType prevents featureTypes being created	Andrea Aime	Chris Holmes		Open	UNRESOLVED	Sep 14, 2005	Jan 15, 2008
	GEOS-2006	Data stored in Oracle with a projection already assigned can not be shown properly	Andrea Aime	Sylvain Caillot		Open	UNRESOLVED	Jun 25, 2008	Aug 12, 2008
	GEOS-2070	Oracle data won't show up properly when bbox exceeeds world bounds	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Jul 31, 2008	Aug 12, 2008
	GEOS-2027	Inability to run cite tests against Oracle	Andrea Aime	Andrea Aime		Open	UNRESOLVED	Jul 06, 2008	Aug 25, 2008
	GEOS-1896	WMS GetFeatureInfo operation using Oracle Data Store with large number of items in table fails	Andrea Aime	Bruce E. Thelen		Open	UNRESOLVED	Apr 30, 2008	Aug 28, 2008
	GEOS-1123	Oracle / MapInfo Polylines rendered as polygon - vendor extension to prevent this behaviour required	Andrea Aime	Tom Dean		Open	UNRESOLVED	Jun 04, 2007	Jun 04, 2007
	GEOS-584	Duplicate attribute types error when adding oracle spatial layer if multiple layers are selectable with the same name	Andrea Aime	Matt White		Open	UNRESOLVED	Mar 06, 2006	Jun 20, 2007

Module Status

The Oracle Module is undergoing some review. As many are aware the JDBC DataStore is suffering under its own popularity, and is feeling the strain of subclassing. As an example there are three seperate ways of optimizing interaction if you are a subclass of JDBCDataStore, and no documentation or guide on how this is done.

This module is however important, and several developers are being paid to improve it.

Marc also wishes to make more use of the sdoapi.jar, as opposed to the utility SDO class, so that we do not have to maintain our own mappings. We initially moved away from this jar due to oracle threatening to stop supporting the jar. We also had severe accurace issues taking an Oracle SDO Geomery and converting it to WKT to an JTS Geometry. Personally I am looking forward to the new FM where we should be able to let people work against the Geometry model of their choice.

None of these improvements will effect the API, although we may make a topology mapping available to the graph module.