Tomcat 6 中配置数据源

wlbbswl

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>