[icinga-checkins] icinga.org: icinga-core/mfriedrich/ocilib: add initial Oracle support to IDOUtils using ocilib

git at icinga.org git at icinga.org
Mon Oct 19 02:08:55 CEST 2009


Module: icinga-core
Branch: mfriedrich/ocilib
Commit: 878d9dc3a7c98bf435f7a090a7b6a85465504bfd
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=878d9dc3a7c98bf435f7a090a7b6a85465504bfd

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Sat Oct 17 03:48:28 2009 +0200

add initial Oracle support to IDOUtils using ocilib

Changelog
* idoutils: add Oracle support with oclilib
* idoutils: add configure --enable-oracle
* idoutils: add oracle support to ido2db.cfg
* idoutils: add ocilib runtime version check
* idoutils: add ocilib linked at runtime (prevents setting of $ORACLE_HOME during configure)
* idoutils: add ocilib hack to temp #undef CONFIG_H during compiling
* idoutils: add #define USE_ORACLE set by --enable-oracle
* idoutils: add #ifndef USE_ORACLE #else #endif to get code compatible with libdbi
* idoutils: add ocilib connection, statement, resultset
* idoutils: add ocilib execute statement, commit (no autocommit since we want to use the pros of oracle!)
* idoutils: add ocilib insert id for sequence handling
* idoutils: add ocilib free statement to match with sequences
* idoutils: add oracle sysdate instead of NOW()
* idoutils: add long_output to oracle.sql - introduce clob (Character Large Object)
* idoutils: add even more debugoutput for oracle
* idoutils: modify configure to use OCI_CHARSET_ANSI
* idoutils: modify configure to set LD_LIBRARY_PATH for ido2db init script
* idoutils: modify formatting to get more readable
* idoutils: fix typecast bug - unsigned long is bigger then int
* idoutils: fix oracle notif_timeperiod_object_id (30 chars max)
* idoutils: fix oracle table serviceescalationcontactgroups (30 chars max)
* idoutils: fix hoststatus/servicestatus/servicecheck unique constraint updating mismatch
* idoutils: fix insert_or_update queries where update violates unique constraint
* idoutils: remove and ignore oracle table_prefix (30 chars max)

---

 Changelog                                   |   26 +++-
 THANKS                                      |    2 +
 configure                                   |    2 +-
 configure.in                                |    2 +-
 module/idoutils/config/ido2db.cfg-sample.in |    6 +
 module/idoutils/db/oracle-drop.sql          |   61 ++++++
 module/idoutils/db/oracle.sql               |   19 ++-
 module/idoutils/include/db.h                |    5 +
 module/idoutils/include/ido2db.h            |    6 +-
 module/idoutils/src/db.c                    |  210 +++++++++++++++++----
 module/idoutils/src/dbhandlers.c            |  274 ++++++++++++++++-----------
 module/idoutils/src/dbqueries.c             |   81 ++++-----
 module/idoutils/src/ido2db.c                |    9 +-
 13 files changed, 494 insertions(+), 209 deletions(-)

Diff:   https://git.icinga.org/?p=icinga-core.git;a=commitdiff;h=878d9dc3a7c98bf435f7a090a7b6a85465504bfd




More information about the icinga-checkins mailing list