How to efficiently manage database connections in Hibernate?

Hibernate ORM
1

Hey guys! :smiling_face_with_three_hearts:

I am diving into a project using Hibernate for object-relational mapping, but I’m hitting a snag with managing database connections efficiently. Anyone have some best practices or tricks to share on keeping those connections under control?

Specifically, I’m curious about how Hibernate handles connection pooling internally, and if there are any recommended configurations or tweaks I can make to improve performance and scalability.
I also check this resource: https://discourse.hibernate.org/t/behavior-when-hibernate-connection-autoqlikcommit-set-to-false/1614 But I have not found any solution.

Thanks in advance for any wisdom you can share!

Respected community member :innocent:

2

I use spring-boot. By default, it will initialize and manage a Hikari connection pool with 10 connections for you.

You didn’t give more specifics about what you’re building, but if it’s a relatively standard application server, just follow the spring-boot guides and take their suggestions.