java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Oracle Community | 856506 | 6 years ago
  1. 0

    Login issues with xelsysadm along with ORA-01000 (cursor exceeded) error

    Oracle Community | 6 years ago | 856506
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  2. 0

    db:: 3.88::PosixSocketMuxer: unexpected exception in poll: (22) Invalid argument x9

    hivmr.com | 7 months ago
    javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL
  3. 0

    JDBC BC polling bug using MarkColumn option

    Oracle Community | 8 years ago | 843830
    javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    maximum open cursors exceeded

    GitHub | 3 years ago | kvishal
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  6. 0

    Does Spring JPA support updating parent/child data having composite keys using Oracle?

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded

  1. qavid 1 times, last 5 months ago
18 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-01000: maximum open cursors exceeded

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
    13 frames
  3. com.thortech.xl
    XellerateLoginModuleImpl.login
    1. com.thortech.xl.security.Authenticate.getPropertyValue(Authenticate.java:459)
    2. com.thortech.xl.security.Authenticate.connect(Authenticate.java:117)
    3. com.thortech.xl.security.Authenticate.connect(Authenticate.java:71)
    4. com.thortech.xl.security.wl.XellerateLoginModuleImpl.login(XellerateLoginModuleImpl.java:159)
    4 frames
  4. com.bea.common
    LoginModuleWrapper$1.run
    1. com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:110)
    1 frame
  5. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  6. com.bea.common
    LoginModuleWrapper.login
    1. com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:106)
    1 frame
  7. Java RT
    LoginContext.login
    1. sun.reflect.GeneratedMethodAccessor7737.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    4. javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
    5. javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
    6. javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
    7. java.security.AccessController.doPrivileged(Native Method)
    8. javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
    9. javax.security.auth.login.LoginContext.login(LoginContext.java:579)
    9 frames
  8. com.bea.common
    JAASLoginServiceImpl.login
    1. com.bea.common.security.internal.service.JAASLoginServiceImpl.login(JAASLoginServiceImpl.java:113)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  10. com.bea.common
    Delegator$ProxyInvocationHandler.invoke
    1. com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
    1 frame
  11. Unknown
    $Proxy16.login
    1. $Proxy16.login(Unknown Source)
    1 frame
  12. weblogic.security.service
    WLSJAASLoginServiceImpl$ServiceImpl.login
    1. weblogic.security.service.internal.WLSJAASLoginServiceImpl$ServiceImpl.login(Unknown Source)
    1 frame
  13. com.bea.common
    JAASAuthenticationServiceImpl.authenticate
    1. com.bea.common.security.internal.service.JAASAuthenticationServiceImpl.authenticate(JAASAuthenticationServiceImpl.java:82)
    1 frame
  14. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  15. com.bea.common
    Delegator$ProxyInvocationHandler.invoke
    1. com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
    1 frame
  16. Unknown
    $Proxy34.authenticate
    1. $Proxy34.authenticate(Unknown Source)
    1 frame
  17. weblogic.security.service
    PrincipalAuthenticator.authenticate
    1. weblogic.security.service.WLSJAASAuthenticationServiceWrapper.authenticate(Unknown Source)
    2. weblogic.security.service.PrincipalAuthenticator.authenticate(Unknown Source)
    2 frames
  18. weblogic.security.acl
    Security.authenticate
    1. weblogic.security.acl.internal.Security.authenticateLocally(Security.java:127)
    2. weblogic.security.acl.internal.Security.authenticate(Security.java:165)
    3. weblogic.security.acl.internal.Security.authenticate(Security.java:146)
    3 frames
  19. weblogic.security.auth
    UsernamePasswordLoginModule.login
    1. weblogic.security.auth.Authenticate.authenticate(Authenticate.java:112)
    2. weblogic.security.auth.login.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:184)
    2 frames
  20. Java RT
    LoginContext.login
    1. sun.reflect.GeneratedMethodAccessor7746.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    4. javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
    5. javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
    6. javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
    7. java.security.AccessController.doPrivileged(Native Method)
    8. javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
    9. javax.security.auth.login.LoginContext.login(LoginContext.java:579)
    9 frames
  21. Thor.API.Security
    weblogicLoginHandler.login
    1. Thor.API.Security.LoginHandler.weblogicLoginHandler.login(Unknown Source)
    1 frame
  22. Thor.API
    tcUtilityFactory.<init>
    1. Thor.API.tcUtilityFactory.<init>(Unknown Source)
    1 frame
  23. com.thortech.xl
    QuartzWrapper.execute
    1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
    1 frame
  24. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:178)
    2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:477)
    2 frames