Re: set session variable in mysql importHandler

2016-04-22 Thread Zaccheo Bagnati
sessionVariables=group_concat_max_len=. in the connection URL works as expected. Thank you very much! Bye Zaccheo Il giorno gio 21 apr 2016 alle ore 01:14 Alexandre Rafalovitch < arafa...@gmail.com> ha scritto: > The driver documentation talks about "sessionVariables" that might be > possible

Re: set session variable in mysql importHandler

2016-04-20 Thread Alexandre Rafalovitch
The driver documentation talks about "sessionVariables" that might be possible to pass through the connection URL: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html Alternatively, there might be a way to configure driver via JNDI and set some variable

Re: set session variable in mysql importHandler

2016-04-20 Thread Shawn Heisey
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 = > 100;" Normally the MySQL JDB

set session variable in mysql importHandler

2016-04-20 Thread Zaccheo Bagnati
Hi all, 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 = 100;" Thanks Bye Zaccheo