I use jdbc theme to connect spatial database by click the specific map region every time. I create several MVThemeBasedFOI with a checkbox to set each one visible or not. In the begining, everything is fine, but after severals clicks to set visibles some of this themes based FOIs I met this error from time to time:
Mapviewer-05523: Cannot process response from MapViewer server
MapViewer-06009 Error handling FOI request;
Root cause：FOIServlet Invalid or Stale Connection found in the Connection Cache
It sounds like it is not refreshing all the cache connections. I found this method refreshCache in the class oracle.jdbc.pool.OracleConnectionCacheManager to refresh the cache connections but I am not sure if it is possible to use it with the Mapviewer connections.