AprilandJake.com

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...

Meet the new web. The simpler the better. The cleaner the better. The more pleasing the colors the better. The fuzzier feelings the better. The latest fuzzies have been brought on by a slew of modals. Previously, we haven't used many modals in our layouts and designs, so here's the first working pattern on how to get this kind of stuff working.

This solution allows:

• Content to appear in a modal


• Validation errors post back to the modal


• Edits made in a modal persist back to the database


• Success messages appear on parent page

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.