Skip to content

Instantly share code, notes, and snippets.

@levymoreira
Created August 7, 2014 12:59
Show Gist options
  • Save levymoreira/cf36de6ac6c250e0de45 to your computer and use it in GitHub Desktop.
Save levymoreira/cf36de6ac6c250e0de45 to your computer and use it in GitHub Desktop.
Hibernate CFG
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Postgres AMAZON EC2 -->
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://localhost:5432/base</property>
<property name="connection.username">postgres</property>
<property name="connection.password">mySuperPassword</property>
<property name="current_session_context_class">thread</property>
<property name="hibernate.connection.pool_size">5</property>
<property name="show_sql">false</property>
<property name="format_sql">false</property>
<!--
********************************************************************
C3P0
Documentação: http://www.mchange.com/projects/c3p0/#maxIdleTime
********************************************************************
-->
<!-- Numero maximo de conexoes que o c3p0 ira manter, caso chege a esse numero as conexoes começam a travar se chamar um session.save(obj)
por exemplo trava aguardando uma conexao ser liberada, qntd padrao 15 -->
<property name="hibernate.c3p0.max_size">300</property>
<!-- Numero minimo de conexoes que o c3p0 ira manter, caso nao exista nenhuma transacao sendo realizada ainda assim essa quantidade
de conexoes estarao sendo realizadas e disponiveis para uso (<idle>), qntd padrao 3 -->
<property name="hibernate.c3p0.min_size">5</property>
<!-- Tempo (em milliseconds ) que uma conexao pode permanecer sem uso antes de ser descartada, se tiver em transacao a conexao
nao é descartada, qntd padrao 0 (nunca expira) -->
<property name="hibernate.c3p0.timeout">5</property>
<!-- Verifica nesse periodo de tempo (em milliseconds) se há alguma conexão <idle>, se tiver em transacao a conexao
nao é descartada, qntd padrao 0
-->
<property name="hibernate.c3p0.idle_test_period">5</property>
<!-- Controla o numero total de statements em cache global do c3p0, se definido deve ser um valor grande pois cada conexão requer
um statement, qntd padrao 0 (desativa) -->
<property name="hibernate.c3p0.max_statements">10000</property>
<!-- Numero de conexoes que o c3p0 tentara adquirir quando o numero de conexoes atingir o valor minimo (min_size), qntd padrao 3 -->
<property name="hibernate.c3p0.acquire_increment">10</property>
<property name="hibernate.c3p0.preferredTestQuery">select 1;</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<!-- Mapeamento das classes -->
<mapping class="com.levymoreira.entitys.MyLittleClass"/>
</session-factory>
</hibernate-configuration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment