Jasper Report SQL Error In Joget v6 - SQL Exception

 
1
0
-1

we just migrated from v5 to v6. all reports (jasper jrxml) are working fine in v5. here is spesific error when trying to execute the jrxml on v6.


Caused by: java.sql.SQLException: (conn=894) Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='


mysql server 5.5. joget v6 (latest build). windows 2012.
 


    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, from the error message "Illegal mix of collations" there is a mismatch of collation in the database, like in https://stackoverflow.com/questions/3029321/troubleshooting-illegal-mix-of-collations-error-in-mysql. You will need to update your database tables and columns to use the same collations.

      1. ayohmang

        ok tq Anders, need to backup 1st before change collation. do i need to follow collation like joget's system table. seem to use utf8. 

      2. ayohmang

        (updated)quick solution. i just recompiled/recreated table view and able to run jasper report. 

      CommentAdd your comment...