Quartz « db2 « Java Database Q&A





1. Sql error -204 on DB2 datasource connections after server aging    forums.terracotta.org

Hi, We're using quartz 1.5.2 in a clustered environment. Our application which runs in WebSphere 6.1. We're letting quartz manage its own connection pool. Our database is DB2 8.1 on z/os. When the server starts up, everything works fine for a while. After some time passes, the quartz datasource pool connections error out with a -204 which indicates that the table ...

2. DB2 and Quartz    forums.terracotta.org

Hello, We've installed Quartz in combination with a DB2 database. When storing a trigger the following exception is thrown: Couldn't store trigger: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null The Error code 302 has the following description: SQLCODE -302, Error: THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE ...