Monthly Archives: June 2016

Encountered the exception : java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘IAM_DB.this_.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Fix was to … Continue reading →

Debian 7.6 was installed on the VM.  Default mysql-server which was getting installed using apt-get was 5.5.  One of the updates in mysql 5.6 was to support more than one current_timestamp column with default value of current time stamp. So … Continue reading →