java.sql.SQLException: 列名无效

 [org.hibernate.util.JDBCExceptionReporter] - 列名无效
09:32:14,501 INFO  [STDOUT] 2131754 [http-0.0.0.0-8888-5] ERROR org.hibernate.util.JDBCExceptionReporter  - 列名无效
09:32:14,502 INFO  [STDOUT] 16-09-13 09:32:14,502 ERROR [root] - 加载Servlet:com.sunsheen.jfids.system.data.grid.GridDataServlet,出现错误,错误原因：could not execute query
09:32:14,502 INFO  [STDOUT] 2131755 [http-0.0.0.0-8888-5] ERROR root  - 加载Servlet:com.sunsheen.jfids.system.data.grid.GridDataServlet,出现错误,错误原因：could not execute query
09:32:14,502 ERROR [STDERR] org.hibernate.exception.GenericJDBCException: could not execute query
09:32:14,502 ERROR [STDERR]  at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
09:32:14,502 ERROR [STDERR]  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
09:32:14,502 ERROR [STDERR]  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
09:32:14,502 ERROR [STDERR]  at org.hibernate.loader.Loader.doList(Loader.java:2536)
09:32:14,502 ERROR [STDERR]  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
09:32:14,503 ERROR [STDERR]  at org.hibernate.loader.Loader.list(Loader.java:2271)
09:32:14,503 ERROR [STDERR]  at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
09:32:14,503 ERROR [STDERR]  at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:2146)
09:32:14,503 ERROR [STDERR]  at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
09:32:14,503 ERROR [STDERR]  at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
09:32:14,503 ERROR [STDERR]  at com.sunsheen.jfids.system.data.base.QueryDBForListImpl.getDataList(Unknown Source)
09:32:14,503 ERROR [STDERR]  at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.implementation.java.invocation.JavaImplementationInvoker.invoke(JavaImplementationInvoker.java:156)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.binding.sca.impl.SCABindingInvoker.invoke(SCABindingInvoker.java:61)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:349)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:193)
09:32:14,503 ERROR [STDERR]  at com.sun.proxy.$Proxy136.getDataList(Unknown Source)
09:32:14,503 ERROR [STDERR]  at com.sunsheen.jfids.system.data.grid.GridDataSourceImpl.getComponent(Unknown Source)
09:32:14,503 ERROR [STDERR]  at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Unknown Source)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.implementation.java.invocation.JavaImplementationInvoker.invoke(JavaImplementationInvoker.java:156)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.binding.sca.impl.SCABindingInvoker.invoke(SCABindingInvoker.java:61)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:349)
09:32:14,503 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:193)
09:32:14,503 ERROR [STDERR]  at com.sun.proxy.$Proxy133.getComponent(Unknown Source)
09:32:14,503 ERROR [STDERR]  at com.sunsheen.jfids.system.base.composite.data.page.java.PageDataServiceImpl.getData(Unknown Source)
09:32:14,503 ERROR [STDERR]  at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
09:32:14,506 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
09:32:14,506 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Unknown Source)
09:32:14,506 ERROR [STDERR]  at org.apache.tuscany.sca.implementation.java.invocation.JavaImplementationInvoker.invoke(JavaImplementationInvoker.java:156)
09:32:14,506 ERROR [STDERR]  at org.apache.tuscany.sca.binding.sca.impl.SCABindingInvoker.invoke(SCABindingInvoker.java:61)
09:32:14,506 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:349)
09:32:14,506 ERROR [STDERR]  at org.apache.tuscany.sca.core.invocation.JDKInvocationHandler.invoke(JDKInvocationHandler.java:193)
09:32:14,506 ERROR [STDERR]  at com.sun.proxy.$Proxy130.getData(Unknown Source)

图片：5.png

这种情况，一般是数据查询文件的错，查询结果和查询列名要一一对应：

图片：093707.png