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

jdbcItemReader on DB2: this method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.3.0.Beta3
    • 1.3.0.Beta2
    • jberet-support
    • None

      when running org.jberet.support.io.JdbcReaderWriterTest#readIBMStockTradeCsvWriteJdbcListType with DB2, got the following error:

      Aug 05, 2016 4:13:13 PM org.jberet.runtime.runner.ChunkRunner run
      ERROR: JBERET000007: Failed to run job org.jberet.support.io.JdbcReaderTest, org.jberet.support.io.JdbcReaderTest.step1, org.jberet.job.model.Chunk@64c22bf0
      com.ibm.db2.jcc.am.SqlException: [jcc][t4][10179][10900][4.19.26] This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE). ERRORCODE=-4476, SQLSTATE=null
      at com.ibm.db2.jcc.am.kd.a(Unknown Source)
      at com.ibm.db2.jcc.am.kd.a(Unknown Source)
      at com.ibm.db2.jcc.am.kd.a(Unknown Source)
      at com.ibm.db2.jcc.am.ResultSet.checkThatResultSetTypeIsScrollable(Unknown Source)
      at com.ibm.db2.jcc.am.ResultSet.scrollableCheck(Unknown Source)
      at com.ibm.db2.jcc.am.ResultSet.absolute(Unknown Source)
      at org.jberet.support.io.JdbcItemReader.open(JdbcItemReader.java:254)
      at org.jberet.runtime.runner.ChunkRunner.run(ChunkRunner.java:190)
      at org.jberet.runtime.runner.StepExecutionRunner.runBatchletOrChunk(StepExecutionRunner.java:226)
      at org.jberet.runtime.runner.StepExecutionRunner.run(StepExecutionRunner.java:147)
      at org.jberet.runtime.runner.CompositeExecutionRunner.runStep(CompositeExecutionRunner.java:164)
      at org.jberet.runtime.runner.CompositeExecutionRunner.runFromHeadOrRestartPoint(CompositeExecutionRunner.java:88)
      at org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:60)
      at org.jberet.spi.JobExecutor$1.run(JobExecutor.java:99)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      at java.lang.Thread.run(Thread.java:745)

              cfang@redhat.com Cheng Fang
              cfang@redhat.com Cheng Fang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: