java.sql.SQLException: Connections could not be acquired from the underlying database!

原创 2016年05月31日 10:05:52

以上问题可能有一下原因造成:

1,驱动配置有误:driver=com.mysql.jdbc.Driver
2,数据库连接地址有误:url=jdbc:mysql://localhost:3306/test?3useUnicode=true&characterEncoding=utf8
3,密码或帐号有误:username=root
      password=root

4,数据库未启动或无权访问

5,项目未引入对应的驱动jar包mysql-connector-java-5.1.6-bin.jar

6,mysql root没有远程访问的权限,需要增加权限,增加权限的步骤如下:
进入mysql数据库:
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;

7.端口号不对

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

web项目执行查询的时候报错: Caused by: java.sql.SQLException: Connections could not be acquired from the underl...

Linux磁盘空间满导致的Connections could not be acquired from the underlying database!问题

问题名称:Hibernate poperation:Cannot open connection;uncategorized SQLException for SQL[???];SQL state [...

Connections could not be acquired from the underlying database

og4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. org.quartz.Sched...

spring整合mybaits时Connections could not be acquired from the underlying database!异常解决

Connections could not be acquired from the underlying database

严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could...

Connections could not be acquired from the underlying database! 特殊情况

Connections could not be acquired from the underlying database! 特殊情况 Access denied for user 'www'@'...

Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDyna

一异常原因用Sqoop将数据从mysql导入到Hbase表出现异常如下: [root@master bin]# ./sqoop import --connect jdbc:mysql://1...

Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connectio

严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could...

java.sql.SQLException: Could not retrieve transation read-only status server

org.springframework.dao.TransientDataAccessResourceException:

数据库连接丢失,重连 Cause: java.sql.SQLException: Could not retrieve transation read-only status server

java程序运行中突然报如下错误: ### Error querying database.  Cause: java.sql.SQLException: Could not retrieve tra...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:java.sql.SQLException: Connections could not be acquired from the underlying database!
举报原因:
原因补充:

(最多只允许输入30个字)