java.sql.SQLException: ORA-00911: invalid character 解決方法(轉)

roszhaodan481發表於2014-05-23
JavaSQLException

來自：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.
出錯的語句如下：

相關文章