Changes between Version 1 and Version 2 of Advanced Application Development

Timestamp:

02/21/26 20:39:19 (7 days ago)

Author:

231035

Comment:

--

Advanced Application Development

@@ -254 +254 @@
     }
 }}}
+== Pooling
+In the backend layer of the Petify application, we use Spring Boot with Spring Data JPA to communicate with the PostgreSQL database. Because of this architecture, database connections are not created manually. Instead, they are automatically managed by HikariCP, which is the default connection pool implementation in Spring Boot.
+[[BR]]
+HikariCP is included transitively through:
+{{{spring-boot-starter-data-jpa}}}
+[[BR]]
+Therefore, no additional configuration is required to enable pooling.
+[[BR]]
+In this project, we use these HikariCP configuration values:
+{{{
+spring.datasource.hikari.maximum-pool-size=20
+spring.datasource.hikari.minimum-idle=5
+spring.datasource.hikari.connection-timeout=20000
+spring.datasource.hikari.idle-timeout=300000
+spring.datasource.hikari.max-lifetime=1200000
+spring.datasource.hikari.auto-commit=true
+}}}
+These values mean:
+* A maximum of 20 database connections can be active at the same time.
+* The pool maintains 5 idle connections ready for immediate use.
+* If all connections are busy, a request waits up to 20 seconds before failing.
+* Idle connections are kept alive for up to 5 minutes.
+* Connections are refreshed every 20 minutes to avoid stale connections.
+* Auto-commit is enabled by default.