[jboss-user] [JBossCache] - JDBCCacheLoader: table not created when using cache.jdbc.tab

gmeroz do-not-reply at jboss.com
Wed Jun 6 11:10:01 EDT 2007 

When using Oracle DB, if schema has role priviliges of 'exp_full_database' (or other DBA priviliges), the table may not be created in case a similar table already exist in another schema in the same DB.

how to produce:
1. create 2 schema on the same DB: SCHEMA_1 & SCHEMA_2
2. run an application with JDBCCacheLoader (cache.jdbc.table.create=true) on SCHEMA_1.
3. add 'exp_full_database' to SCHEMA_2's role priviliges.
4. run the same application from section 2 on SCHEMA_2. you'll get the following exception.

SQL's of JDBCCacheLoader should be generated with the schema name in them...



  | 2007-06-06 14:51:40,380 DEBUG [org.jboss.cache.loader.ManagedConnectionFactory] Datasource lookup for java:/beDS succeded: org.jboss.resource.adapter.jdbc.WrapperDataSource at 1290ef4
  | 2007-06-06 14:51:40,380 DEBUG [org.jboss.cache.loader.ManagedConnectionFactory] Connection checked out: org.jboss.resource.adapter.jdbc.WrappedConnection at 2b5f6c
  | 2007-06-06 14:51:40,489 DEBUG [org.jboss.cache.loader.JDBCCacheLoader] executing sql: select node from jbosscache_application where fqn=? (/)
  | 2007-06-06 14:51:40,489 DEBUG [org.jboss.cache.loader.ManagedConnectionFactory] Connection checked out: org.jboss.resource.adapter.jdbc.WrappedConnection at 185d078
  | 2007-06-06 14:51:41,097 ERROR [org.jboss.cache.loader.JDBCCacheLoader] Failed to load node for fqn /
  | java.sql.SQLException: ORA-00942: table or view does not exist
  | 
  | 	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_describe(T4CPreparedStatement.java:500)
  | 	at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
  | 	at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
  | 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
  | 	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:354)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.exists(AdjListJDBCCacheLoader.java:296)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:227)
  | 	at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:346)
  | 	at org.jboss.cache.CacheImpl.start(CacheImpl.java:755)
  | 	at org.jboss.cache.DefaultCacheFactory.createCache(DefaultCacheFactory.java:87)
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.init(PojoCacheImpl.java:96)
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.<init>(PojoCacheImpl.java:79)
  | 	at org.jboss.cache.pojo.PojoCacheFactory.createCache(PojoCacheFactory.java:42)
  | 	at com.bevents.infra.service.cache.JBossCacheImpl.<init>(JBossCacheImpl.java:32)
  | 	at com.bevents.application.eventaccess.server.manager.cache.ApplicationCacheFactory.<clinit>(ApplicationCacheFactory.java:19)
  | 	at com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.<init>(NodeQueryCacheImpl.java:273)
  | 	at com.bevents.application.eventaccess.server.ejb.ConfigurationBean.initMBeans(ConfigurationBean.java:584)
  | 	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.invocation.Invocation.performCall(Invocation.java:345)
  | 	at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
  | 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
  | 	at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
  | 	at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
  | 	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
  | 	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
  | 	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.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.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 $Proxy60.initMBeans(Unknown Source)
  | 	at com.bevents.application.eventaccess.webapp.EventAcccessInitServlet.init(EventAcccessInitServlet.java:32)
  | 	at javax.servlet.GenericServlet.init(GenericServlet.java:211)
  | 	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
  | 	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
  | 	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
  | 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
  | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
  | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
  | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
  | 	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.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
  | 	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.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:280)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:88)
  | 	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
  | 	at org.jboss.web.WebModule.startModule(WebModule.java:68)
  | 	at org.jboss.web.WebModule.startService(WebModule.java:46)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
  | 	at sun.reflect.GeneratedMethodAccessor2.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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:428)
  | 	at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy28.start(Unknown Source)
  | 	at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:400)
  | 	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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy29.start(Unknown Source)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:979)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
  | 	at sun.reflect.GeneratedMethodAccessor51.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy9.deploy(Unknown Source)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
  | 	at sun.reflect.GeneratedMethodAccessor2.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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:428)
  | 	at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy4.start(Unknown Source)
  | 	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
  | 	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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy5.deploy(Unknown Source)
  | 	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
  | 	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
  | 	at org.jboss.Main.boot(Main.java:187)
  | 	at org.jboss.Main$1.run(Main.java:438)
  | 	at java.lang.Thread.run(Thread.java:595)
  | 2007-06-06 14:51:41,425 ERROR [org.jboss.ejb.plugins.LogInterceptor] Unexpected Error in method: public abstract void com.bevents.application.eventaccess.common.ifc.Configuration.initMBeans() throws java.rmi.RemoteException
  | java.lang.ExceptionInInitializerError
  | 	at com.bevents.application.eventaccess.server.manager.cache.NodeQueryCacheImpl.<init>(NodeQueryCacheImpl.java:273)
  | 	at com.bevents.application.eventaccess.server.ejb.ConfigurationBean.initMBeans(ConfigurationBean.java:584)
  | 	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.invocation.Invocation.performCall(Invocation.java:345)
  | 	at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
  | 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
  | 	at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
  | 	at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
  | 	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
  | 	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
  | 	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.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.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 $Proxy60.initMBeans(Unknown Source)
  | 	at com.bevents.application.eventaccess.webapp.EventAcccessInitServlet.init(EventAcccessInitServlet.java:32)
  | 	at javax.servlet.GenericServlet.init(GenericServlet.java:211)
  | 	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
  | 	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
  | 	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
  | 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
  | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
  | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
  | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
  | 	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.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
  | 	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.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:280)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:88)
  | 	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
  | 	at org.jboss.web.WebModule.startModule(WebModule.java:68)
  | 	at org.jboss.web.WebModule.startService(WebModule.java:46)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
  | 	at sun.reflect.GeneratedMethodAccessor2.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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:428)
  | 	at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy28.start(Unknown Source)
  | 	at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:400)
  | 	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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy29.start(Unknown Source)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:979)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
  | 	at sun.reflect.GeneratedMethodAccessor51.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy9.deploy(Unknown Source)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
  | 	at sun.reflect.GeneratedMethodAccessor2.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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:428)
  | 	at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy4.start(Unknown Source)
  | 	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
  | 	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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | 	at $Proxy5.deploy(Unknown Source)
  | 	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
  | 	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
  | 	at org.jboss.Main.boot(Main.java:187)
  | 	at org.jboss.Main$1.run(Main.java:438)
  | 	at java.lang.Thread.run(Thread.java:595)
  | Caused by: org.jboss.cache.pojo.PojoCacheException: Failed to start application-jboss-cache-service.xml
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.<init>(PojoCacheImpl.java:83)
  | 	at org.jboss.cache.pojo.PojoCacheFactory.createCache(PojoCacheFactory.java:42)
  | 	at com.bevents.infra.service.cache.JBossCacheImpl.<init>(JBossCacheImpl.java:32)
  | 	at com.bevents.application.eventaccess.server.manager.cache.ApplicationCacheFactory.<clinit>(ApplicationCacheFactory.java:19)
  | 	... 173 more
  | Caused by: org.jboss.cache.pojo.PojoCacheException: init org.jboss.cache.config.Configuration at 5e6d9dc8 failed
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.init(PojoCacheImpl.java:100)
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.<init>(PojoCacheImpl.java:79)
  | 	... 176 more
  | Caused by: org.jboss.cache.CacheException: Unable to start cache loaders
  | 	at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:352)
  | 	at org.jboss.cache.CacheImpl.start(CacheImpl.java:755)
  | 	at org.jboss.cache.DefaultCacheFactory.createCache(DefaultCacheFactory.java:87)
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.init(PojoCacheImpl.java:96)
  | 	... 177 more
  | Caused by: java.lang.IllegalStateException: Failed to load node for fqn /
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.reportAndRethrowError(AdjListJDBCCacheLoader.java:629)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:385)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.exists(AdjListJDBCCacheLoader.java:296)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:227)
  | 	at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:346)
  | 	... 180 more
  | Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
  | 
  | 	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_describe(T4CPreparedStatement.java:500)
  | 	at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
  | 	at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
  | 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
  | 	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:354)
  | 	... 183 more
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4051773#4051773

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

More information about the jboss-user mailing list