org.hibernate.exception.SQLGrammarException: could not execute query

 selectAll org.hibernate.exception.SQLGrammarException:
 could not execute query org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630)
 org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:75)
 com.payeco.dao.DBUtil.selectAll(DBUtil.java:353)
 com.payeco.dao.DictionDAO.selectByParentCode(DictionDAO.java:43)
 com.payeco.action.ListBusiTypeAction.doPost(ListBusiTypeAction.java:39)
 com.payeco.action.ListBusiTypeAction.doGet(ListBusiTypeAction.java:33)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
 org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
 org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
 org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
 java.lang.Thread.run(Thread.java:662)
17:29:54,704 INFO  [STDOUT] 2012-11-10 17:29:54,703 INFO  [com.payeco.dao.DBUtil] log sqlend 0 9

 

解决方案：

 检查POJO类的命名数据库表的列名是否与数据库表的列名一一对应！