2 Replies Latest reply on Feb 26, 2007 9:49 AM by Manik Surtani

    Bug? maximum number of expressions in a list is 1000

    gmeroz Newbie

      I'm usning JBossCache-all-2.0.0.ALPHA2 with Oracle. When i try to remove the root of my cache, i get the following error.

      It looks like a bug...

      09:41:43,802 ERROR [JDBCCacheLoader] Failed to remove node /aag
      
      java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
      
      
      
       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      
       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
      
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
      
       at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
      
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
      
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
      
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
      
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
      
       at org.jboss.cache.loader.JDBCCacheLoader.remove(JDBCCacheLoader.java:376)
      
       at org.jboss.cache.loader.AbstractCacheLoader.put(AbstractCacheLoader.java:211)
      
       at org.jboss.cache.loader.JDBCCacheLoader.prepare(JDBCCacheLoader.java:431)
      
       at org.jboss.cache.interceptors.CacheStoreInterceptor.prepareCacheLoader(CacheStoreInterceptor.java:378)
      
       at org.jboss.cache.interceptors.CacheStoreInterceptor.invoke(CacheStoreInterceptor.java:142)
      
       at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
      
       at org.jboss.cache.interceptors.NotificationInterceptor.invoke(NotificationInterceptor.java:22)
      
       at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
      
       at org.jboss.cache.interceptors.TxInterceptor.runPreparePhase(TxInterceptor.java:802)
      
       at org.jboss.cache.interceptors.TxInterceptor$LocalSynchronizationHandler.beforeCompletion(TxInterceptor.java:1058)
      
       at org.jboss.cache.interceptors.OrderedSynchronizationHandler.beforeCompletion(OrderedSynchronizationHandler.java:74)
      
       at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1473)
      
       at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1092)
      
       at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:306)
      
       at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
      
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
      
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
      
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
      
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      
       at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      
       at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
      
       at org.jboss.ejb.Container.invoke(Container.java:873)
      
       at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
      
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
       at java.lang.reflect.Method.invoke(Method.java:585)
      
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      
       at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
      
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
      
       at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179)
      
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165)
      
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
      
       at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
      
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
      
       at $Proxy55.reloadSingletons(Unknown Source)
      
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
       at java.lang.reflect.Method.invoke(Method.java:585)
      
       at org.jboss.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:204)
      
       at com.bevents.infra.service.axis.handler.RemoteEJBProvider.performMethodInvocation(RemoteEJBProvider.java:180)
      
       at com.bevents.infra.service.axis.handler.RemoteEJBProvider.invokeMethod(RemoteEJBProvider.java:155)
      
       at org.jboss.axis.providers.java.RPCProvider.invokeTarget(RPCProvider.java:176)
      
       at org.jboss.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:121)
      
       at org.jboss.net.axis.server.EJBProvider.processMessage(EJBProvider.java:224)
      
       at org.jboss.axis.providers.java.JavaProvider.invoke(JavaProvider.java:358)
      
       at org.jboss.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:73)
      
       at org.jboss.axis.SimpleChain.doVisiting(SimpleChain.java:160)
      
       at org.jboss.axis.SimpleChain.invoke(SimpleChain.java:123)
      
       at org.jboss.axis.handlers.soap.SOAPService.invoke(SOAPService.java:560)
      
       at org.jboss.axis.server.AxisServer.invoke(AxisServer.java:355)
      
       at org.jboss.axis.transport.http.AxisServlet.doPost(AxisServlet.java:911)
      
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      
       at org.jboss.axis.transport.http.AxisServletBase.service(AxisServletBase.java:370)
      
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at com.bevents.infra.service.servlet.CompressionFilter.doFilter(CompressionFilter.java:51)
      
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      
       at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      
       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
      
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
      
       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      
       at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      
       at java.lang.Thread.run(Thread.java:595)