org.springframework.jdbc.UncategorizedSQLException

StatementCallback; uncategorized SQLException for SQL [ update o_stat_weekly as old, (select businesspath,concat(year(creationdate),'-',lpad(week(creationdate,3),2,'0')) week, count(*) cnt from o_stat_temptable group by businesspath,week) as delta SET old.value=old.value+delta.cnt where old.week=delta.week and old.businesspath=delta.businesspath; ]; SQL state [HY000]; error code [1267]; Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' ^%^ >>>stack of 1.cause::org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_weekly as old, (select businesspath,concat(year(creationdate),'-',lpad(week(creationdate,3),2,'0')) week, count(*) cnt from o_stat_temptable group by businesspath,week) as delta SET old.value=old.value+delta.cnt where old.week=delta.week and old.businesspath=delta.businesspath;

Solutions on the web292

  • via Google Groups by Florian Gnägi, 6 months ago
    StatementCallback; uncategorized SQLException for SQL [ update o_stat_weekly as old, (select businesspath,concat(year(creationdate),'-',lpad(week(creationdate,3),2,'0')) week, count
  • via YouTrack by Unknown author, 1 year ago
    Error executing query with params:[1013, 1010, 1010, 5]; uncategorized SQLException for SQL [SELECT COUNT(*) FROM ( SELECT count(r.HASH) AS COUNTER from inspection_results r, inspection_data a WHERE r.BUILD_ID IN (?,?) AND a.HASH=r.HASH GROUP BY
  • StatementCallback; uncategorized SQLException for SQL [Select empID from User]; SQL state [S1009]; error code [0]; Column Index out of range, 2 > 1. ; nested exception is java.sql.SQLException: Column Index out of range, 2 > 1.
  • Stack trace

    • org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_weekly as old, (select businesspath,concat(year(creationdate),'-',lpad(week(creationdate,3),2,'0')) week, count(*) cnt from o_stat_temptable group by businesspath,week) as delta SET old.value=old.value+delta.cnt where old.week=delta.week and old.businesspath=delta.businesspath; ]; SQL state [HY000]; error code [1267]; Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' ^%^ >>>stack of 1.cause::org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_weekly as old, (select businesspath,concat(year(creationdate),'-',lpad(week(creationdate,3),2,'0')) week, count(*) cnt from o_stat_temptable group by businesspath,week) as delta SET old.value=old.value+delta.cnt where old.week=delta.week and old.businesspath=delta.businesspath; at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) at org.olat.course.statistic.StatisticUpdater.updateStatistic(StatisticUpdater.java:139) at org.olat.course.statistic.StatisticUpdateManagerImpl$1.run(StatisticUpdateManagerImpl.java:161) at org.olat.core.commons.services.taskexecutor.model.DBSecureRunnable.run(DBSecureRunnable.java:42) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 1 month ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    7 more bugmates