JDBC neglects SET GLOBAL sql_mode = '' settings
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.
Subject
Written By
Posted
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.