tomcat+oracle串連池

標籤：io   os   ar   java   sp   檔案   on   cti   ad   

tomcat 5.5.23 
oracle 10g 

全域配置 
一.tomcat目錄\common\lib下添加包ojdbc14.jar. 

二.tomcat目錄\conf\server.xml的<GlobalNamingResources>標籤中插入 
oracle的串連參數: 
<Resource name="jdbc/oracle" 
         type="javax.sql.DataSource"         
         driverClassName="oracle.jdbc.driver.OracleDriver" 
         maxIdle="10" 
         maxWait="5000" 
         maxActive="20" 
         username="onepiece" 
password="12345" 
         url="jdbc:oracle:thin:@localhost:1521:orcl" 
         /> 
(name為jdbc/oracle後面還要用到) 

三.tomcat目錄\Catalina\localhost的web設定檔如hello.xml, 
原來為: 
<Context path="hello" docBase="D:\workspace\HelloOracle\web" reloadable="true" 
         privileged="true" antiResourceLocking="false" antiJARLocking="false"> 
</Context> 
改為 
<Context path="hello" docBase="D:\workspace\HelloOracle\web" reloadable="true" 
         privileged="true" antiResourceLocking="false" antiJARLocking="false"> 
<ResourceLink global="jdbc/oracle" name="jdbc/oracle" type="javax.sql.DataSource"/> 
</Context> 
即加入: 
<ResourceLink global="jdbc/oracle" name="jdbc/oracle" type="javax.sql.DataSource"/> 

四.應用(注意名字jdbc/oracle): 
InitialContext icont = new InitialContext(); 
DataSource dataSource = (DataSource) icont.lookup("java:comp/env/jdbc/oracle"); 
conn = dataSource.getConnection();
即可以擷取串連了 

局部配置(只有hello application可以應用) 
一.同上第一步 
二.見上第三步,但改的不一樣 
原來為: 
<Context path="hello" docBase="D:\workspace\HelloOracle\web" reloadable="true" 
         privileged="true" antiResourceLocking="false" antiJARLocking="false" /> 
改為 
<Context path="hello" docBase="D:\workspace\HelloOracle\web" reloadable="true" 
         privileged="true" antiResourceLocking="false" antiJARLocking="false"> 

<Resource name="jdbc/oracle" 
         type="javax.sql.DataSource"         
         driverClassName="oracle.jdbc.driver.OracleDriver" 
         maxIdle="10" 
         maxWait="5000" 
         maxActive="20" 
         username="onepiece" 
password="12345" 
         url="jdbc:oracle:thin:@localhost:1521:orcl" 
         /> 
</Context> 

tomcat+oracle串連池