How to use group_concat in Hibernate + Spring

Question

How can I use addSqlFunction() in spring when I configured hibernate with hibernate.cfg.xml file? Or is there any other way to use group_concat?

This is explained here: [http://stackoverflow.com/questions/4955580/hibernate-how-to-use-concat-and-group-concat][1] [1]: http://stackoverflow.com/questions/4955580/hibernate-how-to-use-concat-and-group-concat — stefan.m, Oct 23 '12 at 10:09

score 2 · Answer 1 · edited Jan 28 '15 at 08:57

If you’re using Spring’s HibernateTemplate to integrate with Hibernate, there’s a simple solution to this. Override Spring’s LocalSessionFactoryBean and implement the method postProcessConfiguration.

The light at the end of the tunnel (config is the object passed to you by the method postProcessConfiguration):

config.addSqlFunction( “group_concat”, new StandardSQLFunction("group_concat", new StringType());

How to use group_concat in Hibernate + Spring

1 Answers1

Linked