Custom SQL for executing multiple queries

[marwan12]

Hi,
I have a custom sql in which i m using group_concat function, but i want to set the limit of it by executing another query first like
"SET SESSION group_concat_max_len = 10000000";

How can i ensure that i execute this first and then the usual select query in the custom sql tag or via any other way?

Please advice.

[Isomorphic]

See the JDBC Operations sample.

Note that, since connections are pooled, you may not want to take this approach at all, or at least, you should be careful to reset the Connection to it's initial state after doing the query in which you want this setting applied.