Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-473

Invalid operation for forward only resultset when running jdbcItemReader with Oracle

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Explained
    • Affects Version/s: 1.3.3.Final
    • Fix Version/s: None
    • Component/s: jberet-support
    • Labels:
      None

      Description

      When running with Oracle database, had the following errors from JdbcItemReader.
      See this JBeret Forum thread for details.

      ERROR: JBERET000007: Failed to run job org.jberet.support.io.JdbcReaderCheckpointTest, org.jberet.support.io.JdbcReaderCheckpointTest.step1, org.jberet.job.model.Chunk@4bd20a04
      java.sql.SQLException: Invalid operation for forward only resultset : absolute
      at oracle.jdbc.driver.InsensitiveScrollableResultSet.absolute(InsensitiveScrollableResultSet.java:1255)
      at org.jberet.support.io.JdbcItemReader.open(JdbcItemReader.java:208)
      at org.jberet.runtime.runner.ChunkRunner.run(ChunkRunner.java:195)
      at org.jberet.runtime.runner.StepExecutionRunner.runBatchletOrChunk(StepExecutionRunner.java:223)
      at org.jberet.runtime.runner.StepExecutionRunner.run(StepExecutionRunner.java:142)
      at org.jberet.runtime.runner.CompositeExecutionRunner.runStep(CompositeExecutionRunner.java:170)
      at org.jberet.runtime.runner.CompositeExecutionRunner.runFromHeadOrRestartPoint(CompositeExecutionRunner.java:94)
      at org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:58)
      at org.jberet.spi.JobExecutor$1.run(JobExecutor.java:100)
      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
      at java.base/java.lang.Thread.run(Thread.java:844)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  cfang Cheng Fang
                  Reporter:
                  cfang Cheng Fang
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: