btw is not a NH problem. 2009/10/15 [email protected] <[email protected]>
> > sorry! > > that was a coipy/paste error - in the app they are different con > strings... > > On Oct 15, 4:03 pm, Valeriu Caraulean <[email protected]> wrote: > > 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:// > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
