Question & Answer > View Question

Jasper Report SQL Error In Joget v6 - SQL Exception

Confluence User - 07 May, 2021

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.

jasper

3

Confluence User •

07 May, 2021 •

confluenceUser •

•

confluenceUser •

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.

Confluence User •

07 May, 2021 •

confluenceUser •

•

confluenceUser •

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.

Confluence User •

08 May, 2021 •

confluenceUser •

•

confluenceUser •

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

1

CSV | Excel | XML | PDF

Your answer

Print

Jasper Report SQL Error In Joget v6 - SQL Exception

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-19d646dc-f644-4b90-963f-de2edfda9f42{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-131ba92c-ec0c-4e0b-a38d-329fa0c8901c{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer