Topic
  • No replies
SystemAdmin
SystemAdmin
90 Posts

Pinned topic Problem using pureQuery 2.2.0.3 with an XA dataso DB2 9.1 for zOS

‏2011-09-26T09:50:13Z |
Hi,

I am running an EJB session bean application in WAS 7 using an XA datasource ( com.ibm.db2.jcc,XADataSource ).
The DataSource has a "pdqProperties" custom property that has the value "captureMode OFF, executionMode DYNAMIC" defined for it.
My application does a startBatch() call on the pureQuery data interface, when I hit upon the following stacktrace.
I also have a "pdq.appwide.properties" file in the application EAR in a jar file and also in the root directory in the EAR file, which contains just the property line "pdq.executionMode=DYNAMIC".

The interesting thing is that, if I use a non-XA ( just connection pool com.ibm.db2.jcc.DB2ConnectionPoolDataSource class ) datasource,
the application works just fine.

So, the question is, why does the XA datasource give this problem ?

Any help will be much appreciated.

The stack trace


System.err: 09/26/11 11:06:14:205 EEST com.ibm.pdq.runtime.exception.DataRuntimeException: pdq10231http://2.18.120 The DB2 Connection must implement PDQConnection for the application to run in STATIC mode.; Caused by: java.lang.ClassCastException: com.ibm.db2.jcc.t4.c incompatible with com.ibm.db2.jcc.PDQConnection
System.err: 09/26/11 11:06:14:205 EEST

System.err: 09/26/11 11:06:14:205 EEST at com.ibm.pdq.runtime.internal.db.db2.DB2JdbcData.unwrapDB2WrapperForPDQConnection(DB2JdbcData.java:145)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.pdq.runtime.internal.db.db2.DB2JdbcData.registerCallback(DB2JdbcData.java:92)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.pdq.runtime.internal.db.db2.DB2JdbcData.startBatch(DB2JdbcData.java:333)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.pdq.runtime.generator.BaseData.startBatch(BaseData.java:1070)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at fi.tapiola.tita.jay.batch.devframework.datastreams.patternadapter.TiTaBDSPureQueryWriter.write(TiTaBDSPureQueryWriter.java:202)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.websphere.batch.devframework.steps.technologyadapters.GenericXDBatchStep.processJobStep(GenericXDBatchStep.java:234)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.DefaultBatchJobStepBean.processJobStep(DefaultBatchJobStepBean.java:87)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.websphere.batch.EJSLocalCMPMyStep1_d09b9a90.processJobStep(EJSLocalCMPMyStep1_d09b9a90.java:61)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.StepSetup$BatchLoopExecutor.regularBatchJobExecution(StepSetup.java:2500)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.StepSetup$BatchLoopExecutor.executeAction(StepSetup.java:2468)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.AbstractUserPrivilegedAction.runWithoutSecurity(AbstractUserPrivilegedAction.java:59)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.StepSetup.runUnderUserCredential(StepSetup.java:2322)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:206 EEST at com.ibm.ws.batch.StepSetup.batchLoop(StepSetup.java:679)
System.err: 09/26/11 11:06:14:206 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.batch.StepSetup.executeStep(StepSetup.java:1155)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.batch.JobSetup.callStep(JobSetup.java:1052)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.batch.JobSetup.sequentialStepScheduling(JobSetup.java:774)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.batch.JobSetup.setupJobSteps(JobSetup.java:573)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.websphere.batch.BatchEnhancedContainer.DispatchJob(BatchEnhancedContainer.java:45)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.batch.BatchJobControllerWork.run(BatchJobControllerWork.java:158)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:264)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at java.security.AccessController.doPrivileged(AccessController.java:202)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1137)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:188)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST at java.lang.Thread.run(Thread.java:736)
System.err: 09/26/11 11:06:14:207 EEST

System.err: 09/26/11 11:06:14:207 EEST Caused by:
System.err: 09/26/11 11:06:14:208 EEST java.lang.ClassCastException: com.ibm.db2.jcc.t4.c incompatible with com.ibm.db2.jcc.PDQConnection
System.err: 09/26/11 11:06:14:208 EEST

System.err: 09/26/11 11:06:14:208 EEST at com.ibm.pdq.runtime.internal.db.db2.DB2JdbcData.unwrapDB2WrapperForPDQConnection(DB2JdbcData.java:142)
System.err: 09/26/11 11:06:14:208 EEST

System.err: 09/26/11 11:06:14:208 EEST ... 24 more
System.err: 09/26/11 11:06:14:208 EEST
cheers,
jay