[jboss-dev-forums] [JBoss Portal QA] - org.jboss.util.NESTEDSQLException

[xptobr]

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 at 1a261a26[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 19d219d2 handles=1 lastUse=1248964262835 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 65ca65ca context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 1f571f57 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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#4251620

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4251620