# JIRA 无法连接数据库 'java.sql.SQLException Closed Connection'

**URL:** <https://www.isharkfly.com/t/jira-java-sql-sqlexception-closed-connection/11302>\
**Category:** 敏捷开发\
**Created:** [August 18, 2012, 3:06am UTC](https://www.isharkfly.com/t/jira-java-sql-sqlexception-closed-connection/11302 "2012-08-18T03:06:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [August 18, 2012, 3:06am UTC](https://www.isharkfly.com/t/jira-java-sql-sqlexception-closed-connection/11302/1 "2012-08-18T03:06:16Z")

</div>

现象  
无法连接数据库时会在日志中记录以下错误:`2008-02-24 08:59:51,034 Finalizer WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Closed Connection
2008-02-24 08:59:51,034 Finalizer WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1161)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)`原因

当在JIRA中执行操作时(比如查看或更新问题), 如果Oracle数据库连接已经关闭，就会出现这个错误。

解决方案

1. 停止 JIRA 服务
2. 为了防止再次发生此类错误，, 在 conf/server.xml 文件中添加查询验证设置。 关于如何设置查询验证设置，请参考 [http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures](http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures)
3. 启动 JIRA 服务
