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:// --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
