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
