apache-tomcat中db2連接池配置.doc

db2在tomcat中連接池配置環(huán)境：xp Jdk：ibm-jdk Db2：8.1 Tomcat：5.5.251 下載tomcat和tomcat-admin/tomcat/tomcat-5/v5.5.25/bin/apache-tomcat-5.5.25.zip/tomcat/tomcat-5/v5.5.25/bin/apache-tomcat-5.5.25-admin.zip2 解壓到D:盤(pán)，解壓admin覆蓋即可3 拷db2驅(qū)動(dòng)到D:apache-tomcat-5.5.25commonlib目錄，db2java.zip，db2jcc.jar，db2jcc_license_cu.jar。db2java.zip改為db2java.jar。4. 環(huán)境變量：java_homeD:ibm_jdk5. D:apache-tomcat-5.5.25conftomcat-users.xml 添加： 6http:/localhost:8080/admin/ 用戶(hù)名：admin ，密碼：manager 7. 成功后，點(diǎn)ResourcesData Sources選擇Data Source Actions中的Create New Data Source選項(xiàng)如下：JNDI Name：jdbc/lcptdbData Source URL：jdbc:db2:/localhost:端口/數(shù)據(jù)庫(kù)名字JDBC Driver Class:：com.ibm.db2.jcc.DB2DriverUser Name:：用戶(hù)名Password：密碼Max. Active Connections：4，默認(rèn)的Max. Idle Connections：2，默認(rèn)的Max. Wait for Connection：5000，默認(rèn)的Validation Query：，默認(rèn)空8. D:apache-tomcat-5.5.25conf context.xml內(nèi)容為： WEB-INF/web.xml 9. 在D:apache-tomcat-5.5.25conf web.xml在web-app中添加內(nèi)容如下：testjdbc/lcptdbjavax.sql.DataSourceContainer要注意這兩個(gè)xml文件要和連接池中相關(guān)項(xiàng)匹配。10. 重新啟動(dòng)tomcat，選擇Tomcat ServerService (Catalina)Host (localhost)Context (/)ResourcesData Sources，將在右側(cè)Data Sources 處看到了新建的數(shù)據(jù)源：JNDI Name JDBC Driver Class jdbc/lcptdb com.ibm.db2.jcc.DB2Driver 測(cè)試jsp放入：D:apache-tomcat-5.5.25webappsROOT testPool.jsp.內(nèi)容如下： base href= My JSP testPool.jsp starting page !- - This is my JSP page. % Connection conn=null; Context initCtx=new InitialContext(); Context ctx=(Context)initCtx.lookup(java:comp/env); javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup(jdbc/lcptdb); conn=ds.getConnection(); Statement stmt=conn.createStatement(); PreparedStatement ps=conn.prepareStatement(select * from 表名); ResultSet rs=ps.executeQuery(); whil