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

portals-jetspeed-user | Lalitha Bourishetty | 2 years 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

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  5. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.SQLSyntaxErrorException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
    10. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
    11. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
    13. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
    14. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
    14 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:141)
    1 frame
  4. ObJectRelationalBridge
    DelegatingPersistenceBroker.getCollectionByQuery
    1. org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)
    2. org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
    3. org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)
    4. org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
    5. org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)
    6. org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)
    7. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:112)
    8. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:251)
    9. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:271)
    10. org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1367)
    11. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338)
    12. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338)
    12 frames
  5. org.springframework.orm
    PersistenceBrokerTemplate.getCollectionByQuery
    1. org.springframework.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:192)
    2. org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)
    3. org.springframework.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:159)
    4. org.springframework.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:190)
    4 frames
  6. org.apache.jetspeed
    JetspeedCapabilities.getCapabilityMap
    1. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getClients(JetspeedCapabilities.java:392)
    2. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.findClient(JetspeedCapabilities.java:327)
    3. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getCapabilityMap(JetspeedCapabilities.java:196)
    3 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:497)
    4 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  10. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  11. com.sun.proxy
    $Proxy96.getCapabilityMap
    1. com.sun.proxy.$Proxy96.getCapabilityMap(Unknown Source)
    1 frame
  12. org.apache.jetspeed
    JetspeedServlet.service
    1. org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:65)
    2. org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(JetspeedPipeline.java:242)
    3. org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:163)
    4. org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java:219)
    5. org.apache.jetspeed.engine.JetspeedServlet.invoke(JetspeedServlet.java:301)
    6. org.apache.jetspeed.engine.JetspeedServlet.service(JetspeedServlet.java:319)
    6 frames
  13. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
    1 frame
  14. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
    2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
    3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
    4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
    5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
    6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    6 frames
  15. org.apache.jetspeed
    PortalSessionValidationFilter.doFilter
    1. org.apache.jetspeed.container.session.PortalSessionValidationFilter.doFilter(PortalSessionValidationFilter.java:92)
    1 frame
  16. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    1 frame
  17. org.apache.jetspeed
    XXSUrlAttackFilter.doFilter
    1. org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:82)
    1 frame
  18. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    1 frame
  19. org.apache.jetspeed
    ServletRequestCleanupFilter.doFilter
    1. org.apache.jetspeed.util.ServletRequestCleanupService.doFilter(ServletRequestCleanupService.java:146)
    2. org.apache.jetspeed.util.ServletRequestCleanupFilter.doFilter(ServletRequestCleanupFilter.java:52)
    2 frames
  20. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
    3 frames
  21. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  22. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  23. weblogic.servlet.provider
    WlsSubjectHandle.run
    1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
    1 frame
  24. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
    2. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
    3. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    4. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
    4 frames
  25. weblogic.servlet.provider
    ContainerSupportProviderImpl$WlsRequestExecutor.run
    1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
    1 frame
  26. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
    2 frames