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

db2在tomcat中连接池配置环境：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:盘，解压admin覆盖即可3 拷db2驱动到D:apache-tomcat-5.5.25commonlib目录，db2java.zip，db2jcc.jar，db2jcc_license_cu.jar。db2java.zip改为db2java.jar。4. 环境变量：java_homeD:ibm_jdk5. D:apache-tomcat-5.5.25conftomcat-users.xml 添加： 6http:/localhost:8080/admin/ 用户名：admin ，密码：manager 7. 成功后，点ResourcesData Sources选择Data Source Actions中的Create New Data Source选项如下：JNDI Name：jdbc/lcptdbData Source URL：jdbc:db2:/localhost:端口/数据库名字JDBC Driver Class:：com.ibm.db2.jcc.DB2DriverUser Name:：用户名Password：密码Max. Active Connections：4，默认的Max. Idle Connections：2，默认的Max. Wait for Connection：5000，默认的Validation Query：，默认空8. D:apache-tomcat-5.5.25conf context.xml内容为： WEB-INF/web.xml 9. 在D:apache-tomcat-5.5.25conf web.xml在web-app中添加内容如下：testjdbc/lcptdbjavax.sql.DataSourceContainer要注意这两个xml文件要和连接池中相关项匹配。10. 重新启动tomcat，选择Tomcat ServerService (Catalina)Host (localhost)Context (/)ResourcesData Sources，将在右侧Data Sources 处看到了新建的数据源：JNDI Name JDBC Driver Class jdbc/lcptdb com.ibm.db2.jcc.DB2Driver 测试jsp放入：D:apache-tomcat-5.5.25webappsROOT testPool.jsp.内容如下： 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