如何在tomcat容器外测试MySQL+DBCP呢，请详细配置讲解，谢谢

Question

如何在tomcat容器外测试MySQL+DBCP呢，请详细配置讲解，谢谢

我的META-INF下的context.xml
[code="java"]<?xml version='1.0' encoding='UTF-8'?>

driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/db?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8"
username="root" password="root" maxActive="100" maxIdle="30" maxWait="-1"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
removeAbandoned="true" removeAbandonedTimeout="300" logAbandoned="true">


[/code]

连接方法
[code="java"]public Connection getConnection() throws SQLException
{
if (conn == null)
{
synchronized (this)
{
if (conn == null)
{
DBProperty dbProperty = new DBProperty();
//DbUtils.loadDriver(dbProperty.getClassName());

                try
                {
                    InitialContext ctx = new InitialContext();
                    DataSource ds = (DataSource)ctx.lookup(dbProperty.getDatasource());
                    if (ds != null)
                        conn = (Connection) ds.getConnection();
                } catch(NamingException e)
                {
                    System.out.println("JNDI数据源加载失败!");
                    e.printStackTrace();
                } catch(SQLException e)
                {
                    System.err.println("获取数据库连接发生异常!");
                    System.out.println(e.getMessage());
                }
            }
        }
    }
    return conn;
}[/code]

这个方法只能能在容器内实现，不知怎么在容器外，另外我用一个JSP测试时出现以下问题，不知如何解决
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@d69cff)
LogAbandoned: true
RemoveAbandoned: true
RemoveAbandonedTimeout: 300
2009-9-2 22:29:17 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.ClassCastException: org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper cannot be cast to com.mysql.jdbc.Connection
at db.DBUtil.getConnection(DBUtil.java:42)
at db.DBUtil.select(DBUtil.java:65)
at org.apache.jsp.show_jsp._jspService(show_jsp.java:64)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:389)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527)
at java.lang.Thread.run(Unknown Source)

[b]问题补充：[/b]
主要我想测试下容器是否好使

Answer 1

直接写在程序里就好了 不需要用容器
[code="java"]
public class Conn {
public static String DRIVER = "";
public static String CONNSTR = "";
public static String USERNAME = "";
public static String PASSWORD = "";
public static String MAXACTIVE = "";
public static String MAXIDLE = "";
public static String MAXWAIT="";
private static DataSource DS;
public static Connection getConn() throws SQLException,
InstantiationException, IllegalAccessException,
ClassNotFoundException, IOException, PropertyVetoException {
try{
Connection con = DS.getConnection();
return con;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
public static void initDS() {

BasicDataSource ds = new BasicDataSource();

ds.setDriverClassName(DRIVER);

ds.setUsername(USERNAME);

ds.setPassword(PASSWORD);

ds.setUrl(CONNSTR);

ds.setMaxActive(Integer.parseInt(MAXACTIVE));

ds.setMaxIdle(Integer.parseInt(MAXIDLE));

ds.setMaxWait(Integer.parseInt(MAXWAIT));

DS = ds;
}

public static void datasourceDistory() throws SQLException{
BasicDataSource bds = (BasicDataSource) DS;

bds.close();
}
}
[/code]