Default schema and REVINFO

[sdseaman]

We have a project that allows the user to configure the database connectivity via an external property file. 

The issue we are having is that to get the REVINFO to be created we have to specify the default scheme in the persistence.xml.  Thing is, we don't want the users to have to edit that file since it is in our jar.

Is there any way to get the default_schema set via an external properties file at runtime?

[adamw]

Sure, you can set it programmaticaly when you setup hibernate. See the Envers testsuite for example. Probably the same way you set the schema for normal entities.

Adam

[sdseaman]

Thanks!

Where can I find the Envers testsuite?

[adamw]

https://github.com/hibernate/hibernate-orm/blob/master/hibernate-envers/src/matrix/java/org/hibernate/envers/test/AbstractEntityTest.java

Adam

[sdseaman]

I've created a blog post explainging exactly how to do this in a Spring env that supports external properties files.

http://sloanseaman.com/wordpress/2012/02/07/dynamic-configuration-of-hibernate-envers/

Just in case anyone wants to know how I did it.

Thanks for the help!

[adamw]

Great! I'll add that to the FAQ, if you don't mind.

Adam

[sdseaman]

I'd be honored.  Please take a moment to review the blog posting first to make sure it is correct.  I'd be happy to change anything I may have incorrect or that you disagree with.

[adamw]

Done: https://community.jboss.org/wiki/EnversFAQ

Thanks again

Adam