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