Mysql Jdbc数据库连接池配置_MySQL

<pre style="font-size: 12px; margin: 0em; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: #fbfbfb"><?xml version="1.0" encoding="UTF-8"?>

<context path="/appName" docbase="appName"><pre style="font-size: 12px; margin: 0em; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: #fbfbfb">  debug="5" crossContext="true" reloadable="false"  

  cachingAllowed="true" cacheMaxSize="20480"  

  cacheTTL="10000">  

  <resource name="jdbc/mysql" auth="Container" removeabandoned="true"><pre style="font-size: 12px; margin: 0em; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: #fbfbfb">  removeAbandonedTimeout="60" logAbandoned="true"  

  type="javax.sql.DataSource" maxActive="50" maxIdle="10"  

  maxWait="10000" username="root" password="root"  

  driverClassName="com.mysql.jdbc.Driver"  

  url="jdbc:mysql://localhost:3306/dbname?autoReconnect=true" />  

<pre style="font-size: 12px; margin: 0em; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: #fbfbfb"><resource-ref></resource-ref>

	<description>DB Connection </description>

	<res-ref-name>jdbc/mysql</res-ref-name>

	<res-type>javax.sql.DataSource</res-type>

	<res-auth>Container</res-auth>

<pre style="font-size: 12px; margin: 0em; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: #fbfbfb">Context context = new InitialContext();

DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/mysql");

conn = ds.getConnection();