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