Andi Huber created CAUSEWAY-4009:
------------------------------------
Summary: [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
Fix For: 4.0.0
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)
