Added by jgarnett, last edited by jgarnett on Nov 02, 2006  (view change)

Labels

 
(None)
Module Maintainer: Marc Risney
Status:
Email Help: Geotools-gt2-users@lists.sourceforge.net
Volunteer: geotools-devel@lists.sourceforge.net
Plug-in: DataStoreFactorySPI

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.

IP Review

Outstanding Issues

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

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

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

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