org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): 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
    org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist
  2. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 1 year ago | Lalitha Bourishetty
    org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist
  3. 0

    general - [math] "backport" indication. - msg#18526 - Recent Discussion OSDir.com

    osdir.com | 1 year ago
    org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:112) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:251) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:271) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1367) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338) at org.springframework.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:192) at org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138) at org.springframework.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:159) at org.springframework.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:190) at org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getClients(JetspeedCapabilities.java:392) at org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.findClient(JetspeedCapabilities.java:327) at org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getCapabilityMap(JetspeedCapabilities.java:196)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    IOException: socket write error

    Stack Overflow | 3 years ago | Divya
    org.apache.ojb.broker.PersistenceBrokerSQLException: * SQLException during execution of sql-statement:</p> <p>--some sql statement(correct one)</p> <ul> <li>Exception message is [Io exception: Software caused connection abort: socket write error]</li> <li>Vendor error code [17002]</li> </ul> <p>---adding stack trace as well</p> <ul> <li>Target class is 'com.dto.CurrentDTO'</li> <li>PK of the target object is [currentId]
  6. 0

    [OLE-7306] No response, and exception: "No operations allowed after connection closed." - Kuali: Jira

    kuali.org | 1 year ago
    org.apache.ojb.broker.PersistenceBrokerSQLException: Can't prepare statement: sql statement was 'SELECT A0.MSG_DELIV_ID,A0.STAT_CD,A0.TYP_NM,A0.SYS_ID,A0.PROC_CNT,A0.LOCKD_DTTM,A0.VER_NBR,A0.MSG_ID FROM KREN_MSG_DELIV_T A0 WHERE ( (A0.LOCKD_DTTM IS NULL ) AND A0.PROC_CNT < ?) AND (A0.STAT_CD IN ) for update' Exception message is [No operations allowed after connection closed.] Vendor error code [0] SQL state code [08003]

    Root Cause Analysis

    1. org.apache.ojb.broker.PersistenceBrokerSQLException

      SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist

      at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery()
    2. ObJectRelationalBridge
      DelegatingPersistenceBroker.getCollectionByQuery
      1. org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349)
      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
    3. 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
    4. 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
    5. 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
    6. 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
    7. 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
    8. 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
    9. com.sun.proxy
      $Proxy96.getCapabilityMap
      1. com.sun.proxy.$Proxy96.getCapabilityMap(Unknown Source)
      1 frame
    10. 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
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      1 frame
    12. 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
    13. org.apache.jetspeed
      PortalSessionValidationFilter.doFilter
      1. org.apache.jetspeed.container.session.PortalSessionValidationFilter.doFilter(PortalSessionValidationFilter.java:92)
      1 frame
    14. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    15. org.apache.jetspeed
      XXSUrlAttackFilter.doFilter
      1. org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:82)
      1 frame
    16. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    17. 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
    18. 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
    19. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    20. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    21. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame