Hi,

I am trying to retrieve date from one persistent class which has primary key as an Integer datatype, as follows annotation.

@Id(generate = GeneratorType.AUTO)
@Column(name = "seq_no")
public Integer getSeqNo() {
return SeqNo;
}


When I try to retrieve the data using the following code, I always get the following error.

Retrieve Code:

Criteria criteria = session.createCriteria(RateLockData.class)
.add(Expression.eq("seqNo", seqNo));

RateLockData ratelock = (RateLockData) criteria.uniqueResult();

Error Message:

java.lang.ClassCastException: java.lang.Integer
at org.hibernate.type.StringType.toString(StringType.java:42)
at org.hibernate.type.NullableType.toLoggableString(NullableType.java:122)

I use Hibernate3. Does anyone has solutions for this ?

Thanks.

If I recall correctly then Hibernate has bug here. You need to specify type of ID explicitly. Hibernate cannot infer it via reflection when annotations are used

I used something like this:



And that worked fine with this criteria :



I am using the latest build of hibernate annotations and hibernate

Try adding this:
@Id
@Type(type="java.lang.Integer")
@GeneratedValue(strategy=GenerationType.AUTO)
@Column(name="id_solicitacao", nullable=false)
public Integer getId() {
return id;
}