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:

---

<?xml version="1.0" encoding="UTF-8"?>

<Context path="/">

<Resource auth="Container"

driverClassName="com.mysql.jdbc.Driver"

maxActive="40" maxIdle="10" maxWait="-1"

name="jdbc/exemplo"

type="javax.sql.DataSource"

url="jdbc:mysql://localhost:3306/exemplo"

username="suporte"

password="integrator"

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>

---