Details
-
Patch
-
Resolution: Done
-
Major
-
JBossAS-4.0.4.CR2
-
None
Description
The database connections are configured to use prepared statement cache.
The JBoss server is up and running.
For informix database you have to execute an "update statistics" in regular intervals, i.e. once a week, to get informations about data distribution in index cols.
After this, the next time an already prepared statement is reused, you get an SQL-Exection woth informix code 710: Table <table-name> has been dropped, altered or renamed.
Without my modification, the server tries to use this connection / prepared statement again and again.
With this change, the connection with the prepared statement which got the exception is closed and another one is used.
Index: jboss-4.0.x/connector/src/main/org/jboss/resource/adapter/jdbc/vendor/InformixExceptionSorter.java
===================================================================
RCS file: /cvsroot/jboss/jbosscx/src/main/org/jboss/resource/adapter/jdbc/vendor/InformixExceptionSorter.java,v
retrieving revision 1.1.4.3
diff -r1.1.4.3 InformixExceptionSorter.java
45a46
> case -710: // Table <table-name> has been dropped, altered or renamed.