在hiberante中的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">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="dialect">
org.hibernate.dialect.Oracle10gDialect
</property>
<!--加入下面这句代表数据源去找/market的-->
<property name="connection.datasource">java:comp/env/market</property>
<mapping resource="com/market/po/Bank.hbm.xml" />
<mapping resource="com/market/po/Account.hbm.xml" />
<mapping resource="com/market/po/Firm.hbm.xml" />
</session-factory>
</hibernate-configuration>
这样hibernate的配置文件就完成了。
然后我们去tomcat下面的conf\Catalina\localhost\下增加market.xml。
这里我们需要注意的是,tomcat6和其以前的数据源配置文件是不同的。依次列出:
tomcat6:
<?xml version='1.0' encoding='utf-8'?>
<!--下面的所有"market"换成自己的工程名-->
<Context docBase="market" path="/market" privileged="true" reloadable="true" workDir="work/Catalina/localhost/market">
<!--下面的resource需要修改下name、username、password、url。如果使用的不是oracle数据库,修改下dirverClassName-->
<Resource name="market" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="study_market" password="password" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@172.16.2.41:1521:gnnt"/>
</Context>
tomcat6以下(tomcat5,4..):
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="market" path="/market" privileged="true" reloadable="true" workDir="work/Catalina/localhost/market">
<Resource name="market" type="javax.sql.DataSource"/>
<ResourceParams name="market">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>1500</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@172.16.2.41:1521:gnnt</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>study_market</value>
</parameter>
</ResourceParams>
</Context>