在Play框架平台开发中遇到这样一个报错,
java代码如下:
public MonEntity queryMonEntityByName(String name){
return Mon.find("from MonEntity where LOG= ?", name).first();
}
报错信息如下:
Error during job execution (job.CrashJob)
Execution exception (In /app/models/dao/MonDao.java around line 281)
IllegalArgumentException occured : Parameter value [camera] was not matching type [java.lang.Double]
play.exceptions.JavaExecutionException: Parameter value [camera] was not matching type [java.lang.Double]
at play.jobs.Job.call(Job.java:155)
at play.jobs.Job$1.call(Job.java:66)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Parameter value [camera] was not matching type [java.lang.Double]
at org.hibernate.ejb.AbstractQueryImpl.registerParameterBinding(AbstractQueryImpl.java:360)
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:435)
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:72)
at play.db.jpa.JPQL.bindParameters(JPQL.java:174)
at play.db.jpa.JPQL.find(JPQL.java:48)
at models.po.MonEntity.find(MonEntity.java)
at models.dao.MonDao.queryMonEntityByName(MonDao.java:281)
at job.CrashJob.doJob(CrashJob.java:40)
at play.jobs.Job.doJobWithResult(Job.java:50)
at play.jobs.Job.call(Job.java:146)
... 7 more
类型匹配错误,检查了数据库,LOG的类型为varchar没错。纳闷
索性换一种写法,将查询语句改为:
public MonEntity queryMonEntityByName(String name){
return MonEntity.find("from MonEntity where LOG= '"+name+"'").first();
}
测试通过。
不知道什么情况,之前一直用?匹配参数。