SQL Zone is brought to you in partnership with:

I am the founder and lead developer of Hibernate Envers, a Hibernate core module, which provides entity versioning/auditing capabilities. I am also one of the co-founders of SoftwareMill, a company specializing in delivering customized software solutions (http://softwaremill.com, "Extraordinary software as a standard"), based on Java and JBoss technologies. After work, apart from being involved in development of Envers, I work on several small open source projects, like ElasticMQ (simple message queue written in Scala with an SQS interface), projects around static analysis (using JSR 308 - Typestate Annotations/ Checkers Framework and FindBugs), and some CDI/Weld (not always portable) extensions, like autofactories or stackable security interceptors. I am also interested in new JVM-based languages, especially with functional elements (like Scala, JRuby) and frameworks built using them (like Lift), as well as improving the ways we use Dependency Injection. Adam is a DZone MVB and is not an employee of DZone and has posted 52 posts at DZone. You can read more from them at their website. View Full User Profile

Hibernate 4.1.4: Envers Tests Run & Pass on Multiple DBs

06.10.2012
| 2610 views |
  • submit to reddit

Envers is an entity auditing framework, making it possible to store and query for historical data.

The Hibernate 4.1.4 release may seem to be a minor one, but it’s pretty important for Envers. Thanks to a huge amount of work mainly by Łukasz Antoniak and Strong Liu, with substantial help from Steve Ebersole, Envers tests are now part of the matrix testsuite. Thanks guys! :)

That means the tests now run regularly (and importantly, as of now pass) on MySQL, PostgreSQL, Oracle, MS SQL, DB2, Sybase (and the usual H2) databases. The testsuite contains dozens of mapping scenarios, each trying to write some data in a couple of transactions and then checking that the history is properly written, using both the default and validity audit strategy.

Envers is bundled with JBoss AS 7, as well is part of the Hibernate distribution. For more information see the documentation.

Published at DZone with permission of Adam Warski, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Comments

Fahmeed Nawaz replied on Tue, 2012/06/12 - 10:31am

How can i write the code in JAVA,if i want to query the records like this SQL below:
select * from things where name='a' or name='b'

thanks

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.