cause:java.sql.sqlsyntaxerrorexception:ora-00911: Invalid character

Recently a project to use Ibatis, not how to use before, so this afternoon first practice practiced hand.

After writing a demo, the runtime throws an exception and seems to find nothing wrong ...

Then Baidu a bit.

The original Ibatis, after writing the SQL statement in XML, do not need to write ";" Semicolon.

Use Ibatis to access the database for data query throwing exception
Later, the SQL statements in the XML configuration file are finally not written with semicolons

Com.ibatis.common.jdbc.exception.NestedSQLException:---The error occurred in Person.xml.  ---The error occurred while applying a parameter map.  ---Check the getperson-inlineparametermap.  ---Check the statement (query failed). ---cause:java.sql.sqlsyntaxerrorexception:ora-00911: Invalid character at Com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback (generalstatement.java:185 ) at Com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject (generalstatement.java:104 ) at Com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject (sqlmapexecutordelegate.java:566) at Com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject (sqlmapexecutordelegate.java:541) at Com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject (sqlmapsessionimpl.java:106) at Com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject (sqlmapclientimpl.java:83) at Com.ibeats.SqlMapClient.main (sqlmapclient.java:20) caused BY:JAVA.SQL.SQLSYNTAXERROREXCeption:ora-00911: Invalid character at Oracle.jdbc.driver.T4CTTIoer.processError (t4cttioer.java:439) at Oracle.jdbc.driver.T4CTTIoer.processError (t4cttioer.java:395) at Oracle.jdbc.driver.T4C8Oall.processError ( t4c8oall.java:802) at Oracle.jdbc.driver.T4CTTIfun.receive (t4cttifun.java:436) at Oracle.jdbc.driver.T4CTTIfun.doRPC (t4cttifun.java:186) at Oracle.jdbc.driver.T4C8Oall.doOALL (t4c8oall.java:521) At Oracle.jdbc.driver.T4CPreparedStatement.doOall8 (t4cpreparedstatement.java:205) at Oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe (t4cpreparedstatement.java:861) at Oracle.jdbc.driver.OracleStatement.executeMaybeDescribe (oraclestatement.java:1145) at Oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (oraclestatement.java:1267) at Oracle.jdbc.driver.OraclePreparedStatement.executeInternal (oraclepreparedstatement.java:3449) at Oracle.jdbc.driver.OraclePreparedStatement.execute (oraclepreparedstatement.java:3550) at Oracle.jdbc.driver.OraclePreparedStatementWrapper.execute (oraclepreparedstatementwrapper.java:1374) 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 )... 6 more

cause:java.sql.sqlsyntaxerrorexception:ora-00911: Invalid character