OSchina上说DBCP不好用,没有多线程?,tomcat7已经不再采用了。可是不管好坏,放在我面前了,我总得看看。但是,使用BasicDataSource,怎么看也没发现使用到池的感觉。close也就是把它自己给干掉。就我想的吧,获取,释放,获取。。 但不是close掉啊。
还好,看到SharedPoolDataSource了,让我有点感觉了。API上还给出了例子,很给力啊。
自己也Test一把。记录下来吧。就这样。
--
还好,看到SharedPoolDataSource了,让我有点感觉了。API上还给出了例子,很给力啊。
自己也Test一把。记录下来吧。就这样。
package com.wxg.dbcp;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS;
import org.apache.commons.dbcp.datasources.SharedPoolDataSource;
public class Pool
{
private static DataSource ds;
private static SharedPoolDataSource tds;
static
{
DriverAdapterCPDS cpds = new DriverAdapterCPDS();
try {
cpds.setDriver("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
cpds.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:ORCL");
cpds.setUser("kmuser");
cpds.setPassword("password");
tds = new SharedPoolDataSource();
tds.setConnectionPoolDataSource(cpds);
tds.setMaxActive(10);
tds.setMaxWait(50);
ds = tds;
}
public static Connection getConnection()
{
Connection conn = null;
try {
conn = ds.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static SharedPoolDataSource getSharedPoolDataSource(){
return tds;
}
public static DataSource getDataSource(){
return ds;
}
}
--
package com.wxg.dbcp;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Client {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = Pool.getConnection();
Statement st = null;
ResultSet rs = null;
String sql = "select count(*) from T_BO_EMPLOYEE";
System.out.println(Pool.getSharedPoolDataSource().getNumActive());
try {
st = conn.createStatement();
rs = st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(1));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(null != conn){
conn.close();
}
if(null != st){
st.close();
}
if(null != rs){
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
System.out.println(Pool.getSharedPoolDataSource().getNumActive());
}
}