GeoTools : Geometryless JDBC Data Store



Module Maintainer:




Email Help:


IP Review:




This datastore provides a way to create features from simple JDBC sources (i.e. non-spatial data types). Typically, this is Latitude/Longitude point data, which is very common in business data, and also features with no geometry (often required to add value to  spatial objects in online applications.

Geometryless has been successfully tested against:

  • Oracle
  • Postgres
  • MySQL
  • MS SQL 

Recent Development

For the 2.4 branch geometryless has been revamped to use the new org.opengis.Feature API

There are also tips and tricks that should be noted:

  • in early versions the X,Y columns need to be the last in the result set
  • Must download appropriate JDBC drivers and set up testing fixtues

If you are a volunteer we could use help improving the following:

  • Split into read-only and transactional extension modules (needs doing for all data stores IMHO)

IP Review

IP review is underway - known issue:

Outstanding Issues

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

com.atlassian.confluence.macro.MacroExecutionException: JIRA project does not exist or you do not have permission to view it.

Remember that the module maintainer is a volunteer, and if you can help test this module 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 the geoserver or udig bug trackers.

Module Status

Undergoing testing and migration to supported for 2.4 branch. Was working for 2.1, but has not been included in builds for 2.2 and 2.3