RockyCode

I have spent mucho time trying to get some named parameters working in the "order by" clause of a dynamic sql query that I'm building. The query isn't even HQL/JPQL. It's native. And yet, it turns out that you cannot use bind variables, named or ordered, in an order by clause.

Hibernate's @Enumerated annotation seems much too brittle in the case of using it with EnumType.ORDINAL. If you're using EnumType.STRING, I think it works beautifully. This is because the annotation can use the name of the enum to make the mapping. In the case of ORDINAL, the value of the enum is used. This presents a couple problems...

The goal:
Create a history audit tool that:

• Fires automatically


• Tracks only selected fields


• Categorizes those fields


• Saves old vs. new data

Issues we'll cover:

• Interceptor config


• Data types


• Dependency Injection


• Alternate EntityListeners

One solution:
The one option that I found that met all these requirements was the Hibernate Interceptor. There may be better alternatives for you if your requirements differ.

The object-relational mapping world of JPA and Hibernate has made a lot of things really nice and easy. As with any framework of this sort, however, it becomes frustrating when the pieces that are supposed to provide magic ease of development do not work as expected. The frustration is only exacerbated when the docs are skimpy.

Type conversions usually happen automatically in JPA, but possibly due to some databases incredibly not having implemented boolean fields yet (Oracle and pre-5.0 MySQL), an extra bit of help in conversion is needed.