[RFC, RFA] ndoutils for Oracle integration into CVS

[Hendrik Baecker]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Bernhard Reutner-Fischer schrieb:
> David Schmidt wrote support for using an Oracle DB as backend for ndo2db.
> 
> I'd like to ask for assistance to include this Oracle support into the CVS tree.
> 
Some time ago I discusesd the oracle thing with David.
Since he has to trim some of the table names cause of length restriction
I would see a "change" to the database scheme which, IIRC isn't wanted
for the moment.
> The code is up to current CVS, a huge part of a direct patch would come from
> the fact that we changed the directory layout in db/ to cater for
> per-database directories. We did:
> $ mv db/queries db/x
> $ mkdir db/queries
> $ mv db/x db/queries/mysql
> and then populated db/queries/oracle with the respective queries.
> 
Seperation of the normal behavior for MySQL Clients is a good thing
until we're missing a overall solution for those feature requests.
Maintaing the code for Oracle is another one.
I don't know if Ethan has the time to maintain it.
> The rest of the patch can be separated into these hunks:
> - configury & README: Check for Oracle libs, add section for Oracle to README
> - liboci/*: Simple OCI (Oracle C Interface or the like) helpers like ora_oci_init
>   for initializing the OCI env, ora_oci_query(), ora_oci_insert() and the like.
> - src/*: Handle USE_ORACLE path
> 
> Thoughts?
A huge benefit for the NDOUtils to get access to the 'bigger' databases.
Did you thought about linking against libdi as a DBI abstraction layer
for C?
That wouldn't solve the lenght restriction of table names but it might
blow away the great liboci work from David.


Regards,
Hendrik
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknjKT8ACgkQlI0PwfxLQjkErgCfRJlPH2H+8wfr3iIjcjQmTS5T
7u8AnRAyP/o1nY0zPiVStrGPzM1WExu8
=EAHX
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com