[udig-devel] Oracle plugin - what is the situation?

[Vitali Diatchkov]

Hello! Some questions for persons being familiar with Oracle stuff of
Geotools.

I am interested to investigate and possibly improve some functionality of
Oracle plugin.. 
We need a direct connection to Oracle database in future project through
GeoTools' DataStore API with capabilities:

1) Create a direct layer in UDIG from database for rendering without any
intermediate formats or workarounds (Oracle -> GeoServer -> WFS) - a kind of
"live" layer. There can be various architecture  strategies of such layer:
a) Load everything from table and cache in memory (seems UDIG Oracle plugin
does in a such way now if I am correct)
b)Load only features in current viewport.
c) some kind of mix of different strategies with caching mechanism and so on


2) Editing operations for features from this layer (in context of
transaction) and  updating database by committing.

3) Creating new features in layer (in context of transaction) and inserting
to database by committing.

The UDIG can be seen as an editor for spatial data of Oracle database with
basic editing functionality and advanced non-standardized solutions such as
locking Area of Interest particular user for exclusive editing in multi-user
environment, etc.

Is anybody there who is interested in improvements of Oracle connection? Any
suggestions or advises?

Vitali Diatchkov.