We are using Informix 9.4 and 10.0 as database server. To get the index statistics up to date you'll have to execute an "update statistics" regulary. Most often this is done on the weekend when there is low traffic on the system.
If we use the prepared statement cache, the next time a prepared statement is used again after the update statistics, we get an SQLException because of database error code -710: -710 Table <table-name> has been dropped, altered or renamed. The database connection used is marked as bad, because -710 is handled in InformixValidConnectionChecker as fatal. Is there a way to use the cache but avoid this situation? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3950180#3950180 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3950180 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
