Forum OpenACS Development: Response to Using Oracle *and* Postgres

Collapse
Posted by Andrew Piskorski on
Andrei, regarding my "Multiple Databases with the ACS DB API" hack for ACS 4.2, you are mistaken. By design, it works identically to the stock ACS 4.2 DB API, except that if you define the database name 'ora-foo' and then pass the switch '-dbn {ora-foo}' to any of the DB API procs, the DB API will use the 'ora-foo' database (which may consist of one or more AOLserver database handle pools) rather than the default database. It never uses the "next available pool regardless of database provider".