Hi team,
We have seen connection leaks happening after we upgraded from Hibernate3 to hibernate-core-6.5.2.Final. This crashes the wildfly (version 31) after some time and only a restart of the server helps. we are using jdk 17.
The queries which used to work earlier have stopped working after the upgrade. They just hang and dont return results for a long time. This is impacting our production application. Any tips or guidance will be greatly appreciated.
FYI - we are using same hibernate.cfg.xml from hibernate3. Do we need to change anything to make it compatible with hibernate6.5?
Thanks
CM
Hello @cmalayil, Hibernate 3 was released in 2005. A lot has changed in the past 19 years, and with this little information is going to be pretty much impossible to help you in any significant way.
You can try isolating the problem around these “long running” queries, extracting the entity mappings that are involved and looking at the generated SQL and the database logs to try understanding what’s going on.
If you can provide a reproducer test case that shows hanging queries we’ll be more than happy to help you. Otherwise, your only option is looking into commercial support.
Your configuration looks pretty simple, and I believe the properties you are using didn’t chance.
