SimplePropertiesTriggerPersistenceDelegateSupport incorrectly loads properties of type long

[kirmerzlikin]

When loading extended trigger properties, SimplePropertiesTriggerPersistenceDelegateSupport loads properties of type long as ints:

quartz/quartz/src/main/java/org/quartz/impl/jdbcjobstore/SimplePropertiesTriggerPersistenceDelegateSupport.java

Lines 162 to 163 in a5c4d27

	properties.setLong1(rs.getInt(COL_LONG_PROP_1));
	properties.setLong2(rs.getInt(COL_LONG_PROP_2));

This leads to an exception, when values exceed the max value of int:

Couldn't retrieve trigger: Invalid data conversion: requested conversion would result in a loss of precision of 9223372036854775807
org.quartz.JobPersistenceException: Couldn't retrieve trigger: Invalid data conversion: requested conversion would result in a loss of precision of 9223372036854775807 [See nested exception: java.sql.SQLDataException: Invalid data conversion: requested conversion would result in a loss of precision of 9223372036854775807]
	at app//org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1539)
	at app//org.quartz.impl.jdbcjobstore.JobStoreSupport$12.execute(JobStoreSupport.java:1527)
	at app//org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864)
	at app//org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:95)
	at app//org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3800)
	at app//org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1524)

To fix this, SimplePropertiesTriggerPersistenceDelegateSupport needs to load these values using java.sql.ResultSet#getLong().

PS: I understand that this project seems to be abandoned (#1134), so I'm reporting this for posterity's sake.

[lprimak]

This project is abandoned. See #1134

[kirmerzlikin]

@lprimak What is the point of stating something that is already mentioned in the issue description?