org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day 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_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day and old.businesspath=delta.businesspath;

Google Groups | Florian Gnägi | 1 year ago
  1. 0

    Re: [OpenOLAT] Re: problem with statistics

    Google Groups | 1 year ago | Florian Gnägi
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day 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_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day and old.businesspath=delta.businesspath;
  2. 0

    Spring sql-error-codes.xml does not show correct exception on timeout

    Stack Overflow | 1 year ago | andyPaul
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select * from myTable where userCategory='1']; SQL state [70100]; error code [1317]; Query execution was interrupted; nested exception is java.sql.SQLException: Query execution was interrupted
  3. 0

    GitHub comment 23#253015906

    GitHub | 2 months ago | KrzysztofMadejski
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select distinct concat(year(date), ' - ', quarter(date)) from rfwl_notices order by date]; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column 'rf.rfwl_notices.date' which is not in SELECT list; this is incompatible with DISTINCT; nested exception is java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'rf.rfwl_notices.date' which is not in SELECT list; this is incompatible with DISTINCT] with root cause java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'rf.rfwl_notices.date' which is not in SELECT list; this is incompatible with DISTINCT
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DB2 + Spring 1.2 + Hibernate3 - executeQuery method cannot.. - Genuitec

    genuitec.com | 11 months ago
    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select prospect0_.PROSPECT_ID as PROSPECT1_ from PROSPECT prospect0_]; SQL state [null]; error code [-99999]; executeQuery method cannot be used for update.; nested exception is
  6. 0

    Hive jdbc.query(sql, rowmapper) throws UnCatogarized exception

    Stack Overflow | 1 year ago | srikanth
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.jdbc.UncategorizedSQLException

      StatementCallback; uncategorized SQLException for SQL [ update o_stat_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day 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_dayofweek as old, (select businesspath,dayofweek(creationdate) day, count(*) cnt from o_stat_temptable group by businesspath,day) as delta SET old.value=old.value+delta.cnt where old.day=delta.day and old.businesspath=delta.businesspath;

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate()
    2. Spring Framework
      JdbcTemplate.execute
      1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
      5. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
      5 frames
    3. org.olat.course
      StatisticUpdateManagerImpl$1.run
      1. org.olat.course.statistic.StatisticUpdater.updateStatistic(StatisticUpdater.java:139)
      2. org.olat.course.statistic.StatisticUpdateManagerImpl$1.run(StatisticUpdateManagerImpl.java:161)
      2 frames
    4. org.olat.core
      DBSecureRunnable.run
      1. org.olat.core.commons.services.taskexecutor.model.DBSecureRunnable.run(DBSecureRunnable.java:42)
      1 frame
    5. Java RT
      ThreadPoolExecutor.runWorker
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:262)
      3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      3 frames
    6. MySQL jdbc
      StatementImpl.execute
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
      3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
      4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
      5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
      6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
      7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
      8. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)
      9. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)
      9 frames
    7. org.apache.tomcat
      DelegatingStatement.execute
      1. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2 frames