title: How to set group_concat_max_len with MySQL and Hibernate
body: <blockquote>
    <p>while using group concat in query I am not able to get all the event
    group name due to default length of group concat is 1024 so how I can
    set max_length of group concat in existing code.</p>
  </blockquote>
  
  <p>I have a code here were I am using group concat and set max len </p>
  
  <pre><code>==========================================================================
          DATA_QUERY="set group_concat_max_len=10024;
   select group_concat(eg.name) from event_groups eg left join theatres t ON t.theatre_id = eg.theatre_id group by t.theatre_id order by t.application_name"
  
          Session session = getFacadeLookup().getPersistenceFacade().getHibernateSession();
          Query query = session.createSQLQuery(DATA_QUERY) and execute 
  
          List&lt;Object[]&gt; lstResult = query.list();
  ============================================================================
  </code></pre>
  
  <p>error set group_concat_max_len not support here</p>