java.sql.SQLException: Created a new connection but it failed its test
来源：互联网 发布：2017云免流源码 编辑：程序博客网 时间：2024/05/10 18:56
这个异常可能是由于粘贴复制XML文件导致的。在粘贴复制后可能会对复制过来的XML文件有自己都没有察觉到的改动，例如多了一个空格等等。我解决这个问题的方法是：删除原来的XML文件，重新创建一个XML文件，然后将原文件的内容手动输入一遍。以下方法是我从网上查找的，大家在遇到这个问题的时候也可以试试以下方法：
主要是连接池里面配置的错误：
有些文中指出添加test-before-use配置，即每次取出连接都检查连接是否可用,就可以做到让连接池实现在故障恢复后自动重连接.还有另一项配置 house-keeping-test-sql：proxool.XML中的配置的文章test语句都是这个：select CURRENT_DATE（注意mysql用这个），但是mssql用的却是：SELECT GETDATE()
- java.sql.SQLException: Created a new connection but it failed its test
- java.sql.SQLException: Created a new connection but it failed its test
- Hive 笔记异常java.sql.SQLException: Unable to open a test connection to the given database.
- dbcp连接池错误Failed to validate a poolable connection. java.sql.SQLException:
- java.sql.SQLException: Connection has already been created in this tx context for pool named ...
- Hive 笔记异常(java.sql.SQLException: Unable to open a test connection to the given database. JDBC url =)
- a thread named [Abandoned connection cleanup thread] but has failed to stop it
- 【c3p0】 java.sql.SQLException: An attempt by a client to checkout a Connection...
- java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
- java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection
- java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
- java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection
- c3p0 java.sql.SQLException: Connection is invalid
- java.sql.SQLException: Io 异常: Connection reset
- java.sql.SQLException: Io 异常: Connection reset
- java.sql.SQLException: Io 异常: Connection reset
- java.sql.SQLException: Io 异常: Connection reset
- java.sql.SQLException: Connection is closed
- java生成时间戳
- 对一个文件清零函数
- 努力成为优秀的工程师
- java 取得虚拟目录对应的绝对路径
- java 得到当前的IP地址
- java.sql.SQLException: Created a new connection but it failed its test
- 面试题---单词翻转
- struts2实现下载+登录权限验证以及中文处理乱码问题
- 关于myeclipse新建jsp时pageEncoding的设置
- iOS去掉UITableView多余的separator
- 猜数字 小游戏
- TMS320VC33字长问题
- php文件写入模式
- apache部署集群jkstatus中busy数过高
