java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://127.0.0.1:1433;解决
来源:互联网 发布:域名做企业邮箱 编辑:程序博客网 时间:2024/05/16 19:00
环境: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 exceptione.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 jdbc:microsoft:sqlserver://127.0.0.1:1433;解决
- java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://127.0.0.1:1433
- Hibernate插件出现错误 java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
- java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;databaseName
- java.sql.SQLException: No suitable driver found for jdbc:derby
- java.sql.SQLException: No suitable driver found for jdbc:mysql
- java.sql.SQLException: No suitable driver found for jdbc:mysql
- Tomcat 部署 时 java.sql.SQLException: No suitable driver found for jdbc:sqlserver 我是怎么解决的
- java.sql.SQLException: No suitable driver found for jdbc:mysql:/localhost/XXX?还是没有解决
- android studio下解决 java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/
- JAVA No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433/xxxxxx 解决办法
- neo4j Caused by:java.sql.SQLException:No suitable driver found for jdbc:neo4j:http:/127.0.0.1:7474/
- jdbc访问hive出现java.sql.SQLException: No suitable driver found for jdbc:hive的错误
- java.sql.SQLException: No suitable driver found for url
- java.sql.SQLException: No suitable driver found for
- java.sql.SQLException:No suitable driver found for "jdbc:oracle:thin:@
- mondrian java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/foodmart
- Jmeter java.sql.SQLException: No suitable driver found for jdbc:mysql:
- jdk环境变量配置
- love to be loved by you
- vc与matlab混编之matcom
- Linux下文件查找
- 项目团队管理:敏捷团队建设
- java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://127.0.0.1:1433;解决
- P2P中打洞的若干问题
- java 创建json对象
- 社交媒体的美好时代将结束
- ofstream写入数据
- 黑马程序员-java基础 异常
- 基于linux的文件传输器实现详解----客户端实现详解
- 闲谈网络业大佬们的赌术和赌品
- 神舟1号stm32上实现俄罗斯方块