0 Replies Latest reply on Aug 25, 2009 1:38 PM by xpto xpto

    org.jboss.util.NestedSQLException

    xpto xpto Newbie

      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.