[jbpm-issues] [JBoss JIRA] Created: (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.8, jBPM 3.2.7 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira