[ http://issues.apache.org/jira/browse/JCR-576?page=comments#action_12436831 ] Jorge Rodríguez Pedrianes commented on JCR-576: -----------------------------------------------
Hmmmm!!! jejeje, i read the same. Then i think implement another solution, because your code fail if the connection it's closed by server because all "PreparedStatementare" are asociated to this connecction and they are create only when "init()" method is invoked. The most quickly solution is this, but i don't said that is the best solution. Thanks > 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 > > > Hello. > 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) { > return; > } > try { > checkConnection.executeQuery(); > } catch (SQLException e) { > log.warn("Restart connection, ErrorCode= \"" + > e.getErrorCode()+ "\""); > initialized = false; > init(); > e.printStackTrace(); > > } > } > I think that this improvement it's very interesting to avoid restart > connections when are necesary > Thanks: > 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
