WebSphere配置数据库连接池

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;
}