Job Parameter Value too large for Column

[kunlenzo247]

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)
references BATCH_JOB_INSTANCE(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.


Thanks.

[KristanM]

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.