JDBC neglects SET GLOBAL sql_mode = '' settings
Posted by: R van der Wal
Date: January 15, 2016 03:16AM

I have a query that used to work at older MySQL versions but stops functioning on version 5.7 due to the "sql_mode=only_full_group_by".

I bypassed this error by writing sql_mode = '' in my.cnf.
Now this query works:
- from within MySQL commandline client
- Heidi SQL

But when i put this code into a PHP script that runs on glassfish i still get the error "which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by".

i tried several JDBC clients and am using version 5.1.38 at the moment without any luck.

Options: ReplyQuote

Written By
JDBC neglects SET GLOBAL sql_mode = '' settings
January 15, 2016 03:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.