As I suggested in other group, you have specified same database for both factories.
On Thu, Oct 15, 2009 at 3:26 PM, Wayne Douglas <[email protected]> wrote: > > hmm > > here's my config can you see if there's anything blatantly wrong? > > ideally i'd like to have all the different reporting concerns come > from their respective application databases and my reporting app to > belong to itself. nice and pluggable :) > > <code> > > <castle> > <components> > <component id="GenericRepository" type="Ideal.Web.Repository`1, > Ideal.Web"/> > </components> > <facilities> > <facility id="nhibernate" > isWeb="true" > type="Castle.Facilities.NHibernateIntegration.NHibernateFacility, > Castle.Facilities.NHibernateIntegration" > > configurationBuilder="Ideal.Rttm.Web.FluentNHibernateConfigurationBuilder, > Ideal.Rttm.Web"> > > <factory id="nhibernate.factory.session1"> > <settings> > <item key="show_sql">true</item> > <item key="connection.provider"> > NHibernate.Connection.DriverConnectionProvider > </item> > <item key="connection.driver_class"> > NHibernate.Driver.SqlClientDriver > </item> > <item key="connection.connection_string"> > Data Source=.;Initial Catalog=Reporting;User Id=sa;Password=***; > </item> > <item key="dialect"> > NHibernate.Dialect.MsSql2005Dialect > </item> > <item key="proxyfactory.factory_class"> > NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle > </item> > </settings> > <assemblies> > <assembly>Ideal.Rttm.Model</assembly> > </assemblies> > </factory> > > <factory id="nhibernate.factory.session2" alias="reporting"> > <settings> > <item key="show_sql">true</item> > <item key="connection.provider"> > NHibernate.Connection.DriverConnectionProvider > </item> > <item key="connection.driver_class"> > NHibernate.Driver.SqlClientDriver > </item> > <item key="connection.connection_string"> > Data Source=.;Initial Catalog=Reporting;User Id=sa;Password=***; > </item> > <item key="dialect"> > NHibernate.Dialect.MsSql2005Dialect > </item> > <item key="proxyfactory.factory_class"> > NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle > </item> > </settings> > <assemblies> > <assembly>Ideal.Reporting.Model</assembly> > </assemblies> > </factory> > > </facility> > <facility id="atm" > type="Castle.Facilities.AutomaticTransactionManagement.TransactionFacility, > Castle.Facilities.AutomaticTransactionManagement" /> > </facilities> > </castle> > > </code> > > On Thu, Oct 15, 2009 at 2:22 PM, Fabio Maulo <[email protected]> wrote: >> I don't think the problem is in NH. >> I'm using multi DB app without problems (without Castle NHF) >> >> 2009/10/15 Wayne Douglas <[email protected]> >>> >>> Hi >>> >>> I have asked this on the castle list as i'm using the nh facility but >>> it just dawned on me to ask it here too :) >>> >>> sorry for the cross posting. >>> >>> I'm using the nh facility to configure the following setup: >>> >>> i have 1 database which stores generic report configuration. >>> and another which stores the actual report data. >>> >>> i also have 1 project for interacting with the report configuration >>> database (entities and mappings etc) >>> and another for interacting with the report data database (entities >>> and mappings etc). >>> >>> i've used the following to create 2 factories: >>> >>> <code> >>> >>> <facilities> >>> <facility id="nhibernate"> >>> <factory id="nhibernate.factory.session1"> >>> ... >>> <assemblies> >>> <assembly>ReportData.Model</assembly> >>> </assemblies> >>> </factory> >>> >>> <factory id="nhibernate.factory.session2" alias="reporting"> >>> ... >>> <assemblies> >>> <assembly>Reporting.Model</assembly> >>> </assemblies> >>> </factory> >>> </facility> >>> </facilities> >>> >>> <code> >>> >>> the problem is is that even though nhibernate.factory.session1 and >>> nhibernate.factory.session2 are looking at different databases and >>> have different assemblies configured it always seems to create the >>> tables for both models in both DBs? >>> >>> how do i tell nhibernate.factory.session1 to look at db1 and model1 >>> and nhibernate.factory.session2 to look at db2 and model2? >>> >>> -- >>> Cheers, >>> >>> w:// >>> >>> >> >> >> >> -- >> Fabio Maulo >> >> > >> > > > > -- > Cheers, > > w:// > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
