Issue when migrating from Spring 2.5 to Spring 2.5.6 SEC 02 version

[gurumvg]

Hi,

Recently we have migrated from Spring 2.5 to Spring 2.5.6 SEC 02 version.

We see below error when we perform a database (DB2) call.


org.springframework.jdbc.UncategorizedSQLException : CallableStatementCallback; uncategorized SQLException for SQL [{call TESTSP(?, ?, ?, ?, ?)}]; SQL state [39004]; error code [-470]; DB2 SQL error: SQLCODE: -470, SQLSTATE: 39004, SQLERRMC: 1; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -470, SQLSTATE: 39004, SQLERRMC: 1

org.springframework.jdbc.UncategorizedSQLException : CallableStatementCallback; uncategorized SQLException for SQL [{call TESTSP(?, ?, ?, ?, ?)}]; SQL state [39004]; error code [-470]; DB2 SQL error: SQLCODE: -470, SQLSTATE: 39004, SQLERRMC: 1; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -470, SQLSTATE: 39004, SQLERRMC: 1

The SQLCODE -470 is returned when NULL values are passed to IN/OUT parameter of the Stored proc. But i could see that the parameters are getting passed as expected.

Also, when using the previous spring version(2.5) the db calls were working fine but when we moved to Spring 2.5.6 SEC 02 version we are seeing this strange issue.

Iam unable to figure it out the reason why spring 2.5.6 is behaving this way.:confused:

Any help will be really appreciated. Thanks for your time and attention in advance.