ibatis的异常错误，多加了一个;号。

最新推荐文章于 2025-02-15 18:11:32 发布

原创最新推荐文章于 2025-02-15 18:11:32 发布 · 3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ibatis #query #junit #c

java 专栏收录该内容

13 篇文章

订阅专栏

本文记录了一次使用iBatis框架进行数据库查询时遇到的ORA-00911错误，并详细展示了错误堆栈跟踪，最终发现是因为SQL语句末尾多了一个分号导致的问题。

在ibatis里配置了下面的一个查询语句:

	<select id="Wt_uac_permission_def_exp_query_auth_list"
		resultMap="Wt_uac_auth_defDomain_base.Wt_uac_auth_defDomain_base_result">
		select * from wt_uac_auth_def where id in (select auth_def_id from
		wt_uac_permission_auth where permission_def_id = #value#);
	</select>

结果提示我错误

java.lang.RuntimeException: Error lazy loading result. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/ct10000/uac/config/domain/Wt_uac_permission_defDomain_exp.xml.  
--- The error occurred while applying a parameter map.  
--- Check the Wt_uac_permission_def_exp_query_auth_list-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: ORA-00911: invalid character

	at com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:132)
	at com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:113)
	at $java.util.List$EnhancerByCGLIB$66035e94.size(<generated>)
	at org.sevenstar.component.lazy.LazySupportList.lazyLoading(LazySupportList.java:31)
	at org.sevenstar.component.lazy.LazySupportList.iterator(LazySupportList.java:45)
	at com.test.ct10000.uac.config.domain.TestWt_uac_permission_defDomain.testLoadEqual(TestWt_uac_permission_defDomain.java:27)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at junit.framework.TestCase.runTest(TestCase.java:164)
	at junit.framework.TestCase.runBare(TestCase.java:130)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:120)
	at junit.framework.TestSuite.runTest(TestSuite.java:230)
	at junit.framework.TestSuite.run(TestSuite.java:225)
	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/ct10000/uac/config/domain/Wt_uac_permission_defDomain_exp.xml.  
--- The error occurred while applying a parameter map.  
--- Check the Wt_uac_permission_def_exp_query_auth_list-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: ORA-00911: invalid character

	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 com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
	at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
	at com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:130)
	... 23 more
Caused by: java.sql.SQLException: ORA-00911: invalid character

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
	at com.p6spy.engine.logging.P6LogPreparedStatement.execute(P6LogPreparedStatement.java:161)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
	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)
	... 30 more

各种查找原因后发现，原来是查询语句最后都了一个;号，哎，查了半天最后请教人，别人一眼就看出问题，基本功不深那~~~