org.springframework.jdbc.BadSqlGrammarException:
com.ibatis.common.jdbc.exception.Nested
SQLException:
--- The error occurred in com/heer/jy/report/sql/jyReport.xml.
--- The error occurred while applying a parameter map.
--- Check the jyReport.zpReport7-InlineParameterMap.
--- Check the statement (query failed).
--- Cause:
java.sql.SQLException: ORA-00911:
无效字符 com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:263)
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:188)
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:214)
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:261)
com.heer.jy.report.dao.impl.JyReportDaoImpl.getReportList(JyReportDaoImpl.java:18)
com.heer.jy.report.service.impl.JyReportServiceImpl.getReportList(JyReportServiceImpl.java:54)
com.heer.jy.report.web.action.ReportAction.buildReport(ReportAction.java:118)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
com.heer.framework.security.HeerSecurityFilter.doFilterInternal(HeerSecurityFilter.java:214)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
com.heer.utils.SetEncodingFilter.doFilter(SetEncodingFilter.java:108)
------解决方案--------------------估计是你的sql语句有问题,或者里面有关键字,你把sql打出来,拿到数据库里执行看看。。。
------解决方案--------------------ibatis的语法错误