Re: [udig-devel] Multithreading in uDig 1.2

[Andrea Aime <aaime@xxxxxxxxxxx>]

On 24/09/2010 01:22, Jody Garnett wrote:
> I have not seen any documentation myself; there should be a wiki page
> here: -  http://docs.codehaus.org/display/GEOTOOLS/Module+Matrix
>
> Or here: -http://docs.codehaus.org/display/GEOTDOC/Oracle
>
> Nether reference a requirement for sequence that I can see; it is
> however a wiki so documentation is everyones responsibility; feel
> free to login and a couple sentences - it would be a great help.
>
> Justin are we missing something? I did not know about the
> tablename_fieldname_s convention?

Oracle, unlike postgis, does not offer any way to determine
if a primary key is backed to a sequence.

The naming convention is one way to enforce that association,
another way is to use a metadata table. I don't have docs
ready but if you look into the code you'll see one can create
a a special table, geotools specific, and valid for all
database types, where one can fill to state this kinds
of mappings, stating which columns form the pk (can be
used to give stable fids to views for example) and provide
the associated sequence. The API is also pluggable so
one can write his own policy to perform this primary key/sequence
mapping.

Have a look at PrimaryKeyFinder and its subclasses.

Cheers
Andrea