环境:SQLServer 2008 R2 + MyEclipse 6.5 + JDK 1.6.24
问题:Java通过JDBC连接SQLServer 2008,出现如下问题:ava.sql.SQLException: No suitable driver found forjdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=QQ。
解决:检查连接数据库时写的代码是否有问题。
代码如下:
package com.qq.client.db;
import java.sql.Connection;
import java.sql.DriverManager;
/**
* 连接数据库的类
* @since 1.0
* @author Wentasy
*
*/
public class ConnDB {
private Connection conn = null;
public Connection getConn(){
try {
//注意这串字符串的顺序,不同的数据库版本这行不同。
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=QQ","sa","sa");
//注:连接SQLServer 2008 没有microsoft,把这个去掉问题解决。
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=QQ","sa","sa");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return conn;
}
}
参考资料:
http://stackoverflow.com/questions/5616898/java-sql-sqlexception-no-suitable-driver-found-for-jdbcmicrosoftsqlserver
附JDBC连接SQLServer 2008驱动下载,请点击这里。
分享到:
相关推荐
服务器出现java.sql.SQLException No suitable driver found for 的
mysql5.6连接驱动jaf,可处理报错java.sql.SQLException: No suitable driver
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
NULL 博文链接:https://listen-raining.iteye.com/blog/1962065
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
oracle 10g 数据库驱动下载:oracle jdbc dirver
NULL 博文链接:https://zhang-zling.iteye.com/blog/980488
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错: 解决方法: 1,登陆服务器 mysql> use mysql; //用mysql ...
本文主要介绍了关于MySQL存储表情报错:java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法,分享出供大家参考学习,下面话不多说了,来一起看看详细的介绍: ...
oracle ora-各种常见java.sql.SQLException归纳
主要给大家介绍了关于MySQL存储表情时报错:java.sql.SQLException: Incorrect string value: 'xF0x9Fx92xA9x0Dx0A...'的解决方法,文中通过示例代码介绍的非常详细,需要的朋友可以参考借鉴,下面来一起看看吧。
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
/** * @author Administrator * */ public class sqlServer { String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String ConnStr="jdbc:microsoft:sqlserver://WINJUE:1433;DatabaseName=library";
异常错误:java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTime...
java.sql.SQLException: Operation not allowed after ResultSet closed java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
时报了以下的错误 java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序,苦与网上基本上找不到原因只能上外文网找找了 经过GOOGLE后找到一个jstels连接方式...
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError...