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

Oracle Community | 856506 | 6 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

    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 | 10 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. treefolk 2 times, last 2 months ago
  2. qavid 1 times, last 7 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