[jira] [Updated] (CAUSEWAY-4009) [SecMan] Potential Collation Clash on Login

["Andi Huber (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAUSEWAY-4009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andi Huber updated CAUSEWAY-4009:
---------------------------------
    Fix Version/s: 4.0.0-M2
                       (was: 4.0.0)

> [SecMan] Potential Collation Clash on Login
> -------------------------------------------
>
>                 Key: CAUSEWAY-4009
>                 URL: https://issues.apache.org/jira/browse/CAUSEWAY-4009
>             Project: Causeway
>          Issue Type: Bug
>          Components: Viewer Wicket
>            Reporter: Andi Huber
>            Assignee: Andi Huber
>            Priority: Major
>             Fix For: 4.0.0-M2
>
>
> Login potentially fails:
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0.v202603230926-bc4f4eb36eb1dcce223533d87890ba458628a2f9): org.eclipse.persistence.exceptions.DatabaseException
>  
> Internal Exception: java.sql.SQLException: (conn=17888) Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_uca1400_ai_ci,COERCIBLE) for operation '='
>  
> Error Code: 1267
>  
> Call: SELECT ID, ACCOUNTTYPE, ATPATH, EMAILADDRESS, ENCRYPTEDPASSWORD, FAMILYNAME, FAXNUMBER, GIVENNAME, KNOWNAS, LANGUAGE, NUMBERFORMAT, PHONENUMBER, STATUS, TIMEFORMAT, USERNAME, VERSION FROM ApplicationUser WHERE (USERNAME = ?)
>  
>  bind => [1 parameter bound]
>  
> Query: ReadAllQuery(name="causeway.ext.secman.ApplicationUser.findByUsername" referenceClass=ApplicationUser sql="SELECT ID, ACCOUNTTYPE, ATPATH, EMAILADDRESS, ENCRYPTEDPASSWORD, FAMILYNAME, FAXNUMBER, GIVENNAME, KNOWNAS, LANGUAGE, NUMBERFORMAT, PHONENUMBER, STATUS, TIMEFORMAT, USERNAME, VERSION FROM ApplicationUser WHERE (USERNAME = ?)")



--
This message was sent by Atlassian Jira
(v8.20.10#820010)