No suitable driver found for jdbc:mysql://local...
来源:互联网 发布:庄子·胠箧 知乎 编辑:程序博客网 时间:2024/06/05 05:55
部署web项目时报,No suitable driver found for jdbc:mysql://localhost:3306/test
其实就是没有连接上数据库 !
结合网上查的是:
一是:连接URL格式出现了问题(Connection conn=DriverManager.getConnection ("jdbc:mysql://localhost:3306/XX","root","XXXX")
二是:驱动字符串出错(com.mysql.jdbc.Driver)
三是Classpath中没有加入合适的mysql_jdbc驱动
我的解决是:
将mysql-connector-java-5.0.5-bin.jar放在C:/Program Files/Java/jre6/lib/ext下面,同时将mysql-connector-java-5.0.5-bin.jar和mysqldriver.jar放到%JAVA_HOME%/lib/ext下面,部署还是报同样的错误!
然后在applicationContext.xml添加
<!-- jdbc4.0 已经不需要指定驱动的类名了,当然这需要所添加的驱动符合jdbc4.0标准 -->
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
再部署,问题解决!
总结:我的mysqldriver.jar版本是低于4.0的,所以必添加这行配置代码!
此问题出于S2SH整合的情形中,struts2.1.8 + hibernate3.5.0 + spring3.0.2。
数据库为MySql5.0 !
- No suitable driver found for jdbc:mysql://local...
- no suitable driver found for jdbc:mysql
- No suitable driver found for jdbc:mysql
- No suitable driver found for jdbc:mysql://localhost/mysql
- No suitable driver found for jdbc:mysql://localhost:3306/ 问题
- No suitable driver found for jdbc:mysql:URL
- JDev: jdeveloper no suitable driver found for jdbc mysql
- No suitable driver found for jdbc:mysql://localhost:3306/stu_mis
- cloudstack:No suitable driver found for jdbc:mysql
- no suitable driver found for jdbc:mysql//localhost:3306/..
- No suitable driver found for jdbc:mysql://localhost:3306/ 问题
- no suitable driver found for jdbc:mysql//localhost:3306/..
- No suitable driver found for jdbc:mysql://localhost:3306/****
- No suitable driver found for jdbc:mysql://localhost/shop
- No suitable driver found for jdbc:mysql://localhost:3306/test
- java连接mysql :No Suitable Driver Found For Jdbc 解决方法
- java.sql.SQLException: No suitable driver found for jdbc:mysql
- weka连接mysql错误:no suitable driver found for jdbc
- C#与C++抉择【z】
- 设计模式 开放封闭原则 OCP
- SQL查询语句使用
- 上路
- らき☆すた
- No suitable driver found for jdbc:mysql://local...
- 静态库文件的理解
- 定义网络数据报文--字节对齐
- Birt 2_0_1报表Tomcat 6.0 访问错误
- Struts2.1.8 Project Dependencies
- 代理模式的理解
- 基带、基带信号和基带传输(附带频带和宽带)
- 成大事必备9种能力、9种手段、9种心态
- javascripte删除前后字符串