Hi there,

We are using AIX 5.3 + JBOSS 4 + JBOSS Portal 2.6.5.
Our application is JAVA in AIX 5.3 and access a DB2 database by JDBC Driver IBM (DB2 V9).

We have the following problem:

ATSSDPRF.COM_NUM=0000001 AND TRM_ROLCOD=00048) OPTIMIZE FOR 1 ROW
[I]-2009.07.30 15:12:42,183 :Connection:Closed:true
[E]-2009.07.30 15:12:42,187 org.jboss.util.NestedSQLException:
Error; - nested throwable:
(java.lang.StringIndexOutOfBoundsException)-:-Error; - nested
throwable: (java.lang.StringIndexOutOfBoundsException)

stack trace:

2009-07-30 15:31:03,124 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1a261a26[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@19d219d2 handles=1 lastUse=1248964262835 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@65ca65ca context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1f571f57 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1a1e1a1e txSync=null]
java.lang.StringIndexOutOfBoundsException
at java.lang.String.substring(String.java:1088)
at com.ibm.db2.jcc.a.fm.zb(fm.java:3988)
at com.ibm.db2.jcc.a.fm.xb(fm.java:3959)
at com.ibm.db2.jcc.a.fm.a(fm.java:2668)
at com.ibm.db2.jcc.a.fm.a(fm.java:604)
at com.ibm.db2.jcc.a.fm.executeQuery(fm.java:588)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
at sibs.deswin.lib.dba.DbaConnect.execQuery(DbaConnect.java:295)
at sibs.deswin.lib.dba.SqlSelect.exec(SqlSelect.java:258)
at sibs.ddssd.pss.core.portlet.NaviPage.getPflIItvCom(NaviPage.java:478)
at sibs.ddssd.pss.core.portlet.NaviPage.findResources(NaviPage.java:259)
at sibs.ddssd.pss.core.portlet.NaviPage.doView(NaviPage.java:149)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:133)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:306)
at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.invokeRender(PortletContainerImpl.java:483)
at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.dispatch(PortletContainerImpl.java:405)
at org.jboss.portal.portlet.container.PortletContainerInvoker$1.invoke(PortletContainerInvoker.java:86)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeNotSupported$aop(TransactionInterceptor.java:86)
at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeNotSupported_N4547270787964792031.invokeNext(TransactionInterceptor$invokeNotSupported_N4547270787964792031.java)
at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)

How to do a trace in JBOSS?
Thanks in advanced.