Caused by: javax.persistence.PersistenceException: java.lang.RuntimeException: Error creating UUID from database value '9F581736-4755-482A-97D9-A4E8DA98C036'

Support
#1

I have an existing application which i want to transfer to JMIX.
Locally i did generate from the database the application from a MS SQL Database. Everything is working fine.
Now i want to develop further with our MariaDB Server.
When i try now to open a module, i get the following error

Caused by: javax.persistence.PersistenceException: java.lang.RuntimeException: Error creating UUID from database value ‘9F581736-4755-482A-97D9-A4E8DA98C036’

I saw already some forum entries concerning this with Cuba, but nowhere how to solve this issue.
Do I need to change the data or the definition of a guid field ?

Happy for any input before digging further !

#2

I had the same problem. I am creating a new DB and new jmix application, but I have a lot of data from the old system I need to preload into MySQL. When I used the MySQL generated UUID it was not compatible with the jmix UUID like you are seeing. My work around was to change to integer IDs, which I prefer for many other reasons.

#3

Thank you !
Based on your input which did confirm my suspicion, i did change the type from UUID to String. Will check later if this is still running with MS SQL.
You are writing you use integer ID’s. As Guid is a 128-bit value, I suspect you did convert to a BigInteger ?

#4

In my case I am rearranging the table structure from the old FileMaker application so I go through a manual ETL process to get data into MySQL for use by Jmix. Because of the restructuring, I was generating new PKs as the data was loaded into MySQL. Initially I tried UUID because that was the Jmix default. Then I found they are not compatible. When I switched I did not use BigInteger because I was not converting an old value, just generating a new one and Integer is big enough for this purpose.