We have noticed some application errors related to connection pool and changes to stored procedures. We are using several stored procedures through the cayenne ProcedureQuery. What we've found is that when and if a change is made to one of the packages in the database the state of the package is invalidated and the connection pool is discarded. This results in an error for the user. The connection pool is reset and so the next time the user tries it will work.
Is there a way to reset the Cayenne connection pool through the API so that we don't have to restart the server? Thanks in advance.
Beth Williams
Web Applications Developer, NFIB
53 Century Blvd
Nashville, TN 37214
615.872.5332
beth.william..fib.org
This archive was generated by hypermail 2.0.0 : Thu Apr 07 2005 - 10:44:34 EDT