WebSphere配置数据库连接池
websphere server.xml:
<library id="DB2JCC4Lib">
<fileset dir="C:/Users/IBM_ADMIN/Desktop/happy/HappyTogether/VehicleConnectWeb/WebContent/WEB-INF/lib" includes="db2jcc4.jar,db2jcc_license_cu.jar,db2jcc_license_cisuz.jar"/>
</library>
<jdbcDriver id="DB2DRIVER" libraryRef="DB2JCC4Lib"/>
<dataSource connectionSharing="MatchCurrentState" id="DB2DS" isolationLevel="TRANSACTION_READ_COMMITTED"
jdbcDriverRef="DB2DRIVER" jndiName="jdbc/db2" statementCacheSize="20" transactional="false">
<connectionManager agedTimeout="30m" connectionTimeout="10s" maxPoolSize="20" minPoolSize="5"/>
<properties.db2.jcc currentLockTimeout="30s" databaseName="dbname" password="password" portNumber="50000"
serverName="databaseServer" user="username"/>
</dataSource>
project java source:
public static Connection getConnection() {
Connection conn = null;
DataSource ds = null;
try
{
InitialContext ctx = new InitialContext();
ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/db2");
if(ds==null) return null;
conn = ds.getConnection();
conn.setAutoCommit(false);
}catch (Exception e){
e.printStackTrace();
}
return conn;
}