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 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 variables that way. > > I haven't tested either though. > > Regards, > Alex. > ---- > Newsletter and resources for Solr beginners and intermediates: > http://www.solr-start.com/ > > > On 20 April 2016 at 23:49, Shawn Heisey <apa...@elyograg.org> wrote: > > 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 > > >