> Hi > > Currently with the JDBCDescriptorsStore, when the database connection is > unexpectedly lost, we have to restart Tomcat to recreate the connection. > > I've attached a stack trace which shows the problem. > > I thought it looked easy enough to solve - just add connectIfNeeded() > before each attempt to use the connection (catching > ServiceConnectionFailedException). > > But isClosed() as used in that method can't actually determine whether > the connection is invalid, so instead, i try to connect if > connection.prepareStatement throws an SLQException. > > Patch is attached.
Maybe, but shouldn't isClosed return the actual status of the connection ? If the spec says it should, then I don't think we should add some other workarounds in the code. Remy -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
