On 4/20/2016 6:01 AM, Zaccheo Bagnati wrote: > I configured an ImportHandler on a MySQL table using jdbc driver. I'm > wondering if is possible to set a session variable in the mysql connection > before executing queries. e. g. "SET SESSION group_concat_max_len = > 1000000;"
Normally the MySQL JDBC driver will not allow you to send more than one SQL statement in a single request -- this is to prevent SQL injection attacks. I think MySQL probably has a JDBC parameter that would allow multiple statements per request, but a better option might be to put all the statements you need in a stored procedure and call the procedure from the import handler. You'll need to consult MySQL support resources for help with how to do this. Thanks, Shawn
