Hello All,

I am developing an application which consists of several different modules pointing to the same database. I have configured the datasource in a JNDI file. I have done connection pooling in it like below:



<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/public_PostgreSQL</jndi-name>
<connection-url>jdbc:postgresql://localhost/autohaul2</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>stafona</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
</local-tx-datasource>
</datasources>


In hibernate.cfg.xml of each module I added this line

<property name="hibernate.connection.datasource">java:AutoHaul2Datasource</property>

Now my question is that whether this pool size will be for the whole container or each war file will read this file separately and have its own 20 pool size. For example, if I have the following modules:



Module A

Module B

Module C

Module D



and each module pointing to the same datasource in JNDI. So the whole system will have a max-pool-size=20 or 80?

hello,
sorry this is the wrong forum, please post in https://forum.hibernate.org/viewforum.php?f=1