[Geoserver-users] Oracle Versioning Datastore?

GeoServer GeoServer User
1

Hi,

I would like to use Oracle as a versioning datastore with Geoserver
1.6. Is it possible to use the Oracle Spatial Datastore for that? If
not, can someone please point me into the right direction on what
would have to be done to achieve this?

Thank you!
Andreas.

2

Andreas Hocevar ha scritto:

Hi,

I would like to use Oracle as a versioning datastore with Geoserver
1.6. Is it possible to use the Oracle Spatial Datastore for that? If
not, can someone please point me into the right direction on what
would have to be done to achieve this?

No, it's not, the versiong prototype has been targeted at postgis
only. What needs to be done really depends on what you want to achieve.
Do you want to use Oracle enterprise manager to handle the versioning?
If so, you have to write your own datastore that implements the versioning datastore interface (extending the Oracle datastore I guess).
This one I guess is sizeable and hard (I may be mistaken, I haven't
really thought about how to implement it).

If you just want it to behave like the postgis one, that is, direct
table alteration, with no possibility for other software to use
the tables write wise after the version enabling, then it's a matter
of porting the existing datastore to oracle, and it should be easier,
since it's built as a wrapper around the postgis datastore and it
does not have many assumptions about the underlying datastore (so you
should be able to reuse most of the existing code).

If you are interested in doing it yourself I can try to help you
figure out the code, otherwise you could try to contract TOPP to
do it for you.

Hope this helps
Cheers
Andrea

3

Hi Andreas,

thanks for your quick reply.

On Nov 29, 2007 12:37 PM, Andrea Aime <aaime@anonymised.com> wrote:

If you just want it to behave like the postgis one, that is, direct
table alteration, with no possibility for other software to use
the tables write wise after the version enabling, then it's a matter
of porting the existing datastore to oracle, and it should be easier,

I would like to take this route.

If you are interested in doing it yourself I can try to help you
figure out the code

I'll have a look at the postgis versioning code. I have to check with
my company, if we have the possibility to use PostGIS instead. If
Oracle is an unchangable requirement, they will have to decide if we
do this in-house or have TOPP develop it.

Thanks!
Andreas.