3 Replies Latest reply on Feb 8, 2005 10:44 AM by Frank Grimes

    org.jboss.ejb.plugins.LogInterceptor not printing SQLExcepti

    Frank Grimes Newbie

      Hi,

      We are getting intermittent SQLExceptions from some CMP beans and the logs don't show any vendor-specific (ISAM) errors.
      By walking back through the sources, following the stack trace in the logs, it seems that org.jboss.ejb.plugins.LogInterceptor.handleException() doesn't check for SQLException and print getErrorCode().
      Also, a grep of the Jboss sources showed no references to SQLException.getErrorCode() other than in the following places:

      org.jboss.ejb.plugins.cmp.jdbc2.PkSqlCreateCommand
      org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter
      org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter

      FWIW, I'm running jboss-3.2.3 on Redhat ES 2.1 on the IBM-142 JDK, running off Informix 9.4 FC3 with the ibm-2.2.1.JC6 JDBC driver.
      Still, I grepped the sources of jboss-4.0.1 as well and checked org.jboss.ejb.plugins.LogInterceptor in cvs to see if anything had recently been added to the 3.2 or 4.x branches.
      I also googled and searched the newsgroups to no avail...

      Could this really be a missing feature? Or am I a knucklehead who needs to RTFM?

      So, in short, how do I go about making sure that Jboss will print ISAM error codes for all SQLExceptions?

      Thanks.