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 | 4 months ago
  1. 1

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

    Stack Overflow | 4 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
  2. 0

    SQDR Plus Troubleshooting Tips

    starquest.com | 1 year ago
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][3.65.77] Invalid data conversion: Parameter instance ?1?0.?00 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815
  3. 0

    PreparedStatementCallback; bad SQL grammar in JDBC Spring

    Stack Overflow | 4 years ago | Ashish
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update product.typecategory set taxonomydescription = ? where taxonomydescription = ?]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10824][4.13.127] Invalid data conversion: Parameter instance [Ljava.lang.Object;@1dc421 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    connection error with db2 jdbc

    Stack Overflow | 5 months ago | Mr Smith
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.63.75] Invalid database URL syntax: jdbc:db2:/dxxx_xxx.xxx.com:5000/XXXXX:deferPrepares=false. ERRORCODE=-4461, SQLSTATE=42815
  6. 0

    DB2 ERRORCODE=-4461, SQLSTATE=42815 clob field

    Stack Overflow | 1 year ago | user3560604
    org.artificer.common.error.ArtificerServerException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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