Unable to Connect to External JIRA Database Due to 'java.sql.SQLException Closed Connection'
症状
The following exceptions will be found in the logs:
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)
原因
When performing an action in JIRA(such as viewing or updating an issue), an error is returned because the database connection has already been closed.
ソリューション
In order to prevent this problem from recurring in future:
- Jira を終了します。
- Add a validation query which JIRA will use when communicating with its database. For more details on how to set the validation query, see:
- Jira を再起動します。
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.