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

[frankgrimes]

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.

[aloubyansky]

The exception should be logged in CMP engine but you are right getErrorCode is not used in logging. You can open an issue for this in jira.jboss.com.

[frankgrimes]

FYI, the issue has been logged as http://jira.jboss.org/jira/browse/JBAS-1324

[frankgrimes]

Any chance of finding out if/when this issue will be addressed?