Oracle Tomcat c3p0连接池配置

 

Oracle Tomcat c3p0连接池配置

把c3p0等包放入tomcat/lib/下

在tomcat/conf/下的server.xml web.xml context.xml中添加如下

web.xml:

DB Connection

jdbc/MwealthPool

javax.sql.DataSource

Container

server.xml:

context.xml:

新建类：

package com.soft136.kf.dao;

import java.sql.Connection;

import java.sql.SQLException;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.sql.DataSource;

public class DataBaseConnection {

private static DataBaseConnection dbPool;

private DataSource dataSource;

static {

dbPool = new DataBaseConnection();

}

public DataBaseConnection() {

try {

Context initCtx = new InitialContext();

if (initCtx == null)

throw new Exception("error");

Context ctx = (Context) initCtx.lookup("java:comp/env");

if (ctx != null)

dataSource = (DataSource) ctx.lookup("jdbc/MwealthPool");

if (dataSource == null)

throw new Exception("error");

} catch (Exception e) {

e.printStackTrace();

}

}

public final static DataBaseConnection getInstance() {

return dbPool;

}

public final Connection getConnection() {

try {

return dataSource.getConnection();

} catch (SQLException e) {

throw new RuntimeException("connection error ", e);

}

}

}

使用：

public OracleCachedRowSet countReMess() throws SQLException {

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

String sql = "SELECT count(*) FROM T_LOG t";

try {

conn = DataBaseConnection.getInstance().getConnection();

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

OracleCachedRowSet ocrs = new OracleCachedRowSet();

ocrs.populate(rs);

return ocrs;

} finally {

if (ps != null) {

ps.close();

}

if (conn != null) {

conn.close();

}

}

}