Hello everyone, For a year now I am being responsible for the DB infrastructure and the Data Access Layer module in our project everything has been wonderful with NHibernate and NEnvers. It is just now that I can't find the answer to my new requirement...
I asked the following in Stack Overflow but it seems that I won't have an answer: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- I want to have two separate databases with Nhibernate and NEnvers, one for the production database (already fully functional) and the second which contains the Audit info (Also fully functional but only with one database). I found and applied this here: NHibernate Envers - how to audit revisions on a separate database? <http://stackoverflow.com/questions/15071023/nhibernate-envers-how-to-audit-revisions-on-a-separate-database> It gives me the exception: ADOExceptionReporter 10 SQL logic error or missing database no such table: AuditDatabase.sqlite_master10:58:09,488 ERROR SchemaUpdate 10 could not complete schema updateNHibernate.Exceptions.GenericADOException: could not get table metadata: z_audit_ProductionMachine_AUD[SQL: SQL not available] ---> System.Data.SQLite.SQLiteException: SQL logic error or missing database no such table: AuditDatabase.sqlite_master.......... The audit implementation works without a problem with just one database, but my requirement is to work with two. Any idea would be highly appreciated. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Does maybe anyone could give me a direction or an idea where should I look or what I could try? Thanks, John -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
