c3p0连接数据库失败No suitable driver
来源:互联网 发布:java编写杨辉三角 编辑:程序博客网 时间:2024/05/16 18:56
c3p0连接SQL 2005数据库报错No suitable driver,是url错误导致
这是jdbc连接数据库时配置
drivers=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1434;DatabaseName\=db_news2
这是c3p0连接数据库配置
dataSource.setJdbcUrl( “jdbc:sqlserver://localhost:1434; DatabaseName=db_news2”);
dataSource.setDriverClass( “com.microsoft.sqlserver.jdbc.SQLServerDriver”);
其中url不同
以下摘自互联网
测试代码
package database;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.beans.PropertyVetoException;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class SQLDB{
private static SQLDB dbPool;
private ComboPooledDataSource dataSource;
static {
dbPool=new SQLDB();
}
public SQLDB(){
try {
dataSource=new ComboPooledDataSource();
dataSource.setUser( “sa”);
dataSource.setPassword( “sa”);
dataSource.setJdbcUrl( “jdbc:sqlserver://localhost:1434; DatabaseName=db_news2”);
dataSource.setDriverClass( “com.microsoft.sqlserver.jdbc.SQLServerDriver”);
dataSource.setInitialPoolSize(2);
dataSource.setMinPoolSize(1);
dataSource.setMaxPoolSize(10);
dataSource.setMaxStatements(50);
dataSource.setMaxIdleTime(60);
} catch (PropertyVetoException e) {
throw new RuntimeException(e);
}
}
public final static SQLDB getInstance(){
System.out.println(“3”);
return dbPool;
}
public final Connection getConnection() {
try {
System.out.println(“4”);
return dataSource.getConnection();
} catch (SQLException e) {
throw new RuntimeException( “无法从数据源获取连接 “,e);
}
}
public static void main(String[] args) throws SQLException {
Connection con = null;
try { System.out.println(“1”);
con = SQLDB.getInstance().getConnection();
System.out.println(“2”);
ResultSet rs = con.createStatement().executeQuery(“select * from newsusr”);
if(rs.next())
{
System.out.println(“执行结果”);
System.out.println(rs.getString(“userName”));
}
System.out.println(con);
} catch (Exception e){
} finally {
if (con != null)
con.close();
}
}
}
- c3p0连接数据库失败No suitable driver
- 关于用DB2v8.2驱动连接数据库出现 No suitable driver错误的解决方案
- Weka连接数据库出现No suitable driver found for jdbc:mysql://localhost/dbname
- proxool: No suitable driver
- No suitable driver”异常
- no suitable Driver
- DBD: No suitable driver
- p6spy no suitable driver
- java连接mysql :No Suitable Driver Found For Jdbc 解决方法
- weka连接mysql错误:no suitable driver found for jdbc
- jsp连接oracle数据库时报错: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orcl,解决方法
- JDeveloper 配置 No suitable driver
- 数据库(not suitable driver)异常
- jdbc连接SQLServer2005出现 NO suitable driver问题的一个原因
- java连接sql server 2005的问题 java.sql.SQLException: No suitable driver
- jdbc连接sql server2008 No suitable driver found for jdbc:sqlserver的解决办法
- jdbc连接oracle报错No suitable driver found for jdbc
- 使用 JDBC 连接 Hive(ClassNotFoundException、No suitable driver found、Could not open client transport wit)
- POJ 1946 DP
- Android Fragment应用及原理
- Github学习之EasyTabs打造绚丽TabLayout+ViewPager滑动动画集合库
- Codeforces Round #353 (Div. 2) C 思维
- 引导页圆点的滑动两种实现方式
- c3p0连接数据库失败No suitable driver
- 计科二班 安为 150809113 作业
- Node.js 回调函数
- 《UNIX环境高级编程》源码配置——apue.3e 安装
- hive-行转列和列转行
- 14_XML DOM 获取节点值
- 数据结构 - 二叉树的构建 (分冶)
- 15_XML DOM 改变节点值
- UIlabel详解