{"action":"created","issue":{"url":"https://api.github.com/repos/itdida/itdida-issues/issues/157","repository_url":"https://api.github.com/repos/itdida/itdida-issues","labels_url":"https://api.github.com/repos/itdida/itdida-issues/issues/157/labels{/name}","comments_url":"https://api.github.com/repos/itdida/itdida-issues/issues/157/comments","events_url":"https://api.github.com/repos/itdida/itdida-issues/issues/157/events","html_url":"https://github.com/itdida/itdida-issues/issues/157","id":314878171,"number":157,"title":"代理流水账界面全选导出，系统报错","user":{"login":"WENLINRONG","id":37489976,"avatar_url":"https://avatars1.githubusercontent.com/u/37489976?v=4","gravatar_id":"","url":"https://api.github.com/users/WENLINRONG","html_url":"https://github.com/WENLINRONG","followers_url":"https://api.github.com/users/WENLINRONG/followers","following_url":"https://api.github.com/users/WENLINRONG/following{/other_user}","gists_url":"https://api.github.com/users/WENLINRONG/gists{/gist_id}","starred_url":"https://api.github.com/users/WENLINRONG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WENLINRONG/subscriptions","organizations_url":"https://api.github.com/users/WENLINRONG/orgs","repos_url":"https://api.github.com/users/WENLINRONG/repos","events_url":"https://api.github.com/users/WENLINRONG/events{/privacy}","received_events_url":"https://api.github.com/users/WENLINRONG/received_events","type":"User","site_admin":false},"labels":[{"id":871171021,"url":"https://api.github.com/repos/itdida/itdida-issues/labels/%E7%B4%A7%E6%80%A5","name":"紧急","color":"d73a4a","default":false}],"state":"open","locked":false,"assignee":{"login":"iamforrest","id":2240276,"avatar_url":"https://avatars2.githubusercontent.com/u/2240276?v=4","gravatar_id":"","url":"https://api.github.com/users/iamforrest","html_url":"https://github.com/iamforrest","followers_url":"https://api.github.com/users/iamforrest/followers","following_url":"https://api.github.com/users/iamforrest/following{/other_user}","gists_url":"https://api.github.com/users/iamforrest/gists{/gist_id}","starred_url":"https://api.github.com/users/iamforrest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iamforrest/subscriptions","organizations_url":"https://api.github.com/users/iamforrest/orgs","repos_url":"https://api.github.com/users/iamforrest/repos","events_url":"https://api.github.com/users/iamforrest/events{/privacy}","received_events_url":"https://api.github.com/users/iamforrest/received_events","type":"User","site_admin":false},"assignees":[{"login":"iamforrest","id":2240276,"avatar_url":"https://avatars2.githubusercontent.com/u/2240276?v=4","gravatar_id":"","url":"https://api.github.com/users/iamforrest","html_url":"https://github.com/iamforrest","followers_url":"https://api.github.com/users/iamforrest/followers","following_url":"https://api.github.com/users/iamforrest/following{/other_user}","gists_url":"https://api.github.com/users/iamforrest/gists{/gist_id}","starred_url":"https://api.github.com/users/iamforrest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iamforrest/subscriptions","organizations_url":"https://api.github.com/users/iamforrest/orgs","repos_url":"https://api.github.com/users/iamforrest/repos","events_url":"https://api.github.com/users/iamforrest/events{/privacy}","received_events_url":"https://api.github.com/users/iamforrest/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-04-17T02:05:04Z","updated_at":"2018-04-17T02:13:12Z","closed_at":null,"author_association":"COLLABORATOR","body":"代理流水账界面全选导出，系统报错\r\n![image](https://user-images.githubusercontent.com/37489976/38844589-be81937a-4226-11e8-94d5-224dca9a84ed.png)\r\n\r\n发生错误\r\n\r\n信息：org.hibernate.exception.SQLGrammarException：无法提取的ResultSet \r\n堆栈：javax.persistence.PersistenceException：org.hibernate.exception.SQLGrammarException：无法提取的ResultSet \r\n在org.hibernate.internal.ExceptionConverterImpl.convert（ExceptionConverterImpl.java:149 ）\r\n在org.hibernate.query.Query.getResultList （查询）\r\n中的org.hibernate.query.internal.AbstractProducedQuery.list（AbstractProducedQuery.java:1423 ）处的org.hibernate.internal.ExceptionConverterImpl.convert（ExceptionConverterImpl.java:157）\r\n。 java：146）\r\nat com.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController.exportDeliLiuShuiZhang（DaiLiLiuShuiZhangController.java:309）\r\n在\r\norg.springframework.aop上的org.springframework.cglib.proxy.MethodProxy.invoke（MethodProxy.java:204）\r\n上的com.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController $$ FastClassBySpringCGLIB $$ c034a386.invoke（<generated>）。.framework.CglibAopProxy $ CglibMethodInvocation.invokeJoinpoint（CglibAopProxy.java:747）\r\nat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:163）\r\nat org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction（TransactionAspectSupport.java ：294）\r\nat \r\norg.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:185）org.springframework.transaction.interceptor.TransactionInterceptor.invoke（TransactionInterceptor.java:98 ）\r\nat org.springframework.aop.framework.CglibAopProxy $ DynamicAdvisedInterceptor.intercept（CglibAopProxy.java:689）\r\nat com.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController $$ EnhancerBySpringCGLIB $$ b071f61d.exportDaiLiLiuShuiZhang（<generated>）\r\nat com.itdida .web.controllers.caiwu.DaiLiLiuShuiZhangController $$ FastClassBySpringCGLIB $$ c034a386.invoke（<生成>）\r\n在org.springframework.cglib.proxy.MethodProxy.invoke（MethodProxy.java:204）\r\n在org.springframework.aop.framework.CglibAopProxy $ CglibMethodInvocation.invokeJoinpoint（CglibAopProxy.java:747）\r\nat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:163）\r\n在org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction（TransactionAspectSupport.java:294）\r\n在org.springframework.transaction.interceptor.TransactionInterceptor.invoke（TransactionInterceptor.java:98）\r\n在org.springframework.aop.framework.ReflectiveMethodInvocation.proceed （ReflectiveMethodInvocation.java:185）at \r\norg.springframework.aop.framework.CglibAopProxy $ DynamicAdvisedInterceptor.intercept（CglibAopProxy.java:689）\r\nat com.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController $$ EnhancerBySpringCGLIB $$ 2544b27f.exportDaiLiLiuShuiZhang（<生成>）\r\nat com.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController $$ FastClassBySpringCGLIB $$ c034a386.invoke（<generated>）\r\n在org.springframework.cglib.proxy.MethodProxy.invoke（MethodProxy.java:204）\r\n在org.springframework.aop.framework.CglibAopProxy $ CglibMethodInvocation.invokeJoinpoint（CglibAopProxy.java:747）\r\n在org.springframework.aop.framework.ReflectiveMethodInvocation .proceed（ReflectiveMethodInvocation.java:163）\r\n在org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed（DelegatingIntroductionInterceptor.java:136）\r\n在org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke（DelegatingIntroductionInterceptor.java:124）\r\n在有机springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:185）\r\nat org.springframework.aop.framework.CglibAopProxy $ DynamicAdvisedInterceptor.intercept（CglibAopProxy.java:689）\r\ncom.itdida.web.controllers.caiwu.DaiLiLiuShuiZhangController $$ EnhancerBySpringCGLIB $$ a802d902.exportDaiLiLiuLuiShuiZhang（<generated>）\r\nat sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）\r\nat sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java： 62）\r\nat \r\nsun.reflect.DelegatingMethodAccessorImpl.invoke （DelegatingMethodAccessorImpl.java:43）at java.lang.reflect.Method.invoke（Method.java:498）\r\nat org.apache.el.parser.AstValue.invoke（AstValue.java ：247）\r\n在\r\norg.jboss.weld.el.ForwardingMethodExpression.invoke（ForwardingMethodExpression.java:40）\r\n上的org.apache.el.MethodExpressionImpl.invoke（MethodExpressionImpl.java:267）。 WeldMethodExpression.invoke（WeldMethodExpression.java:50）\r\njavax.faces.event.MethodExpressionActionListener.processAction（MethodExpressionActionListener.java:150）\r\nat javax.faces.event.ActionEvent.processListener（ActionEvent.java:96）\r\nat javax.faces.component.UIComponentBase.broadcast（UIComponentBase.java:839 ）\r\n在javax.faces.component.UICommand.broadcast（UICommand.java:315）\r\n在javax.faces.component.UIViewRoot.broadcastEvents（UIViewRoot.java:870）\r\n在javax.faces.component.UIViewRoot.processApplication（UIViewRoot.java： 1418）\r\nat com.sun.faces.lifecycle.InvokeApplicationPhase.execute（InvokeApplicationPhase.java:82）\r\nat com.sun.faces.lifecycle.Phase.doPhase（Phase.java:100）\r\nat com.sun.faces.lifecycle.LifecycleImpl .execute（LifecycleImpl.java:201）\r\n在javax.faces.webapp.FacesServlet.service（FacesServlet.java:670）\r\n在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:231）\r\n在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain的.java：166）\r\n在org.apache.tomcat.websocket.server.WsFilter.doFilter（WsFilter.java:53）\r\n在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）\r\n在org.apache。 catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）\r\nat org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter（ProxiedFilterChain.java:61）\r\nat org.apache.shiro.web.servlet.AdviceFilter.executeChain（ AdviceFilter.java:108）\r\n在org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal（AdviceFilter.java:137）\r\n在org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:125）\r\n在org.apache.shiro.web .servlet.ProxiedFilterChain.doFilter（ProxiedFilterChain.java:66）\r\n在org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain（AbstractShiroFilter.java:449）\r\n在org.apache.shiro.web.servlet.AbstractShiroFilter $ 1.call（ AbstractGhiroFilter.java:365）at \r\norg.apache.shiro.subject.support.SubjectCallable.call（SubjectCallable.java:83）\r\nat org.apache.shiro.subject.support.SubjectCallable.doCall（SubjectCallable.java:90）\r\nat org.apache.shiro.subject.support.SubjectCallable.call（SubjectCallable.java:83）at org .apache.shiro.subject.support.DelegatingSubject.execute（DelegatingSubject.java:383）\r\n在org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal（AbstractShiroFilter.java:362）\r\n在org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:125）\r\n在org.springframework.web.filter .DelegatingFilterProxy.invokeDelegate（DelegatingFilterProxy.java:357）\r\nat org.springframework.web.filter.DelegatingFilterProxy.doFilter（DelegatingFilterProxy.java:270）\r\nat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）\r\nat org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）\r\nat com.itdida.core.filters.DomainFilter.doFilter（DomainFilter.java:34）\r\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）\r\nat org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）\r\nat org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal （CharacterEncodingFilter.java:200）\r\n在org.springframework.web.filter.OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）\r\n在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:193）\r\n在org.apache。 catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:166）\r\nat org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:199）\r\nat org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:96）\r\nat org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:137）\r\nat org.apache.catalina.valves.ErrorReportValve.invoke （ErrorReportValve.java:81）\r\n在org.apache.catalina.valves.AbstractAccessLogValve.invoke（AbstractAccessLogValve.java:651）\r\n在org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:87）\r\n在org.apache。 catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java:342）\r\n在org.apache.coyote.http11.Http11Processor.service（Http11Processor.java:409）\r\n在org.apache.coyote.AbstractProcessorLight.process（AbstractProcessorLight.java:66）\r\norg.apache.coyote.AbstractProtocol $ ConnectionHandler.process（AbstractProtocol.java:754）\r\nat org.apache.tomcat.util.net.NioEndpoint $ SocketProcessor.doRun（NioEndpoint.java:1376）\r\nat org.apache.tomcat.util .net.SocketProcessorBase.run（SocketProcessorBase.java:49）\r\nat java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1149）\r\nat java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:624）\r\nat org.apache.tomcat.util.threads.TaskThread $ WrappingRunnable.run（TaskThread.java:61）\r\n在java.lang.Thread.run（Thread.java:748）\r\n引起的：org.hibernate.exception.SQLGrammarException：could not \r\n在org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert（SQLExceptionTypeDelegate.java:63）处提取ResultSet\r\norg.hibernate.exception.internal.StandardSQLExceptionConverter.convert（StandardSQLExceptionConverter.java:42）\r\nat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert（SqlExceptionHelper.java:111）\r\nat org.hibernate.engine.jdbc.spi .sqlExceptionHelper.convert（SqlExceptionHelper.java:97）\r\nat org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract（ResultSetReturnImpl.java:69）\r\nat org.hibernate.loader.Loader.getResultSet（Loader.java:2168）\r\nat org.hibernate.loader.Loader.executeQueryStatement（Loader.java:1931）\r\norg.hibernate.loader.Loader.executeQueryStatement（Loader.java:1893）\r\norg.hibernate.loader.Loader.doQuery（Loader.java:938）org.hibernate.loader.Loader.executeQueryStatement（Loader.java:1931）\r\n在org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections（Loader.java:341）\r\norg.hibernate.loader.Loader.doList（Loader.java:2692）\r\nat org.hibernate.loader.Loader.doList（Loader.java:2675）\r\nat org.hibernate.loader.Loader.listIgnoreQueryCache（Loader.java:2507） ）\r\n在org.hibernate.loader.Loader.list（Loader.java:2502）\r\n位于org.hibernate.loader.custom.CustomLoader.list（CustomLoader.java:335）\r\n的org.hibernate.internal.SessionImpl.listCustomQuery（SessionImpl。的java：2162）\r\n在org.hibernate.internal.AbstractSharedSessionContract.list（AbstractSharedSessionContract.java:1016）\r\n在org.hibernate.query.internal.NativeQueryImpl.doList（NativeQueryImpl.java:152）\r\n在org.hibernate.query.internal.AbstractProducedQuery .list（AbstractProducedQuery.java:1414）\r\n... 91 more\r\n由于：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException：表'horse.ying_fu_he_xiao_shen_he_ji_lu_fei_yong' \r\n在sun.reflect.NativeConstructorAccessorImpl.newInstance0 （本地方法）\r\n上不存在sun.reflect.NativeConstructorAccessorImpl.newInstance （NativeConstructorAccessorImpl.java： 62）\r\nat sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:45）\r\nat java.lang.reflect.Constructor.newInstance（Constructor.java:423）\r\nat com.mysql.jdbc.Util.handleNewInstance（Util.java:377 ）\r\nat com.mysql.jdbc.Util.getInstance（Util.java:360）\r\nat com.mysql.jdbc.SQLError.createSQLException（SQLError.java:978）\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket（MysqlIO.java： 3887）\r\n在com.mysql.jdbc.MysqlIO.checkErrorPacket（MysqlIO.java:3823）\r\n位于com.mysql.jdbc.MysqlIO.sendCommand（MysqlIO.java:2435）\r\n位于com.mysql.jdbc.MysqlIO.sqlQueryDirect（MysqlIO.java:2582 ）\r\nat com.mysql.jdbc.ConnectionImpl.execSQL（ConnectionImpl.java:2530）\r\nat com.mysql.jdbc.PreparedStatement.executeInternal（PreparedStatement.java:1907）\r\nat com.mysql.jdbc.PreparedStatement.executeQuery（PreparedStatement.java： 2030）\r\nat com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery（NewProxyPreparedStatement.java:76）\r\nat org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract（ResultSetReturnImpl.java:60）\r\n... 105 more"},"comment":{"url":"https://api.github.com/repos/itdida/itdida-issues/issues/comments/381807565","html_url":"https://github.com/itdida/itdida-issues/issues/157#issuecomment-381807565","issue_url":"https://api.github.com/repos/itdida/itdida-issues/issues/157","id":381807565,"user":{"login":"WENLINRONG","id":37489976,"avatar_url":"https://avatars1.githubusercontent.com/u/37489976?v=4","gravatar_id":"","url":"https://api.github.com/users/WENLINRONG","html_url":"https://github.com/WENLINRONG","followers_url":"https://api.github.com/users/WENLINRONG/followers","following_url":"https://api.github.com/users/WENLINRONG/following{/other_user}","gists_url":"https://api.github.com/users/WENLINRONG/gists{/gist_id}","starred_url":"https://api.github.com/users/WENLINRONG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WENLINRONG/subscriptions","organizations_url":"https://api.github.com/users/WENLINRONG/orgs","repos_url":"https://api.github.com/users/WENLINRONG/repos","events_url":"https://api.github.com/users/WENLINRONG/events{/privacy}","received_events_url":"https://api.github.com/users/WENLINRONG/received_events","type":"User","site_admin":false},"created_at":"2018-04-17T02:13:12Z","updated_at":"2018-04-17T02:13:12Z","author_association":"COLLABORATOR","body":"正式，测试都会报错"}}
{"actor":{"display_login":"WENLINRONG"}}