Method public java.lang.String org.hibernate.exception.NestableRuntimeException.
Hibernate: select count(*) as col_0_0_ from employee employee0_Hibernate: select product0_.productId as productId10_, product0_.productName_cn as productN2_10_, product0_.productName_en as productN3_10_, product0_.product_image as product4_10_, product0_.function_info_cn as function5_10_, product0_.function_info_en as function6_10_, product0_.product_kernel as product7_10_, product0_.product_color as product8_10_, product0_.product_SKU as product9_10_, product0_.product_number as product10_10_, product0_.product_netweight as product11_10_, product0_.product_grossweight as product12_10_, product0_.product_size as product13_10_, product0_.product_pack_size as product14_10_, product0_.product_QTY as product15_10_, product0_.product_outerpack_size as product16_10_, product0_.product_packingweight as product17_10_, product0_.product_key_cn as product18_10_, product0_.product_key_en as product19_10_, product0_.product_meta_cn as product20_10_, product0_.product_meta_en as product21_10_, product0_.product_parameter_cn as product22_10_, product0_.product_parameter_en as product23_10_, product0_.product_categoryId as product24_10_, product0_.supplierId as supplierId10_, product0_.empId as empId10_ from example.product product0_ order by product0_.productId ASC limit ?
2011-04-28 15:37:08,312 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] Unknown column 'product0_.product_netweight' in 'field list'
2011-04-28 15:37:08,359 [freemarker.runtime]-[ERROR]
Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.SQLGrammarException: could not execute query
The problematic instruction:
----------
==> ${msg[0]} [on line 68, column 29 in org/apache/struts2/dispatcher/error.ftl]
----------
Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.SQLGrammarException: could not execute query
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:130)
at freemarker.ext.beans.SimpleMethodModel.get(SimpleMethodModel.java:138)
at freemarker.core.DynamicKeyName.dealWithNumericalKey(DynamicKeyName.java:111)
at freemarker.core.DynamicKeyName._getAsTemplateModel(DynamicKeyName.java:90)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.Expression.getStringValue(Expression.java:93)
at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.IfBlock.accept(IfBlock.java:82)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:179)
at freemarker.core.Environment.visit(Environment.java:415)
at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.IfBlock.accept(IfBlock.java:82)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.Environment.process(Environment.java:188)
at freemarker.template.Template.process(Template.java:237)
at org.apache.struts2.dispatcher.Dispatcher.sendError(Dispatcher.java:703)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:467)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at freemarker.ext.beans.SimpleMemberModel.unwrapArguments(SimpleMemberModel.java:85)
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:106)
... 52 more
2011-4-28 15:37:08 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet default threw exception
java.lang.IllegalStateException
at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:108)
at org.apache.struts2.dispatcher.Dispatcher.sendError(Dispatcher.java:707)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:467)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
--------------------编程问答-------------------- 头都晕了。。。。能不能加点注释啊。。。。 --------------------编程问答-------------------- sql 语法错误了，你用sql语句拿出来运行检查哪里出错了 --------------------编程问答-------------------- 代码使用HQL 数据库用SQL查询 没有出错 --------------------编程问答-------------------- 遇到同样问题！！郁闷了大半天还是没有解决！顶起 --------------------编程问答-------------------- 我也是这个问题。。等解 --------------------编程问答-------------------- Caused by: java.lang.NullPointerException
首先定位出现问题的地方，单步调试看哪里报的空指针异常... --------------------编程问答-------------------- 兄弟，是数据库驱动的问题，如果你用的是oracle,你可以到我的资源里去看看，有个叫oracle_jdbc14.jar的驱动包，下载下去，替换掉你的那个原来的驱动包。我也被这个错搞了几天，现在解决了。祝你好运！！！ --------------------编程问答-------------------- 首先有Hibernate: select count(*) as col_0_0_ from employee employee0...有Hibernate 语句执行，可以定位不是驱动包的问题。
其次Unknown column 'product0_.product_netweight' in 'field list'可见你是有写无法识别的Sql语句，可以确定是部分Sql语句的错误。
好好检查一下，你会有收获的。。。。 --------------------编程问答--------------------
--------------------编程问答--------------------
Unknown column 'product0_.product_netweight' in 'field list' 应该是在field list 里没有product0_.product_netweight这一列 查查看是不是名字写错了 或者数据库里没这列
--------------------编程问答--------------------
到底怎么解决的啊。。。。。。。。生成的sql语句 可以再数据库中执行成功，但是还是抱着个错、、、
--------------------编程问答--------------------
我也遇到同样的问题啊！ 有处理的了吗？ 分享下啊
--------------------编程问答--------------------
你们解决了没有
--------------------编程问答--------------------
我刚刚也遇到这样的问题了 你们怎么解决的？？？
--------------------编程问答--------------------
我碰到过类似的 报的错也差不多 我的解决办法是将实体bean里面的关联字段过滤掉 因为在action里面 不能进行级联查询(默认的懒加载)
--------------------编程问答--------------------
以上我也出现过一样的的错误，最后通过调试发现，语法没有问题，此时只能是数据库的问题了，最后一看数据库，发现多了一个字段，这些都很常见的，在做项目是有时别人改了数据库没有及时的通知做成的错误，解决方法：1.检查写的sql语句，或者hql语句的语法
2.查看数据库的表结构是否被修改写
[ERROR] Unknown column 'product0_.product_netweight' in 'field list',这个问题已经说明了，是这一列增加或者删除了。 --------------------编程问答-------------------- 2011-04-28 15:37:08,312 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] Unknown column 'product0_.product_netweight' in 'field list'
这个错误很明显，首先你把hibernate生成sql在数据库执行看是否有问题。
如果没有问题继续分析：你先写个测试类保证你的jdbc驱动没有问题。
然后再看：
Caused by: java.lang.NullPointerException
at freemarker.ext.beans.SimpleMemberModel.unwrapArguments(SimpleMemberModel.java:85)
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:106)这个单步调试debug应该可以找到这个null的问题。
最后关注一下是否你的对象lazy加载方式，有可能是因为对象还没有赋值，却已经调用的问题。
是在不行断点。应该可以发现！祝你luck！
补充：Java , Web 开发
