Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-3120

additional error code in Informix ExceptionSorter

    XMLWordPrintable

Details

    • Patch
    • Resolution: Done
    • Major
    • JBossAS-4.0.4.GA
    • JBossAS-4.0.4.CR2
    • JCA service
    • 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.

      Attachments

        Activity

          People

            weston.price Weston M. Price (Inactive)
            franklangelage Frank Langelage (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: