[#BATCH-595] Incorrect JDBC type for job parameters of long type

Spring Batch

Incorrect JDBC type for job parameters of long type

Created: 22/Apr/08 03:59 AM Updated: 07/Aug/08 10:07 AM

Component/s:

Core

Affects Version/s:

1.0.0

Fix Version/s:

1.0.1

Time Tracking:

Not Specified

Environment:

Java 6u4, Windows Vista, MySql 5.0.45

Description

« Hide

The JDBC type for long parameters is Types.INTEGER in JdbcJobInstanceDao.insertParameter. This makes the values become truncated to int before they are inserted into the table. The type should probably be Types.BIGINT.

All

Comments

Work Log

Change History

FishEye

Builds

Sort Order:

[ Permlink | « Hide ]

Robert Kasanicky added a comment - 22/Apr/08 06:27 AM

Replaced Types.INTEGER with Types.BIGINT as suggested. Also used Long.MAX_VALUE parameter value in tests, however the in-memory hsqldb works fine even with Types.INTEGER, so +1 on BATCH-488.

[ Permlink | « Hide ]

Dave Syer added a comment - 07/Aug/08 10:07 AM

Assume closed as resolved and released