Tomcat中配置c3p0
我喜欢在${TOMCAT_HOME}\conf\Catalina\localhost中添加一个xml文件来配置。<context><resource><context> </context></resource></context>xml 代码
[*]xml version="1.0" encoding="UTF-8"?>
[*]<Context
[*] path="/corpcs"
[*] docBase="D:\eclipse-workspace\corpcs\WebContent"
[*] reloadable="true"
[*] workDir="D:\eclipse-workspace\corpcs\WebContent\work">
[*]
[*]
[*] <Resource
[*] auth="Container"
[*] name="jdbc/corpcs"
[*] description="DB Connection"
[*] factory="org.apache.naming.factory.BeanFactory"
[*] type="com.mchange.v2.c3p0.ComboPooledDataSource"
[*] driverClass="oracle.jdbc.driver.OracleDriver"
[*] user="portal"
[*] password="portal"
[*] jdbcUrl="jdbc:oracle:thin:@192.168.91.41:1521:dev2sz"
[*] maxPoolSize="10000"
[*] minPoolSize="100"
[*] acquireIncrement="1" />
[*]
[*]
[*]<!---->Context>
修改WEB-INF\web.xml文件，在<o:p></o:p>其中添加JNDI引用
xml 代码
[*]<resource-ref>
[*] <res-ref-name>jdbc/OracleDB<!---->res-ref-name>
[*] <res-type>javax.sql.DataSource<!---->res-type>
[*] <res-auth>Container<!---->res-auth>
[*] <res-sharing-scope>Shareable<!---->res-sharing-scope>
[*]<!---->resource-ref>
测试 jndi_oracle.jsp
java 代码
[*]String jndi = "java:comp/env/jdbc/corpcs";
[*]
[*]DataSource ds = null;
[*]
[*]try
[*]{
[*] //初始化上下文，可以读配置文件如：web.xml
[*] Context initCtx = new InitialContext();
[*] if(initCtx==null)
[*] throw new Exception("Initial Failed!");
[*] Context ctx=(Context)initCtx.lookup("java:comp/env");
[*] if(ctx!=null)
[*] ds = (DataSource)ctx.lookup("jdbc/corpcs");
[*] if(ds==null)
[*] throw new Exception("Look up DataSource Failed!");
[*]}
[*]catch(Exception e)
[*]{
[*] System.out.println(e.getMessage());
[*]}
[*]
[*]System.out.println(ds);
页:
[1]