Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
90 Posts
ACCEPTED ANSWER

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