I have a entity bean like this:
PlayScoreBean
public class PlayScoreBean implements java.io.Serializable{
...
private Integer rawScore;
public Integer getRawScore() {
return rawScore;
}
public void setRawScore(Integer rawScore) {
this.rawScore=rawScore;
}
}
Double mean=...
query = entityManager.createQuery(
"select sum((c.rawScore-:mean)*(c.rawScore-:mean)) "
+ " from PlayScoreBean as c ");
query.setParameter("mean", mean);
Double standardDeviation=(Double) query.getSingleResult();
[IntegerType] could not bind value '150.14285714285714' to pa rameter: 1; java.lang.Double [STDERR] java.lang.ClassCastException: java.lang.Double