[ome-users] Re: OME with oracle

[Ilya Goldberg]

Our DB access is done using a delegate that supports some of the 
non-standard-sql stuff we need to do which most DBs have extensions 
for.  Postgres and Oracle are very similar in their extensions.

The Delegate class is OME/Database/Delegate.pm.  This is the abstract 
interface for the delegate and includes documentation in POD format 
(perldoc OME::Database::Delegate).  The abstract interface is 
implemented for Postgres in OME/Database/PostgresDelegate.pm.  An 
Oracle delegate would live in the same place as PostgresDelegate 
(OME/Database/OracleDelegate.pm), and inherit from 
OME::Database::Delegate in the same way.  Probably the most 
straight-forward way is to copy the PostgresDelegate, and edit it to 
work with Oracle.  The class name of the delegate that gets used 
(currently OME::Database::PostgresDelegate) is specified in the 
installation environment (/etc/ome-install.store).  You can change it 
using the 'ome admin configure' utility.

Hope that helps.  An Oracle delegate would be fabulous!  Let me know 
how else I can help (though I have no familiarity with the Oracle 
driver for Perl's DBI).
-Ilya


On Sep 27, 2005, at 12:19 PM, Valentin Dimitrov wrote:

> Dear Ilya,
>
> I am currently considering the possibility of DB-moving from Postgres
> to Oracle and would appreciate any help you could give me
> in order to do so.
>
> i.e.
>
> - which files are relevant
> - DB design
> - Java user-interface
> - general ideas/suggestions that might help
>
>
> Cheers
> Valentin
>
>
>
>
>
>
>
>
>
> +------------------------------------------+
>  Valentin Dimitrov
>  TEL:   +49 (0)6841 1626094
>  MOBIL: +49 (0)176 27017006
>  WWW: http://www.mpi-inf.mpg.de/~valentin/
> +------------------------------------------+
>