hibernate配置数据源

1.tomcat中配置数据源

<GlobalNamingResources>
  <Resource name="jdbc/testds"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@192.168.1.154:1526:test"
            username="test"
            password="test"
            maxIdle="2"
            maxWait="60000"
            maxActive="20"
            />
</GlobalNamingResources>

 

<Context path="/ticketnew" docBase="D:\test\workspace\ticket\web" debug="0" reloadable="true"> 
       	<ResourceLink name="jdbc/testds" global="jdbc/testds" type="javax.sql.DataSource"/>
</Context>

2.在hibernate.cfg.xml中配置

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
  <session-factory>
       
    <!-- 配置数据源 -->
    <property name="connection.datasource">java:comp/env/jdbc/testds</property>
    
    <!-- 指定连接池大小 -->
    <property name="connection.pool_size">5</property>
    
    <!-- 数据库类型 -->
    <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
		
		<!-- 是否显示SQL语句 -->
		<property name="hibernate.show_sql">true</property>
		
		<!-- 事务配置 -->
		<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
		
		<!-- 罗列HBM映射文件 -->
		<mapping resource="com/test/ticket/vo/Testvo.hbm.xml"/>
		
	</session-factory>
</hibernate-configuration>