com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.13.80] Invalid data conversion: Parameter instance REC_ID is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815

Stack Overflow | User45 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 1

    Parameter instance recId is invalid for the requested conversion. ERRORCODE=-4461

    Stack Overflow | 8 months ago | User45
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.13.80] Invalid data conversion: Parameter instance REC_ID is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815

    Root Cause Analysis

    1. com.ibm.db2.jcc.am.SqlSyntaxErrorException

      [jcc][1091][10404][4.13.80] Invalid data conversion: Parameter instance REC_ID is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815

      at com.ibm.db2.jcc.am.id.a()
    2. IBM DB2
      go.setString
      1. com.ibm.db2.jcc.am.id.a(id.java:677)
      2. com.ibm.db2.jcc.am.id.a(id.java:60)
      3. com.ibm.db2.jcc.am.id.a(id.java:103)
      4. com.ibm.db2.jcc.am.kc.a(kc.java:774)
      5. com.ibm.db2.jcc.am.kc.a(kc.java:689)
      6. com.ibm.db2.jcc.am.go.a(go.java:1583)
      7. com.ibm.db2.jcc.am.go.setString(go.java:1538)
      7 frames
    3. IronJacamar
      WrappedPreparedStatement.setString
      1. org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setString(WrappedPreparedStatement.java:637)
      1 frame
    4. Spring Framework
      JdbcTemplate.execute
      1. org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:421)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      2. org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:235)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      3. org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:150)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      4. org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.setValues(PreparedStatementCreatorFactory.java:292)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      5. org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:244)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      6. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:623)[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
      6 frames