[Geoserver-devel] [jira] Created: (GEOS-2936) Allow specifying ID generation type for featuretype

Allow specifying ID generation type for featuretype
---------------------------------------------------

                 Key: GEOS-2936
                 URL: http://jira.codehaus.org/browse/GEOS-2936
             Project: GeoServer
          Issue Type: Improvement
          Components: Configuration, Global, Oracle, PostGIS
         Environment: Oracle connector will benefit most
            Reporter: Simon Peter Haverdings
            Assignee: Andrea Aime
            Priority: Minor

Allow the user to choose how the ID for inserting new featuretypes will be generated.
Currently (at least for the oracle connector) is only uses a query like 'select max(id) from table'.
This will cause concurrency problems when having multiple instances working on a single database (table).

It would be great if (for oracle) you could specifiy it should use a specific (Oracle) Sequence. This way the concurrency problem is avoided and multiple systems can run on the same database. Any client calling this sequence will get a unique value!

Also other ID types can be used for creating the id.
For example: UUID, GUID, NULL (database autoincrement)

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira