java.sql.SQLException: ORA-00942: table or view does not exist

Oracle Community | 666705 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    table or view does not exist error when calling webservice

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-00942: table or view does not exist
  2. 0

    When pressing next after Setup Admin - step 6 following expeption is thrown: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80) at bucket.util.ResettableIncrementGenerator.getNext(ResettableIncrementGenerator.java:73) at bucket.util.ResettableIncrementGenerator.generate(ResettableIncrementGenerator.java:39) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:747) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359) at org.springframework.orm.hibernate.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:259) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:257) at bucket.core.persistence.hibernate.HibernateObjectDao.saveRaw(HibernateObjectDao.java:151) at bucket.core.persistence.hibernate.HibernateObjectDao.save(HibernateObjectDao.java:121) at com.atlassian.confluence.security.DefaultSpacePermissionManager.savePermission(DefaultSpacePermissionManager.java:70) at com.atlassian.confluence.security.CachingSpacePermissionManager.savePermission(CachingSpacePermissionManager.java:17) 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:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148) at $Proxy76.savePermission(Unknown Source) at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroupsAndPermissions(SetupAdministrator.java:48) at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:88) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Referer URL: Unknown Build Information: Uptime: 8 minutes, 26 seconds Version: 1.1 Build Number: 53 Server Information: Application Server: WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.Oracle9Dialect Memory Information: Total Memory: 510 MB Free Memory: 355 MB Used Memory: 155 MB System Information: System Date: Thursday, 10 Jun 2004 System Time: 02:20:16 System Favourite Colour: Almond Java Version: 1.4.1_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.1_05-b01 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: MET Operating System: SunOS 5.9 OS Architecture: sparc Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Stephan Janssen
    java.sql.SQLException: ORA-00942: table or view does not exist
  3. 0

    When pressing next after Setup Admin - step 6 following expeption is thrown: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80) at bucket.util.ResettableIncrementGenerator.getNext(ResettableIncrementGenerator.java:73) at bucket.util.ResettableIncrementGenerator.generate(ResettableIncrementGenerator.java:39) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:747) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359) at org.springframework.orm.hibernate.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:259) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:257) at bucket.core.persistence.hibernate.HibernateObjectDao.saveRaw(HibernateObjectDao.java:151) at bucket.core.persistence.hibernate.HibernateObjectDao.save(HibernateObjectDao.java:121) at com.atlassian.confluence.security.DefaultSpacePermissionManager.savePermission(DefaultSpacePermissionManager.java:70) at com.atlassian.confluence.security.CachingSpacePermissionManager.savePermission(CachingSpacePermissionManager.java:17) 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:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148) at $Proxy76.savePermission(Unknown Source) at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroupsAndPermissions(SetupAdministrator.java:48) at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:88) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Referer URL: Unknown Build Information: Uptime: 8 minutes, 26 seconds Version: 1.1 Build Number: 53 Server Information: Application Server: WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.Oracle9Dialect Memory Information: Total Memory: 510 MB Free Memory: 355 MB Used Memory: 155 MB System Information: System Date: Thursday, 10 Jun 2004 System Time: 02:20:16 System Favourite Colour: Almond Java Version: 1.4.1_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.1_05-b01 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: MET Operating System: SunOS 5.9 OS Architecture: sparc Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Stephan Janssen
    java.sql.SQLException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle install problem

    oreports | 1 decade ago | thileg
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    WebLogic 5.1/JMS tables not found/Persistant Store not initialized

    Google Groups | 2 decades ago | Daniel
    java.sql.SQLException: ORA-00942: table or view does not exist

  1. rp 1 times, last 2 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-00942: table or view does not exist

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteDescribe
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
    4 frames
  5. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
    1 frame
  6. com.bea.wlw
    BMPContainerBean.ejbLoad
    1. com.bea.wlw.runtime.core.bean.BMPContainerBean$OracleTableAccess.doLoad(BMPContainerBean.java:823)
    2. com.bea.wlw.runtime.core.bean.BMPContainerBean.ejbLoad(BMPContainerBean.java:1660)
    2 frames
  7. com.bea.wlwgen
    PersistentContainer_k87wtk_Impl.ejbLoad
    1. com.bea.wlwgen.PersistentContainer_k87wtk_Impl.ejbLoad(PersistentContainer_k87wtk_Impl.java:136)
    1 frame
  8. weblogic.ejb20.manager
    ExclusiveEntityManager.preInvoke
    1. weblogic.ejb20.manager.ExclusiveEntityManager.getReadyBean(ExclusiveEntityManager.java:299)
    2. weblogic.ejb20.manager.ExclusiveEntityManager.preInvoke(ExclusiveEntityManager.java:221)
    2 frames
  9. weblogic.ejb20.internal
    EntityEJBLocalObject.preInvoke
    1. weblogic.ejb20.internal.BaseEJBLocalObject.preInvoke(BaseEJBLocalObject.java:229)
    2. weblogic.ejb20.internal.EntityEJBLocalObject.preInvoke(EntityEJBLocalObject.java:73)
    2 frames
  10. com.bea.wlwgen
    BatchAgilentPControlBMPContAdpt.invokeOnBean
    1. com.bea.wlwgen.PersistentContainer_k87wtk_ELOImpl.clientRequest(PersistentContainer_k87wtk_ELOImpl.java:136)
    2. com.bea.wlwgen.BatchAgilentPControlBMPContAdpt.invokeOnBean(BatchAgilentPControlBMPContAdpt.java:90)
    2 frames
  11. com.bea.wlw
    WlwProxyImpl.invoke
    1. com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153)
    2. com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:54)
    3. com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(SyncDispatcherBean.java:160)
    4. com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(SyncDispatcher_k1mrl8_EOImpl.java:100)
    5. com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Dispatcher.java:161)
    6. com.bea.wlw.runtime.core.dispatcher.ServiceHandleImpl.invoke(ServiceHandleImpl.java:414)
    7. com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl._invoke(WlwProxyImpl.java:275)
    8. com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl.invoke(WlwProxyImpl.java:264)
    8 frames
  12. Unknown
    $Proxy37.clientRequest
    1. $Proxy37.clientRequest(Unknown Source)
    1 frame
  13. admin.BatchProcess
    BatchProcessController.chooseJiraAttachment
    1. admin.BatchProcess.BatchProcessController.chooseJiraAttachment(BatchProcessController.jpf:184)
    1 frame
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  15. com.bea.wlw
    FlowController.execute
    1. com.bea.wlw.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:1495)
    2. com.bea.wlw.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:1430)
    3. com.bea.wlw.netui.pageflow.FlowController.internalExecute(FlowController.java:761)
    4. com.bea.wlw.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:211)
    5. com.bea.wlw.netui.pageflow.FlowController.execute(FlowController.java:591)
    5 frames
  16. struts
    RequestProcessor.process
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    2 frames
  17. com.bea.wlw
    PageFlowActionServlet.process
    1. com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:651)
    2. com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
    3. com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
    3 frames
  18. struts
    ActionServlet.doPost
    1. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    1 frame
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    2 frames
  20. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971)
    2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)
    3. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6354)
    4 frames
  21. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
    1 frame
  22. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
    1 frame
  23. Atmosphere weblogic
    ServletRequestImpl.execute
    1. weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635)
    2. weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)
    2 frames
  24. weblogic.kernel
    ExecuteThread.run
    1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
    2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
    2 frames