mybatis链接数据库出错
来源:互联网 发布:淘宝店怎么设置类目 编辑:程序博客网 时间:2024/06/04 19:02
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error getting a new connection. Cause: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
### Cause: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:222)
at cn.itcast.javaee.mybatis.util.MybatisUtil.main(MybatisUtil.java:75)
Caused by: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80)
at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371)
at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)
at org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:220)
### Error getting a new connection. Cause: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
### Cause: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:222)
at cn.itcast.javaee.mybatis.util.MybatisUtil.main(MybatisUtil.java:75)
Caused by: java.sql.SQLException: No suitable driver found for jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176)
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80)
at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371)
at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)
at org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:220)
... 1 more
一开始认为是驱动出的错(数据库驱动不对),不过显然不是。
后来将jdbc.url=jdbc\:mysql\://192.168.100.251\:3306/wbj_bus?useUnicode\=true&characterEncoding\=UTF-8中的转义字符去掉,变成:
<property name="url" value="jdbc:mysql://192.168.100.251:3306/wbj_bus?useUnicode=true&characterEncoding=UTF-8"/>
再次执行就连接成功!
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
连接成功
1 0
- mybatis链接数据库出错
- win7 oracle 链接数据库出错
- 数据库链接出错(编译报错)
- 链接数据库的—MyBatis—事务
- 链接出错
- 基于全注解方式实现MyBatis链接数据库的demo
- 一个棘手的问题,在access数据库 做的一个小站上,数据库链接打开出错
- 数据库链接出错,请检查数据库路径是否正确--这个问题搞了一下午
- Oracle链接出错解决方案
- jdbc 链接orcal出错
- 程序链接出错
- mysql链接大量出错
- matlab 链接 word 出错
- Mybatis 批量出错
- Mybatis查询中文出错
- mybatis使用${}出错
- Mybatis中Mapper出错
- mybatis查询出错
- 数据库Sharding的基本思想和切分策略
- java多线程学习之死锁的模拟和避免
- 对JS关于对象创建的几种方式的整理
- Android开发之CoordinatorLayoutAppBarLayoutViewPagerTabLayout实现顶部伸缩效果
- 百度定位到经纬度,地址
- mybatis链接数据库出错
- 设计模式 适配器模式 以手机充电器为例
- 自定义View进阶-Canvas之绘制图形
- 二叉树的遍历-先序中序后序层次(java实现)
- Mac上传.a静态库到服务器(图文教程)
- WARNING POSSIBLE DNS SPOOFING DETECTED
- JAVA代理模式
- Lua中的基本函数库
- Map集合的四种遍历方式