Why Hibernate is binding same parameter twice for entity identity column ?
Issue
- Why Hibernate is
bindingsame parameter twice inSQL statementwhen trying topersist an entitymapped withread-only identity @Columnand throwingSQL exceptioncaused by"Parameter index is out of range"? - Why application is throwing
"Parameter index is out of range"error onDB2database ?
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10145][10844][4.11.88] Invalid parameter 4: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.gd.a(gd.java:676)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:103)
at com.ibm.db2.jcc.am.ln.e(ln.java:5080)
at com.ibm.db2.jcc.am.ln.d(ln.java:5073)
at com.ibm.db2.jcc.am.ln.a(ln.java:1362)
at com.ibm.db2.jcc.am.ln.setString(ln.java:1351)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setString(WrappedPreparedStatement.java:637)
at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:57) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:92) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:358) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrateId(AbstractEntityPersister.java:2814) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2783) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3055) [hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final-redhat-1]
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.x
- Hibernate
- 4.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.