I am executing a simple select HQL query
from CertObjRel where certificatePrimary in (:certificatePrimaryList) where certificatePrimaryList is a java arrayList of certificatePrimary
CertificatePrimary class: class CertificatePrimary implements Serializable{ //private int primaryId; private String certificateId; private Short trsSequenceNbr;
public String getCertificateId() { return certificateId; }
public Short getTrsSequenceNbr() { return trsSequenceNbr; }
public void setCertificateId(String certificateId) { this.certificateId = certificateId; }
public void setTrsSequenceNbr(Short trsSequenceNbr) { this.trsSequenceNbr = trsSequenceNbr; } }
CertObjRelMapping contains CertificatePrimary as component
CertObjRel.hbm.xml
<component name="certificatePrimary" class="com.csc.exceed.certificate.domain.CertificatePrimary"> <property name="certificateId" type="java.lang.String" column="CERT_ID" length="36" not-null="true"/> <property name="trsSequenceNbr" type="java.lang.Short" column="CERT_TRS_SEQ_NBR" /> </component>
I am getting the following error
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=(;RT_TRS_SEQ_NBR) in (;<values>, DRIVER=3.50.152 )
|