java.sql.SQLException: ORA-00911: invalid character 解决方法(转)

来自：http://www.verydemo.com/demo_c89_i141251.html

点击()折叠或打开

1. com.ibatis.common.jdbc.exception.NestedSQLException:
2. --- The error occurred in sqlMap_etlJobQueue.xml.
3. --- The error occurred while applying a parameter map.
4. --- Check the select_putJobIntoQueue-InlineParameterMap.
5. --- Check the statement (query failed).
6. --- Cause: java.sql.SQLException: ORA-00911: invalid character

点击()折叠或打开

1. 2012-08-28 14:21:23,655 DEBUG jdbc.SimpleDataSource (JakartaCommonsLoggingImpl.java:debug(27)) - Created connection 9377143.
2. 2012-08-28 14:21:23,732 DEBUG sql.Connection (JakartaCommonsLoggingImpl.java:debug(27)) - {conn-100000} Connection
3. 2012-08-28 14:21:23,744 DEBUG sql.Connection (JakartaCommonsLoggingImpl.java:debug(27)) - {conn-100000} Preparing Statement: select COALESCE(max(seqID),0) as seqID from etl_job_queue;
4. 2012-08-28 14:21:24,000 DEBUG sql.PreparedStatement (JakartaCommonsLoggingImpl.java:debug(27)) - {pstm-100001} Executing Statement: select COALESCE(max(seqID),0) as seqID from etl_job_queue;
5. 2012-08-28 14:21:24,001 DEBUG sql.PreparedStatement (JakartaCommonsLoggingImpl.java:debug(27)) - {pstm-100001} Parameters: []
6. 2012-08-28 14:21:24,002 DEBUG sql.PreparedStatement (JakartaCommonsLoggingImpl.java:debug(27)) - {pstm-100001} Types: []
7. 2012-08-28 14:21:24,033 DEBUG jdbc.SimpleDataSource (JakartaCommonsLoggingImpl.java:debug(27)) - Returned connection 9377143 to pool.

出错的语句如下：