驗證Linux配置Tomcat資料來源(DB2)時,資料來源的配置如下:
conf\server.xml:
<GlobalNamingResources>
<!-- Test entry for demonstration purposes -->
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users -->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource driverClassName="com.ibm.db2.jcc.DB2Driver" maxActive="4" maxIdle="2" maxWait="5000" name="DefaultDataSource" password="123456" type="javax.sql.DataSource" url="jdbc:db2://127.0.0.1:50000/zxdb" username="db2admin"/>
</GlobalNamingResources>
conf\context.xml:
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<ResourceLink global="DefaultDataSource" name="DefaultDataSource" type="javax.sql.DataSource"/>
</Context>
異常錯誤資訊如下:
Message: 沒有找到名稱為 ''{0}'' 的資料來源.(the datasource with
name 'default' cannot get connection!)
at
com.primeton.common.connection.impl.datasource.ext.UnconfirmedD
ataSource.getDataSource(UnconfirmedDataSource.java:83)
at
com.primeton.common.connection.impl.datasource.ext.UnconfirmedD
ataSource.getConnection(UnconfirmedDataSource.java:124)
將db2jcc.jar、db2jcc_license_cisuz.jar、db2jcc_license_cu.jar、jta.jar(解決java.lang.NoClassDefFoundError: javax/transaction/UserTransaction)
4個jar包,放到Tomcat的common\lib目錄下,然後重啟服務。