0 Replies Latest reply on Dec 1, 2003 6:24 AM by gavinandrews

    JBOSS CMP blows Sybase Stack

    gavinandrews

      All,

      A piece of SQL generated by JBOSS is blowing the Sybase Stack now that one of my tables has grown to 600 rows... the SQL includes many (I presume 600 OR clauses where InstrumentPriceId =?

      Any ideas? I could either try and fix Sybase or try and limit the pagesize to reduce the OR clauses? If I change Sybase how much stack do I need??

      Sybase 12.0.0.3
      JBOSS 3.2.2RC4 (in use in production!)

      Thanks in advance,
      Gavin


      2003-11-28 17:33:39,558 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: pub
      lic abstract java.lang.String com.rabobank.boris.ejb.entity.instrumentprice.InstrumentPriceEntity.getISIN() throws
      java.rmi.RemoteException, causedBy:
      com.sybase.jdbc2.jdbc.SybSQLException: The transaction was aborted because it used too much stack space. Either us
      e sp_configure to increase the stack size, or break the query into smaller pieces. spid: 12, suid: 9, hostname: ,
      application name:

      at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2408)
      at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1844)
      at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
      at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
      at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
      at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1401)
      at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1386)
      at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:69)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:289
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:174)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:86)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:634)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:616)
      at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:381)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor
      .java:352)
      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:229
      )
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.jav
      a:185)
      at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:114)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:174)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:53)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:297)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:490)
      at org.jboss.ejb.Container.invoke(Container.java:700)
      at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      at org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:97)
      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      at $Proxy53.getISIN(Unknown Source)
      at com.rabobank.boris.ejb.session.instrumentprice.InstrumentPriceProcessorEJB.SendAllInstrumentPrices(Unkn
      own Source)