Thursday, December 15, 2011

CLI0611E Invalid column name. SQLSTATE=S0022

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E  Invalid column name. SQLSTATE=S0022
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(Unknown Source)
    at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(Unknown Source)
    at COM.ibm.db2.jdbc.app.DB2ResultSet.getString(Unknown Source)

As the get above error suggest, The column name specified in the Query or in resultSet is invalid.

resultSet.getString("COLUMN_NAME");

Please re-check all the column names against table name and make sure it is correct.