Forum OpenACS Q&A: Re: connection to secondary database

Collapse
3: Re: connection to secondary database (response to 1)
Posted by C. R. Oldham on 02/02/04 03:56 PM
What I'm not sure of is if the multiple-db-pool support ever made it into the db api.  Right now if you use any of the db_* commands the toolkit will pick up one of the available pools and historically there was no way to say which one that was.  So for db connections that were not to the main schema, you had to use the bare AOLServer api for accessing the database.

Anyone know the answer to that?

Collapse
4: Re: connection to secondary database (response to 3)
Posted by Jade Rubick on 02/02/04 07:56 PM
I believe it was added in, C.R. Check api-doc to be sure, though.
Collapse
6: Re: connection to secondary database (response to 3)
Posted by Andrew Piskorski on 02/03/04 07:27 AM
C.R. and Rocael, yes, out-of-othe-box multi-db support certainly did get added to the db_* API, nearly a year ago now. (That's what all those -dbn switches you should see in the OpenACS 5.0 api-doc are for). However, at least two users have reported that something or someone has egregiously broken the multi-db support since it was added, and I still haven't seemed to find a chance to look into what might be wrong. :(