db2在Jboss中的配置

1.修改db2-ds中的数据库配置信息，然后复制到Jboss 目录下D:\developer\jboss-4.0.2\server\default\deploy
<datasources>
<local-tx-datasource>
<jndi-name>DB2DS</jndi-name>
<connection-url>jdbc:db2://127.0.0.1:50000/dbtest</connection-url>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<user-name>llf</user-name>
<password>llflove</password>
<min-pool-size>10</min-pool-size>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
<metadata>
<type-mapping>DB2</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>

2.那么 hibernate.cfg.xml 中只需要配置
<property name="connection.datasource">java:DB2DS</property>
<property name="dialect">
org.hibernate.dialect.DB2Dialect
</property>
<property name="show_sql">true</property>
Java:DB2DS 与 <jndi-name>DB2DS</jndi-name>中的DB2DS相映射。
3.把DB2的连接驱动复制到 Jboss 目录下的 D:\developer\jboss-4.0.2\server\default\lib