解决方案 »
- jsp页面怎么把选择的文件路径传到后台action
- 第一次用zTree,请高手指教
- 我是一名刚刚大四的学生,昨天老师找到我说让我加入他的公司,我该怎么办??
- 急,Struts问题!!!
- 高分求解——习方法的问题——如何学习源代码?
- 请问谁有Weblogic9.0配置手册(最好中文的)急得很!!!!!!!!
- 求救!weblogic8+struts的mapping问题
- 真是不好意思,问个虚拟路径的问题
- 讨论ejb中数据库操作问题
- ejb中session bean 如何本地调用entity bean(一定给分)
- 想做一个视频上传 播放的网站 j2ee求高手指教
- hibernate一对多双向关联总是不成功,求助啊
[INFO ] [15:40:03] org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
Exception in thread "timerFactory" org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/zhitengda/valueobject/sqlmap/Tab_hr_tms.xml.
--- The error occurred while applying a parameter map.
--- Check the getTabTms-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '-' 附近有语法错误。
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/zhitengda/valueobject/sqlmap/Tab_hr_tms.xml.
--- The error occurred while applying a parameter map.
--- Check the getTabTms-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: '-' 附近有语法错误。
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:268)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:193)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:219)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:266)
at com.zhitengda.services.dao.TabHrTmsDao.getTabTmsList(TabHrTmsDao.java:25)
at com.zhitengda.services.TabHrTmsServiceImpl.getTabTmsList(TabHrTmsServiceImpl.java:28)
at com.zhitengda.jbos.TabTmsJobs.run(TabTmsJobs.java:34)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: '-' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
at $Proxy2.execute(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
... 13 more
好诡异,这错不影响我数据的查询,我把log4j DEBUG打印,发现ibatis设值、sql、取值都是正常的,但是取完值后,突然冒出这个错误
改为
#minSize#还有下面的