存儲(chǔ)過(guò)程代碼：CREATEPROCEDUREgetallid()BEGINselectsum(id)fromuser;ENDJavaDAO層代碼：@OverridepublicintfindAllId(){Queryquery=this.entityManager.createQuery("callgetallid()");inti=(int)query.getSingleResult();returni;}報(bào)錯(cuò)原因：org.hibernate.hql.internal.ast.QuerySyntaxException:unexpectedtoken:callnearline1,column1[callgetallid()]atorg.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:91)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:291)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:186)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:115)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:77)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:553)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:662)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atorg.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)~[na:1.8.0_144]atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)~[na:1.8.0_144]atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)~[na:1.8.0_144]atjava.lang.reflect.Method.invoke(Method.java:498)~[na:1.8.0_144]
請(qǐng)問(wèn)springboot+hibernate的項(xiàng)目，怎么通過(guò)hql調(diào)用存儲(chǔ)過(guò)程和存儲(chǔ)函數(shù)（mysql）。
猛跑小豬
2019-05-22 17:23:30
