Tomcat连接池配置

字体大小: 中小 标准 ->行高大小: 标准
MYySQL:
 
<Resource auth="Container" name="jdbc/name" type="javax.sql.DataSource"   
 driverClassName="com.mysql.jdbc.Driver" maxIdle="50" maxWait="5000"   
 username="root" password=""   
 url="jdbc:mysql://127.0.0.1:3306/dbname"   
 removeAbandoned="true" removeAbandonedTimeout="60" maxActive="100" />  

MSSQLSERVER: 
<Resource auth="Container" name="jdbc/name" type="javax.sql.DataSource"   
 driverClassName="net.sourceforge.jtds.jdbc.Driver" maxIdle="50" maxWait="5000"   
 username="sa" password=""   
 url="jdbc:jtds:sqlserver://127.0.0.1:1433/dbname;tds=8.0;lastupdatecount=true"   
 removeAbandoned="true" removeAbandonedTimeout="60" maxActive="100" />  

Oracle: 
<Resource name="jdbc/name" auth="Container" type="javax.sql.DataSource"   
 driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="50" maxWait="5000"   
username="user" password=""   
 url="jdbc:oracle:thin:@127.0.0.1:1521:Gname"   
 removeAbandoned="true" removeAbandonedTimeout="60" maxActive="100"/>  

此文章由 http://www.ositren.com 收集整理 ,地址为: http://www.ositren.com/htmls/68248.html