Pool de conexões no Tomcat

O pool de conexões, no Tomcat, pode ser feito no context.xml.

Veja um exemplo, com destaques para os nomes de: driver, banco de dados, usuário e senha que vai usar.

Existe também o destaque para o name do JDBC

O arquivo context.xml:

---

<Resource auth="Container"

name=“jdbc/exemplo"

driverClassName="com.mysql.jdbc.Driver"

maxActive="20"

maxIdle="10"

maxWait="-1"

type="javax.sql.DataSource"

url="jdbc:mysql://localhost/exemplo?autoReconnect=true"

password="senha"

username="usuario"

removeAbandoned = true

validationInterval = 34000

validationQuery="SELECT 1"

testOnBorrow="true" testWhileIdle="true"

timeBetweenEvictionRunsMillis="10000"

minEvictableIdleTimeMillis="60000" />

</Context>

---

---

No web.xml, o trecho adicionado:

<resource-ref>

<res-ref-name>jdbc/exemplo</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

---

---

No hibernate.cfg.xml:

<hibernate-configuration>

<session-factory name="hibernate/SessionFactory">

<property name="hibernate.connection.datasource">java:/comp/env/jdbc/exemplo</property>

<property name="hibernate.current_session_context_class">thread</property>

<property

name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>

<property name="hibernate.jdbc.batch_size">0</property>

<mapping resource="br/com/bean/NomedoBean.hbm.xml"></mapping>

</session-factory>

</hibernate-configuration>

---