Can Hibernate generate uppercase SQL?

Question

Hi,

can Hibernate generate uppercase SQL? I.e. some option which would make it send

SELECT table1_.prop1_ FROM my_table AS table1_;

instead of current

select table1_.prop1_ from my_table as table1_;

which I consider far less readable, esp. for long queries HBN tends to spit. See also https://forum.hibernate.org/viewtopic.php?f=1&t=932412

Thanks

Answer 1

I don't know that this will enforce uppercase, but it does help with readability. In your hibernate.cfg.xml place the following in your <session-factory> element:

<!--hibernate.cfg.xml -->
<property name="format_sql">true</property>

Answer 2

I'm not aware of a way to upper case the keywords only out-of-the-box. But you could write your own interceptor and implement o.h.Interceptor#onPrepareStatement(String) to transform the sql string as you like.

Answer 3

Found: The King of the Hibernate team is strictly against such option:

http://opensource.atlassian.com/projects/hibernate/browse/HB-1070

For anyone looking for this, please comment there (you can't vote on closed issues :( )

Update: Another solution is to replace the FreeMarker templates in hibernate's .jar's.