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>