org.springframework.dao.DataAccessResourceFailureException: Could not obtain sequence value; nested exception is java.sql.SQLException: ORA-02289: sequence does not exist

spring.io | 7 months 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

    Could not open JDBC Connection for transaction java.sql.SQLException: ORA-00923: - Spring Forum

    spring.io | 8 months ago
    org.springframework.dao.DataAccessResourceFailureException: Could not obtain sequence value; nested exception is java.sql.SQLException: ORA-02289: sequence does not exist
  2. 0

    Could not open JDBC Connection for transaction java.sql.SQLException: ORA-00923: - Spring Forum

    spring.io | 7 months ago
    org.springframework.dao.DataAccessResourceFailureException: Could not obtain sequence value; nested exception is java.sql.SQLException: ORA-02289: sequence does not exist
  3. 0

    Liquibase with Oracle ORA-00904: "HISTOGRAM": invalid identifier on second changelog

    Stack Overflow | 1 year ago | Sam
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in com.yell.connect.publisher.database.PublisherDbConfig: Invocation of init method failed; nested exception is liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: ORA-00904: "HISTOGRAM": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLException: Closed Connection, SQL state [nul... | Oracle Community

    oracle.com | 11 months ago
    java.sql.SQLException: Io exception: Connection timed out
  6. 0

    Symmetric installation error Oracle 8i

    symmetricds | 5 years ago | pvidal20
    java.sql.SQLException: ORA-00933: SQL command not properly ended

    1 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-02289: sequence does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      6. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
      8. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
      10 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      1 frame
    4. Spring Framework
      AbstractDataFieldMaxValueIncrementer.nextLongValue
      1. org.springframework.jdbc.support.incrementer.AbstractSequenceMaxValueIncrementer.getNextKey(AbstractSequenceMaxValueIncrementer.java:69)
      2. org.springframework.jdbc.support.incrementer.AbstractDataFieldMaxValueIncrementer.nextLongValue(AbstractDataFieldMaxValueIncrementer.java:125)
      2 frames
    5. Spring Batch Core
      SimpleJobRepository.createJobExecution
      1. org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.createJobInstance(JdbcJobInstanceDao.java:110)
      2. org.springframework.batch.core.repository.support.SimpleJobRepository.createJobExecution(SimpleJobRepository.java:127)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    7. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    8. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    9. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    10. Unknown
      $Proxy0.createJobExecution
      1. $Proxy0.createJobExecution(Unknown Source)
      1 frame
    11. Spring Batch Core
      CommandLineJobRunner.main
      1. org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:102)
      2. org.springframework.batch.core.launch.support.CommandLineJobRunner.start(CommandLineJobRunner.java:207)
      3. org.springframework.batch.core.launch.support.CommandLineJobRunner.main(CommandLineJobRunner.java:254)
      3 frames
    12. Unknown
      FileToTableMain.main
      1. FileToTableMain.main(FileToTableMain.java:8)
      1 frame