[JIRA] (OSJ-342) Investigate Strategies to end of life our use of Hibernate in V5

[Rod Widdowson (Jira)]

Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) *commented* on OSJ-342 ( https://shibboleth.atlassian.net/browse/OSJ-342?atlOrigin=eyJpIjoiODU0NDEzYWZmMjU5NDVhZGE5OWE5YzhkM2VjODkxYzUiLCJwIjoiaiJ9 )

Re: Investigate Strategies to end of life our use of Hibernate in V5 ( https://shibboleth.atlassian.net/browse/OSJ-342?atlOrigin=eyJpIjoiODU0NDEzYWZmMjU5NDVhZGE5OWE5YzhkM2VjODkxYzUiLCJwIjoiaiJ9 )

Status Update
-------------

I’ve written a version of this which does (I think) the right sort of stuff.

Most of the tests pass, the failures being because HSQLDB blows up with an assertion error under high transactional load I have logged this with the maintainer ( https://sourceforge.net/p/hsqldb/discussion/73674/thread/c8881ab9bc/ ) and the last comment (3 days ago) was “It shouldn't be too difficult to fix the issue”. Given the the time to respond up to that point (2 or 3 hours - even on a Sunday) it feels like that was tempting providence.

Limited tests indicate that it is On-Disk compatible with the JPA service (which was a P0 requirement).

In order to save the “stream of consciousness” work I intend pushing to a dev branch.

While I am waiting for the HSQLDB bug to be fixed I am cleaning up and productizing the code (logging, constraint checking, and, critically, adding configurability around the SQL that is used). With that done I’ll ask Scott Cantor ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A5b78efc9-1379-42cc-a3f6-56c6ea3a0007 ) to review and then start putting it into a plugin. I’m hoping that the test DB will be fixed before I finish all that stuff.

Ian Young ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ae127cb03-43ed-473d-b6ba-592949cb4be8 ) : This uses 5 packages from java.sql and one from jaxax.sql. are there any Jakarta EE issues I need to be aware of?

( https://shibboleth.atlassian.net/browse/OSJ-342#add-comment?atlOrigin=eyJpIjoiODU0NDEzYWZmMjU5NDVhZGE5OWE5YzhkM2VjODkxYzUiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/OSJ-342#add-comment?atlOrigin=eyJpIjoiODU0NDEzYWZmMjU5NDVhZGE5OWE5YzhkM2VjODkxYzUiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100198- sha1:8023b99 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220512/535070ed/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-d402f392-8642-42b9-a283-d70250738ee7
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220512/535070ed/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-e7c8808e-5e51-4fac-a25f-f83850be8fef
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220512/535070ed/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-809b7b3a-bc58-4b3a-9b17-3a0421d210d4
Type: image/png
Size: 468 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220512/535070ed/attachment-0005.png>