Hibernate高级配置

1.配置数据库连接池

1.1.使用默认的数据库连接池

hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://localhost:3306/sampledb
hibernate.connection.username = root
hibernate.connection.password = 1234
hibernate.show_sql = true

1.2.使用C3P0连接池

hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://localhost:3306/sampledb
hibernate.connection.username = root
hibernate.connection.password = 1234
hibernate.show_sql = true

hibernate.c3p0.min_size = 5

hibernate.c3p0.max_size = 20

hibernate.c3p0.timeout = 300

hibernate.c3p0.max_statements = 50

hibernate.c3p0.idle_test_period = 3000

1.3.从容器中获得数据源

<Resource name="jdbc/SAMPLEDB"

    auth="Container"

    type="javax.sql.DataSource"  

    maxActive="100"

    maxIdle="30"

    maxWait="10000"

    username="root"

    password="1234"

    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/SAMPLEDB?autoReconnect=true" />

hibernate.dialect = org.hibernate.dialect.MySQLDialect

hibernate.connection.datasource = java:comp/env/jdbc/SAMPLEDB

hibernate.show_sql = true

2.把SessionFactory与JNDI绑定

hibernate.dialect = org.hibernate.dialect.MySQLDialect

hibernate.connection.datasource = java:comp/env/jdbc/SAMPLEDB

hibernate.transaction.factory_class = org.hibernate.transaction.JTATransactionFactory

hibernate.transaction.manager_lookup_class = org.hibernate.transaction.JBossTransactionManagerLookup

hibernate.session_factory_name = java:hibernate/HibernateFactory

hibernate.show_sql = true

使用JNDI访问和JNDI绑定的SessionFactory实例：

Context ctx = new InitialContext();

String jndiName = "java:hibernate/HibernateFactory";

SessionFactory sessionFactory = (SessionFactory)ctx.lookup(jndiName);

Session session = sessionFactory .openSession();

...