[jboss-user] [JBoss Portal Users] - 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=4251621#4251621

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