Maybe your problem is due to this bug: http://trac.symfony-project.org/ticket/7689
Set right connection before call and reset after :( On 12 Ago, 17:59, Zuchuat Bertrand <[email protected]> wrote: > Hi Jon, > > I have a strange problem with multiple db connections. > > My databases.yml (definition): > > all: > common: > class: sfDoctrineDatabase > param: > dsn: 'oracle:dbname=//server:1521/sid' > username: xxxxx > password: xxxxx > web: > class: sfDoctrineDatabase > param: > dsn: 'oracle:dbname=//server:1521/sid' > username: xxxxx > password: xxxxx > virtua: > class: sfDoctrineDatabase > param: > dsn: 'oracle:dbname=//server:1521/sid2' > username: xxxxx > password: xxxxx > > My model AffiliationGroup connected on "common" connection name. I show this > on BaseClass: > Doctrine_Manager::getInstance()->bindComponent('AffiliationGroup', 'common'); > > I use this code to get records on my table: > $this->agroups = > Doctrine_Core::getTable('AffiliationGroup')->retrieveActive(); > > With that, i have this error: > 500 | Internal Server Error | Doctrine_Connection_Oracle_Exception > > If i check the query on debug bar, i show this: > SELECT c.id AS c__id, c.name AS c__name, (SELECT COUNT(c2.id) AS c2__0 FROM > common.affiliation c2 WHERE (c2.affiliation_group_id = c.id AND c2.is_enabled > = 1 AND c2.is_visible = 1)) AS c__0 FROM common.affiliation_group c WHERE > (c.is_show_on_map = '1' AND (c.deleted_at IS NULL)) ORDER BY c.name > > 0.00s, "virtua" connection > > virtua is strong connection. The correct name for that is "common". > > I check that with mysql. I have the same problem. > > Please help me with that because i start a project with 3 connections and i > have a big problem with that. > > Thanks for you help. > > Bertrand Zuchuat -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
