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

[Venkata Sirish]

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.

Code:

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.

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

[Peter Mularien]

Hi Venkata,

You'll have to give us a bit more information - what code are you using to call this "TESTSP"?

Best,
Peter

[Venkata Sirish]

Peter, i am using the below Spring class to make stored procedure calls.

org.springframework.jdbc.object.StoredProcedure