Topic
2 replies Latest Post - ‏2012-03-21T19:23:35Z by Randy.Wright639
Randy.Wright639
Randy.Wright639
2 Posts
ACCEPTED ANSWER

Pinned topic getInitialLookupQuery()

‏2012-03-21T13:41:17Z |
We are using GenericXDBatchStep, and a JDBCReader.
but getInitialLookupQuery() is never called.
It always goes to getRestartQuery().

I did a work around by checking the restartKey for null, and calling getInitialLookupQuery() myself.

If anyone has any ideas why this might be happening I would be glad to hear?

Not sure what part of the code would be useful in answering but here is the xJCL for the reader.

<bds>
<logical-name>inputStream</logical-name>
<impl-class>
com.ibm.websphere.batch.devframework.datastreams.patterns.JDBCReader</impl-class>
<props>
<prop name="PATTERN_IMPL_CLASS" value="com.bcbsks.mr.membership.hub.readers.HubBenefitPlanChangeReaderImpl"/>
<prop name="ds_jndi_name" value="${DB2jndi}" />
<prop name="debug" value="${debugEnabled}" />
<prop name="restartToken" value="${restartKey}"/>
<prop name="runDate" value ="${runDate}"/>
<prop name="auto_commit_enabled" value="false" />
</props>
</bds>
Updated on 2012-03-21T19:23:35Z at 2012-03-21T19:23:35Z by Randy.Wright639
  • sajan
    sajan
    42 Posts
    ACCEPTED ANSWER

    Re: getInitialLookupQuery()

    ‏2012-03-21T17:22:20Z  in response to Randy.Wright639
    Randy, getInitialLookupQuery() should be called when positioning at the initial checkpoint. If you have some logs please attach it here and I'll look into it.
    Sajan.
    • Randy.Wright639
      Randy.Wright639
      2 Posts
      ACCEPTED ANSWER

      Re: getInitialLookupQuery()

      ‏2012-03-21T19:23:35Z  in response to sajan
      I have attached a txt file with part of the logs.
      I did notice some messages I had not noticed before.
      If I am reading this correctly, The first call to my reader is an intermediateCheckpoint

      Things like:
      O DEBUG->jobid: HubChange:00432:GenericXDBatchStep: Got headernull
      O DEBUG->jobid: HubChange:00432:exiting createJobStep

      I CWLRB2440I: 03/21/12 13:53:15:171 CDT 03/21/12 13:53:15:171 CDT Job HubChange:00432 Step HubChangeStep1 is dispatched.

      O DEBUG->jobid: HubChange:00432/HubChangeStep1:com.ibm.websphere.batch.devframework.datastreams.patternadapter.BDSJDBCReader.externalizeCheckpointInformation

      O DEBUG->jobid: HubChange:00432/HubChangeStep1:com.ibm.websphere.batch.devframework.datastreams.patternadapter.BDSFileWriter.externalizeCheckpointInformation Current Position= 0

      O DEBUG->jobid: HubChange:00432/HubChangeStep1:com.ibm.websphere.batch.devframework.datastreams.patternadapter.BDSJDBCReader.intermediateCheckpoint