struts+Hibernate+mysql 出错

xuqingsong1981

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: could not execute query
        org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:514)
        org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
        org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
        org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

org.hibernate.exception.SQLGrammarException: could not execute query
        org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
        org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        org.hibernate.loader.Loader.doList(Loader.java:2150)
        org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
        org.hibernate.loader.Loader.list(Loader.java:2021)
        org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
        org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:296)
        org.hibernate.impl.SessionImpl.list(SessionImpl.java:992)
        org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
        cn.com.shoppingonline.DbOperate.getOrder(DbOperate.java:134)
        cn.com.shoppingonline.CreateOrderAction.execute(CreateOrderAction.java:80)
        org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
        org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
        org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

应该是查询参数的问题,where orderno='1111111'可以,如果orderno='q111111'也就是参数带字符就报错

请指教啊



_______________________

fantix

用native sql在mysql客户端里试试吧，应该有resonable的出错提示。

whuige

应该是查询参数的问题,where orderno='1111111'可以,如果orderno='q111111'也就是参数带字符就报错
---------------------------------------
看看数据库中orderno对应的字段是什么属性？ 是不是数字型的? 如果是字符型的， 检查对应的hbm.xml中配置的是什么类型的orderno.