I would like know how I can use the hibernate envers with two database, it's because in my project, the client is using the main entities in a main database and they are using another database to store the history, so I have two persistence-unit. It's a integration project, so we are using apache camel, but the code is run in JBoss AS 6. Is it possible configure the hiberante envers to use another persistence-unit or access another database in moment of to record the history? The databases is sqlserver.
You can use different schemas/catalogues (see the docs). Different databases aren't possible as far as I know.