mybatis链接数据库出错

2019-11-06 08:07:49

字体：大中小

来源：转载

供稿：网友

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-8at 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-8at 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中的转义字符去掉，变成：

再次执行就连接成功！

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.连接成功

上一篇：设计模式适配器模式以手机充电器为例

下一篇：poj2109