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

portals-jetspeed-user | Lalitha Bourishetty | 1 year ago
  1. 0

    RE: Jetspeed 2.3

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

    RE: Jetspeed 2.3

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

    RE: Jetspeed 2.3

    portals-jetspeed-user | 1 year 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