hibernate-reactive: Id of type UUID cannot be retrieved with MariaDB and MySQL
The entity is in the db but a find will return null
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 17 (17 by maintainers)
Commits related to this issue
- [#678] Test case for field of type UUID — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Clean up IdentifierGenerationTypeTest — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Clean up IdentifierGenerationTypeTest — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Test case for field of type UUID — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Clean up IdentifierGenerationTypeTest — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Test case for field of type UUID — committed to hibernate/hibernate-reactive by DavideD 3 years ago
- [#678] Clean up IdentifierGenerationTypeTest — committed to hibernate/hibernate-reactive by DavideD 3 years ago
- [#678] Test case for field of type UUID — committed to DavideD/hibernate-reactive by DavideD 3 years ago
- [#678] Clean up IdentifierGenerationTypeTest — committed to DavideD/hibernate-reactive by DavideD 3 years ago
I’ve added a test case (UUIDAsBinaryType) but I’m not going to close this issue for now: https://github.com/hibernate/hibernate-reactive/pull/680
Wating to see if the VErt.x team is going to do something about it
I’ve tested it and it seems to work when I use Hibernate ORM and JDBC
I’ve found the problem. The table has a column defined as
binary(255)but the UUID is created as abinary(16). This work for the other dialect but not for MySQL/MariaDB with vert.x SQL client