mysql 忘记dbname_如何修复：“没有合适的驱动程序找到的jdbc：mysql：// localhost/dbname”错误时使用池？...

我试图创建一个连接到我的数据库，当我把测试我的代码使用main方法，它无缝工作。但是，当尝试通过Tomcat 7访问它时，它失败，错误：

No suitable driver found for jdbc:mysql://localhost/dbname.

我使用pooling。我在WEB-INF / lib和.classpath中插入mysql连接器(5.1.15)，dbcp(1.4)和pool(1.4.5)库。我使用Eclipse IDE。我的数据库驱动程序的代码是：

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import org.apache.tomcat.dbcp.dbcp.ConnectionFactory;

import org.apache.tomcat.dbcp.dbcp.DriverManagerConnectionFactory;

import org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory;

import org.apache.tomcat.dbcp.dbcp.PoolingDriver;

import org.apache.tomcat.dbcp.pool.impl.GenericObjectPool;

public class DatabaseConnector {

public static String DB_URI = "jdbc:mysql://localhost/dbname";

public static String DB_USER = "test";

public static String DB_PASS = "password";

// Singleton instance

protected static DatabaseConnector _instance;

protected String _uri;

protected String _username;

protected String _password;

/**

* Singleton, so no public constructor

*/

protected DatabaseConnector(String uri, String username, String password) {

_uri = uri;

_username = username;

_password = password;

GenericObjectPool connectionPool = new GenericObjectPool(null);

ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(

_uri, _username, _password);

PoolableConnectionFactory poolableConnectionFactory =

new PoolableConnectionFactory(connectionFactory, connectionPool,

null, null, false, true);

PoolingDriver driver = new PoolingDriver();

driver.registerPool("test", connectionPool);

}

/**

* Returns the singleton instance

*/

public static DatabaseConnector getInstance() {

if (_instance == null) {

_instance = new DatabaseConnector(DB_URI, DB_USER, DB_PASS);

}

return _instance;

}

/**

* Returns a connection to the database

*/

public Connection getConnection() {

Connection con = null;

try {

con = DriverManager.getConnection("jdbc:apache:commons:dbcp:test");

} catch (SQLException e) {

throw new RuntimeException(e);

}

return con;

}

}

我的堆栈跟踪的开始：

Apr 5, 2011 9:49:14 PM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [Login] in context with path [/Project]

threw exception

java.lang.RuntimeException: java.sql.SQLException:

No suitable driver found for jdbc:mysql://localhost/dbname

是什么原因导致此错误？