tomcat连接池配置
Tomcat文档说明 http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Tomcat4的数据库连接池配置 http://www.7880.com/Info/Article-37ebcbc0-2.html
tomcat连接池的配置与使用(原创)数据库mysql http://www.7880.com/Info/Article-37f05fa0.html简单过程:1.配置server.xml,在对应位置添加如下信息(楼主自己作相应修改)。在此之前应该把classes2.jar复制到%tomcat_home%\common\lib\目录下
<Context path="/OracleDBP" docBase="OracleDBP"
debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.0.193:1521:oradb</value>
</parameter>
<parameter>
<name>username</name>
<value>gxtax</value>
</parameter>
<parameter>
<name>password</name>
<value>gxtax</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams></Context>2.修改web.xml文件,内容如下: <?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>3.测试代码(jsp)
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.io.*,javax.naming.*,javax.sql.*,java.sql.*"%><html>
<head>
<title>
</title>
</head>
<body bgcolor="#ffffff">
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
System.out.println(conn);
if(conn != null)
conn.close();
%>
</body>
<table><a href = ">下载</A></table>
</html>
Tomcat文档说明 http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Tomcat4的数据库连接池配置 http://www.7880.com/Info/Article-37ebcbc0-2.html
tomcat连接池的配置与使用(原创)数据库mysql http://www.7880.com/Info/Article-37f05fa0.html简单过程:1.配置server.xml,在对应位置添加如下信息(楼主自己作相应修改)。在此之前应该把classes2.jar复制到%tomcat_home%\common\lib\目录下
<Context path="/OracleDBP" docBase="OracleDBP"
debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.0.193:1521:oradb</value>
</parameter>
<parameter>
<name>username</name>
<value>gxtax</value>
</parameter>
<parameter>
<name>password</name>
<value>gxtax</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams></Context>2.修改web.xml文件,内容如下: <?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>3.测试代码(jsp)
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.io.*,javax.naming.*,javax.sql.*,java.sql.*"%><html>
<head>
<title>
</title>
</head>
<body bgcolor="#ffffff">
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
System.out.println(conn);
if(conn != null)
conn.close();
%>
</body>
<table><a href = ">下载</A></table>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货