{"type":"doc","content":[{"type":"paragraph","content":[{"text":"To set up HikariCP with Hibernate in a Maven-based project, follow these steps to include the necessary dependencies, configure Hibernate to use HikariCP, and apply connection pool settings. Here’s a detailed guide:","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"1. ","type":"text"},{"text":"Add Maven Dependencies","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"You need to add dependencies for Hibernate, HikariCP, and any other necessary libraries in your ","type":"text"},{"text":"pom.xml","type":"text","marks":[{"type":"code"}]},{"text":" file.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"1.1. Hibernate Core Dependency","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":" org.hibernate hibernate-core 5.6.15.Final ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"1.2. HikariCP Dependency","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":" com.zaxxer HikariCP 5.0.0 ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"1.3. Database Driver Dependency","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Include the appropriate JDBC driver for your database. For example, for MySQL:","type":"text"}]},{"type":"codeBlock","content":[{"text":" mysql mysql-connector-java 8.0.29 ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Now in Hibernate Connection Pool setting:","type":"text"}]},{"type":"paragraph","content":[{"text":" 2 120000 600000 10","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Explanation:","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"2.1. Minimum Idle Connections","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"configuration.getProperties().setProperty(\"hibernate.hikari.minimumIdle\", \"2\");","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":": Sets the minimum number of idle connections that HikariCP maintains in the pool.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Purpose","type":"text","marks":[{"type":"strong"}]},{"text":": Ensures that at least 2 connections are always available and idle. This reduces the overhead of creating new connections when the application experiences a sudden increase in demand, leading to faster response times and reduced latency.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"2.2. Idle Timeout","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"configuration.getProperties().setProperty(\"hibernate.hikari.idleTimeout\", \"120000\");","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":": Specifies the maximum amount of time (in milliseconds) that a connection can be idle in the pool before it is eligible for eviction.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Purpose","type":"text","marks":[{"type":"strong"}]},{"text":": Ensures that connections that are idle for longer than the specified timeout are removed from the pool. Setting this to ","type":"text"},{"text":"120000","type":"text","marks":[{"type":"code"}]},{"text":" milliseconds (2 minutes) helps manage memory and connection resources by evicting unused connections while keeping enough idle connections to handle sudden spikes in demand.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"2.3. Maximum Lifetime","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"configuration.getProperties().setProperty(\"hibernate.hikari.maxLifetime\", \"600000\");","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":": Defines the maximum lifetime (in milliseconds) of a connection in the pool. After this time, the connection will be retired and a new one will be created.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Purpose","type":"text","marks":[{"type":"strong"}]},{"text":": Helps avoid potential issues with connections that might become stale or invalid over time. Setting ","type":"text"},{"text":"600000","type":"text","marks":[{"type":"code"}]},{"text":" milliseconds (10 minutes) ensures that connections are periodically refreshed, which can improve stability and performance.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"2.4. Maximum Pool Size","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"configuration.getProperties().setProperty(\"hibernate.hikari.maximumPoolSize\", \"10\");","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]},{"text":": Sets the maximum number of connections that HikariCP can maintain in the pool.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Purpose","type":"text","marks":[{"type":"strong"}]},{"text":": Limits the number of connections to prevent overwhelming the database with too many concurrent connections. Setting ","type":"text"},{"text":"10","type":"text","marks":[{"type":"code"}]},{"text":" ensures that the pool can handle up to 10 connections simultaneously, balancing performance with resource usage.","type":"text"}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported