db2在Jboss中的配置

llflove1988

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