jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jorge Rodríguez Pedrianes (JIRA) <j...@apache.org>
Subject [jira] Created: (JCR-576) Close Connection when I use PersistenManager and FileSystem with mysql database
Date Fri, 22 Sep 2006 10:23:45 GMT
Close Connection when I use PersistenManager and FileSystem with mysql database

                 Key: JCR-576
                 URL: http://issues.apache.org/jira/browse/JCR-576
             Project: Jackrabbit
          Issue Type: Improvement
    Affects Versions: 1.0.1
         Environment: tomcat  5.5.7
mysql 5.0
jackrabbit 1.0.1
            Reporter: Jorge Rodríguez Pedrianes
         Attachments: DatabaseFileSystem.java, DatabasePersistenceManager.java


     In this days i was trying to configure jackrabbit with mysql database, but i saw that
connections to database were closed when my application was idle about 8 hours. When i try
to access to application this threw a exception and i needed to restart tomcat to resolve
this problem.  First, I tried to resolve it adding a parameter to url connection (autoReconnect=true),
but this solution isn't successfully.

    Then i saw your codes (DatabasePersistenceManager.java and DatabaseFileSystem.java) and
i could see the problem: when the connections are closed by the server; the connection ("con"
attribute)  isn't restarted. So, I added a checkConnection Method, this method is add in all
methods that need conection: 

    protected void checkConnection() throws FileSystemException {
    	if (checkValidConnectionSQL == null) {
    	try {
		} catch (SQLException e) {
			log.warn("Restart connection, ErrorCode= \"" + e.getErrorCode()+ "\"");
			initialized = false;

    I think that this improvement it's very interesting to avoid restart connections when
are necesary

        Jorge Rodríguez Pedrianes

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message