Tomcat 6 中配置数据源

hibernate.cfg.xml:

 

 <property name="connection.datasource">java:comp/env/jdbc/DBname</property>
 
 <!--property name="dialect">org.hibernate.dialect.Oracle9Dialect</property-->
 <!--property name="dialect">org.hibernate.dialect.InformixDialect</property-->
 <!--property name="dialect">org.hibernate.dialect.SQLServerDialect</property-->
 <!--property name="dialect">org.hibernate.dialect.MySQLDialect</property-->
 <property name="dialect">org.hibernate.dialect.DB2Dialect</property>
 <property name="hibernate.show_sql">true</property>

 

 

 

web.xml:

 

 <resource-ref>
  <res-ref-name>jdbc/DBname</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

 

 

 

Tomcat   server.xml

 

      <Resource
      name="jdbc/DBname"
      type="javax.sql.DataSource"
      driverClassName="com.ibm.db2.jcc.DB2Driver"
      password="123"
      maxIdle="12"
      maxWait="50"
      username="ADMINISTRATOR"
      url="jdbc:db2://localhost:50000/ssh"
      maxActive="6"/>

 

 

  <Context path="/ssh" docBase="D:/Program file/Myeclipse5.5/MyWorkspace/S2SH/WebRoot">
    <ResourceLink name="jdbc/DBname" global="jdbc/DBname" type="javax.sql.DataSourcer"/>
  </Context>