Problems when retrieving data from a DB2 database

If you receive error messages when retrieving data from a DB2® version 9 or later database, you might need to replace the DB2 JDBC driver.

Example message

This problem is indicated by a NoSuchMethodException similar to the following exception:

[7/1/10 17:18:30:180 CDT] 00000026 BeanRowMapper E com.ibm.tyto.jdbc.beans.mapper.BeanRowMapper mapRow Bean method was not found. 
                                 java.lang.NoSuchMethodException 
        at com.ibm.tyto.jdbc.beans.mapper.BeanHandler.primitiveSwitch(BeanHandler.java:162) 
        at com.ibm.tyto.jdbc.beans.mapper.BeanHandler.relaxedSet(BeanHandler.java:124) 
        at com.ibm.tyto.jdbc.beans.mapper.BeanHandler.setSimpleProperty(BeanHandler.java:93) 
        at com.ibm.tyto.jdbc.beans.mapper.BeanRowMapper.mapRow(BeanRowMapper.java:63) 
        at com.ibm.tyto.jdbc.beans.mapper.BeanRowMapper.mapRow(BeanRowMapper.java:42) 
        at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92) 
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:653) 
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) 
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)

Action

Confirm the source of the problem by retrieving the version number of the DB2 JDBC driver. To retrieve the version number, enter the following command at a command line:

java -cp db2jcc4.jar  com.ibm.db2.jcc.DB2Jcc -version

If the version number returned is from 3.58 through 3.58.104, you must replace the driver.

You can upgrade or downgrade the driver to overcome this problem. The DB2 JDBC driver is db2jcc4.jar. See http://www-01.ibm.com/support/docview.wss?uid=swg1PM03785&myns=swgimgmt&mynp=OCSSEPEK&mync=R .