Oct 20th, 2010, 08:17 AM
Job Parameter Value too large for Column
Is it possible to modify the length of the STRING_VAL in the BATCH_JOB_PARAMS table without impacting the framework ?
CREATE TABLE BATCH_JOB_PARAMS (
JOB_INSTANCE_ID BIGINT NOT NULL ,
TYPE_CD VARCHAR(6) NOT NULL ,
KEY_NAME VARCHAR(100) NOT NULL ,
STRING_VAL VARCHAR(250) ,
DATE_VAL TIMESTAMP DEFAULT NULL,
LONG_VAL BIGINT ,
DOUBLE_VAL DOUBLE PRECISION,
constraint JOB_INSTANCE_PARAMS_FK foreign key (JOB_INSTANCE_ID)
I would like to increase the size to about 750. Or is there a work around this without database changes ? One of the parameters I need to store is larger than the 250 allowed in the STRING_VAL column.
Oct 21st, 2010, 10:54 AM
I've extended mine to quite a bit more than that and it's fine.
I don't think the JdbcJobInstanceDao checks string length before inserting the parameter, so you shouldn't need to change anything else.
Tags for this Thread