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

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

    Re: getInitialLookupQuery()

    ‏2012-03-21T17:22:20Z  
    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

    Re: getInitialLookupQuery()

    ‏2012-03-21T19:23:35Z  
    • sajan
    • ‏2012-03-21T17:22:20Z
    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.
    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