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. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4251620#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...