00-database-procs-oracle.tcl

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Fixed db_blob_get for PG, and got rid of db_continue_transaction, which we

can no longer support because PG automatically aborts a transaction after an

error.

  1. … 4 more files in changeset.

Changed the sql plus load routine to cd to the script directory.

fixed display of CR file content in oracle

  1. … 8 more files in changeset.

1. Fixed a bug in the oracle version of acs-mail-nt-create.sql

2. Fixed a bug in the oracle version of the APM - a standard SQL92

left join was being executed rather than the nasty Oracle-specific

notation.

3. Futzed with the APM a bit - you can now only set "watch" commands on

those .xql files which are used by the current installation, you can

only install packages supported by the current installation's RDBMS.

  1. … 8 more files in changeset.

Fixed type (ad_doc to ad_proc, my fingers got confused by the old proc_doc).

1. Added a check that PG was initdb's with the collation order for

characters that we expect.

2. Jon added a "sql/common" directory for the insert statements which

load data for acs-references, so I added a new datamodel type "common"

to the APM.

3. Created a new db API routine that returns true if a given db_type is

compatible with the current RDBMS.

4. Added a workaround for a PL/pgSQL "execute" bug in acs-workflow (other

cases had been fixed previously by others but this one was missed)

5. Diddled a couple of .info files using the APM.

  1. … 10 more files in changeset.

fixed logging to be more configurable within the QD and default to not so verbose.

  1. … 2 more files in changeset.
fixed oracle db api so that db_exec_plsql command would still work after the passed in sql query is converted to an empty string

  1. … 1 more file in changeset.
more debugging of workflow

  1. … 3 more files in changeset.
cleaned up content repository data-model and converted oracle apm to use file storage in the content repository

  1. … 11 more files in changeset.
added support for storing content repository items in the file system

  1. … 8 more files in changeset.
fixed up some oracle stuff that I broke when porting to oracle

  1. … 1 more file in changeset.

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

  1. … 36 more files in changeset.

added QD stuff to Oracle piece. Not tested yet.

Moved the bootstrap and installer stuff into their own mini-package, which

let me clean up the loading of acs-tcl a bit and isolate all the bits of

APM-knowledge required in the pre-acs-tcl bootstrapping process into a single

apm file. In general, bootstrap.tcl is cleaner and easier to read.

    • -0
    • +354
    ./00-database-procs-oracle.tcl
  1. … 37 more files in changeset.