我用proxool做连接池的时候出现异常

错误信息

2008-1-24 11:46:04 org.logicalcobwebs.proxool.ProxoolFacade registerConnectionPool
信息: Proxool 0.9.0RC3 (10-Jan-2007 01:38)
2008-1-24 11:46:04 org.logicalcobwebs.proxool.ProxoolDriver connect
严重: Problem
org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'DBPool'
    at org.logicalcobwebs.proxool.ConnectionPoolDefinition.doChange(ConnectionPoolDefinition.java:250)
    at org.logicalcobwebs.proxool.ConnectionPoolDefinition.<init>(ConnectionPoolDefinition.java:147)
    at org.logicalcobwebs.proxool.ProxoolFacade.registerConnectionPool(ProxoolFacade.java:96)
    at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:77)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at selfservice.PoolManager.getConnection(PoolManager.java:30)
    at selfservice.PoolManager.getQuery(PoolManager.java:99)
    at selfservice.PoolManager.main(PoolManager.java:121)
java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'DBPool'
    at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:109)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at selfservice.PoolManager.getConnection(PoolManager.java:30)
    at selfservice.PoolManager.getQuery(PoolManager.java:99)
    at selfservice.PoolManager.main(PoolManager.java:121)

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <servlet>
        <servlet-name>ServletConfigurator</servlet-name>
        <servlet-class>
            org.logicalcobwebs.proxool.configuration.ServletConfigurator
        </servlet-class>
        <init-param>
            <param-name>xmlFile</param-name>
            <param-value>WEB-INF/proxool.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet>
        <servlet-name>Admin</servlet-name>
        <servlet-class>
            org.logicalcobwebs.proxool.admin.servlet.AdminServlet
        </servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>Admin</servlet-name>
        <url-pattern>/admin</url-pattern>
    </servlet-mapping>
</web-app>

proxool.xml

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
    <proxool>
        <alias>DBPool</alias>
        <driver-url>
            jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test
        </driver-url>
        <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
        <driver-properties>
            <property name="user" value="sa" />
            <property name="password" value="1" />
        </driver-properties>
        <house-keeping-sleep-time>90000</house-keeping-sleep-time>
        <maximum-new-connections>150</maximum-new-connections>
        <prototype-count>3</prototype-count>
        <maximum-connection-count>100</maximum-connection-count>
        <minimum-connection-count>3</minimum-connection-count>
    </proxool>
</something-else-entirely>

类文件

package selfservice;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.ProxoolFacade;
import org.logicalcobwebs.proxool.admin.SnapshotIF;

public class PoolManager {

    private static int activeCount = 0;

    public PoolManager() {

    }

    /**
     * 获取连接 getConnection
     * 
     * @param name
     * @return
     */
    public Connection getConnection() {
        try {
            Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");// proxool驱动类
            Connection conn = DriverManager.getConnection("proxool.DBPool");
            // 此处的DBPool是在proxool.xml中配置的连接池别名
            showSnapshotInfo();

            return conn;
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return null;
    }

    /**
     * 此方法可以得到连接池的信息 showSnapshotInfo
     */
    private void showSnapshotInfo() {
        try {
            SnapshotIF snapshot = ProxoolFacade.getSnapshot("DBPool", true);
            int curActiveCount = snapshot.getActiveConnectionCount();// 获得活动连接数
            int availableCount = snapshot.getAvailableConnectionCount();// 获得可得到的连接数
            int maxCount = snapshot.getMaximumConnectionCount();// 获得总连接数
            if (curActiveCount != activeCount)// 当活动连接数变化时输出的信息
            {
                System.out.println("活动连接数:" + curActiveCount
                        + "(active)  可得到的连接数:" + availableCount
                        + "(available)  总连接数:" + maxCount + "(max)");
                activeCount = curActiveCount;
            }
        } catch (ProxoolException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取连接 getConnection
     * 
     * @param name
     * @return
     */
    public Connection getConnection(String name) {
        return getConnection();
    }

    /**
     * 释放连接 freeConnection
     * 
     * @param conn
     */
    public void freeConnection(Connection conn) {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 释放连接 freeConnection
     * 
     * @param name
     * @param con
     */
    public void freeConnection(String name, Connection con) {
        freeConnection(con);
    }

    public void getQuery() {
        try {
            Connection conn = getConnection();
            if (conn != null) {
                Statement statement = conn.createStatement();
                ResultSet rs = statement
                        .executeQuery("select * from t_emp");
                int c = rs.getMetaData().getColumnCount();
                while (rs.next()) {
                    System.out.println();
                    for (int i = 1; i <= c; i++) {
                        System.out.print(rs.getObject(i));
                    }
                }
                rs.close();
            }
            freeConnection(conn);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    
    public static void main(String[] args) {
        PoolManager manager = new PoolManager();
        manager.getQuery();
    }
}

这样写有什么问题吗？我弄不明白为什么会出错，难道是还要配置什么吗？

评论

9 楼 marsjin 2008-10-09  

你查看一下是否在初始化连接池之前使用了连接池呢？
可以用连接池的检测代码看一下是否成功创建连接池

8 楼 wt8414 2008-07-16  

你这很明显是直接运行PoolManager.main

7 楼 zhuyx808 2008-07-11  

Attempt to refer to a unregistered pool by its alias

这里说的很明确了

6 楼 FAT0708 2008-06-23  

用web调用，就是用servlet或jsp。

5 楼 zphab 2008-06-23  

icefire 写道

楼主难道是直接运行的PoolManager.main？？？？？？？

如果是直接运行main方法，那肯定是获取不了连接的，因为web.xml和proxool.xml文件都没有加载。

4 楼 icefire 2008-05-05  

楼主难道是直接运行的PoolManager.main？？？？？？？

3 楼 tigerbrother 2008-05-05  

Note that when using this xml solution, you must download a JAXP compliant XML parser. Here I will use Xerces, download the zip file, unzip it and put all jar files into your web application’s WEB-INF/lib directory.

可以看看这个链接，对你可能有启发。
http://www.memezilla.com/2005/05/18/proxool-in-practice

2 楼 tigerbrother 2008-05-05  

我看了你的帖子感觉配置都正确。建议用以下方法来排错：
首先修改web.xml, 不要用proxool.xml,
试用一下proxool.properties

<servlet>
        <servlet-name>ServletConfigurator</servlet-name>
        <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
        <init-param>
            <param-name>propertyFile</param-name>
            <param-value>WEB-INF/proxool.properties</param-value>
        </init-param>
  </servlet>


proxool.properties 文件内容

jdbc-0.proxool.alias=conn1
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/myContent
jdbc-0.user=HaoLing
jdbc-0.password=HL



jdbc-0.proxool.maximum-connection-count=40
jdbc-0.proxool.prototype-count=4



jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG

如果还是出错，请仔细检查你的web.xml,肯定是格式错误，无法找到ServletConfigurator.

因为我不太上论坛的，如果还是不行，可以给我发邮件联系  [e-mail]

1 楼 hxj1225 2008-01-24  

没有人知道吗？