Mudanças entre as edições de "Pool de conexões no Tomcat"
De Wiki Integrator do Brasil
Linha 12: | Linha 12: | ||
... | ... | ||
<Resource auth="Container" | <Resource auth="Container" | ||
− | name= | + | name="jdbc/exemplo" |
− | driverClassName= | + | driverClassName="com.mysql.jdbc.Driver" |
maxActive="20" | maxActive="20" | ||
maxIdle="10" | maxIdle="10" | ||
maxWait="-1" | maxWait="-1" | ||
− | type= | + | type="javax.sql.DataSource" |
− | url= | + | url="jdbc:mysql://localhost/exemplo?autoReconnect=true" |
password="senha" | password="senha" | ||
username="usuario" | username="usuario" | ||
Linha 47: | Linha 47: | ||
<hibernate-configuration> | <hibernate-configuration> | ||
<session-factory name="hibernate/SessionFactory"> | <session-factory name="hibernate/SessionFactory"> | ||
− | <property name="hibernate.connection.datasource">java:/comp/env/jdbc/ | + | <property name="hibernate.connection.datasource">java:/comp/env/jdbc/exemplo</property> |
<property name="hibernate.current_session_context_class">thread</property> | <property name="hibernate.current_session_context_class">thread</property> | ||
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property> | <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property> |
Edição das 00h59min de 13 de abril de 2016
O pool de conexões, no Tomcat, pode ser feito no arquivo context.xml, que deve estar em seu aplicativo.
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" /> ...
No arquivo 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>