ibatis的異常錯誤，多加了一個;號。

    在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 fromwt_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 characterat 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 characterat 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 moreCaused by: java.sql.SQLException: ORA-00911: invalid characterat 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

各種尋找原因後發現，原來是查詢語句最後都了一個;號，哎，查了半天最後請教人，別人一眼就看出問題，基本功不深那~~~