DB2 JDBC broke spring display of parameter name

Question

We have an application that uses spring to make calls to DB2 stored procedures.

The application works fine with jdbc version 1.XX.XX (and DB2 V8). A recent upgrade to DB2 V9 allows us to use jdbc versiong 3.58.90 instead.

However, this seems to have broken the named parameter mapping in spring (version 2.5.5). In some previous working code there was a call line

call storedproc123(:id,:date) 

now throws exceptions with

 [jcc][t4][10427][12544][3.58.90] Error parsing FLOAT literal value starting at index 19. Error Detail:Unexpected character ':' found in FLOAT literal. ... ERRORCODE=-4463, SQLSTATE=42601 ... 

Has anyone come across something similar?

Thanks in advance!

--- edited to add additional information ---

I tried replacing the old jdbc back after updating. The application works fine with the old driver, however we would like to switch to the new version, since another application on the same server needs this new jdbc, and it is difficult to have different versions of the same jdbc deployed on our server (we use JBoss).

http://redneckprogrammer.blogspot.com/2009/10/running-multiple-versions-of-oracle.html discussed how to deploy multiple versions of the same JDBC driver, however, it seems like this is too big a problem. d would like to avoid this, if at all possible.

Answer 1

Cause found, see IBM PK87567 hotfix .

...

All connections: the driver code was expanded to support the new API at com.ibm.db2.jcc.DB2ParameterMetaData: getParameterMarkerNames, which returns a list of parameters marker names used in the SQL statement as a string. This method returns the null property if enableNamedParameterMarkers is set to DB2BaseDataSource.NOT_SET or DB2BaseDataSource.NO, or if there are no named marker parameters in the SQL statement. The returned list contains unique parameter marker names. If the named parameter marker is displayed more than once in the SQL Statement, it will appear only once in the returned list. (120191)

...

The problem with turning on the marker is fixed.