[jbpm-issues] [JBoss JIRA] Updated: (JBPM-2642) A patch to support DB2 on zOS

A patch to support DB2 on zOS ----------------------------- Key: JBPM-2642 URL: https://jira.jboss.org/jira/browse/JBPM-2642 Project: jBPM Issue Type: Patch Security Level: Public(Everyone can see) Components: Runtime Engine Affects Versions: jBPM 3.2.7, jBPM 3.2.8 Environment: Java version: 1.6.0_16,Sun Microsystems Inc., OS-System: Windows XP 5.1,x86, jboss-soa-p.4.3.0, DB2, version: DSN09015, Hibernate 3.2.4.sp1.cp08 Reporter: Richard L. Burton III Priority: Blocker Attachments: findJobsWithOverdueLockTime.patch When using jBPM with DB2 on zOS the JobSession object throws an exception when trying to find jobs with overdue lock time. The exception thrown is: DB2 SQL error: SQLCODE: -180, SQLSTATE: 22007, SQLERRMC: 1 I attached a patch which corrects this problem. Currently JobSession#findJobsWithOverdueLockTime(Date) is using Query#setDate(..) instead of Query#setTimestamp(...) This isn't a problem when using the DB2 Universal version on windows, only on zOS. Regards, Richard L. Burton III