360 Atals:Cause: java.sql.SQLException: Proxy Warning - near “status“: syntax error
問題
在用360的Atals搭建mysql的主從分離時,用Java連線好搭建的服務出現以下的問題
### Error querying database. Cause: java.sql.SQLException: Proxy Warning - near "status": syntax error
### The error may exist in file [E:\code\crocosmia\crocosmia\target\classes\mybatis\system\SysDictDataMapper.xml]
### The error may involve com.cecii.project.system.mapper.SysDictDataMapper.selectDictDataByType-Inline
### The error occurred while setting parameters
### SQL: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
### Cause: java.sql.SQLException: Proxy Warning - near "status": syntax error
; uncategorized SQLException; SQL state [HY000]; error code [1105]; Proxy Warning - near "status": syntax error; nested exception is java.sql.SQLException: Proxy Warning - near "status": syntax error
後面用navicat去測試這條sql
結果如下:
1、 使用了 status關鍵字
2、沒使用status關鍵字
原因假想是:
通過連線atlas資料庫,atlas會對sql的校驗規則和mysql不同,導致這裡的status關鍵字在執行中導致報錯,系統無法正常啟動
只有通過對atlas校驗規則設定或者改變status欄位名稱來解決。
相關文章
- syntax error near unexpected token `Error
- syntax error near unexpected token `問題的解決Error
- shell 指令碼報錯^M: syntax error near unexpected token指令碼Error
- Solaris awk: syntax error near line 1 awk: bailing out near line 1ErrorAI
- MySQL案例04:Cause: java.sql.SQLException: Could not retrieve transaction read-only status from serverMySqlJavaExceptionServer
- CentOS7使用exp/imp時報錯:bash: syntax error near unexpected token `(CentOSError
- Linux 5中出現的-bash: syntax error near unexpected token `('錯誤LinuxError
- 如何解決"Parse error: syntax error"Error
- One cause leads to the error(The specified nodes are not clusterable)Error
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- exp tables sh: Syntax error: `(' is not expectedError
- 【shell 】syntax error in conditional expressionErrorExpress
- MySQL 報錯MySQL server syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'MySqlServerMIT
- Solaris syntax error: unexpected end of fileError
- Oracle安裝報錯syntax errorOracleError
- Check failed: status == CUDNN_STATUS_SUCCESS (4 vs. 0) CUDNN_STATUS_INTERNAL_ERRORAIDNNError
- 帝國CMS提示parse error syntax error的解決方法Error
- Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause:...ApacheBATUIExceptionErrorSQLAPP
- line 10:syntax error: unexpected end of fileError
- 如何解決"You have an error in your SQL syntax"ErrorSQL
- dedecms 搬家 / dedecms error warning!錯誤Error
- CUSTOMER INTERFACE STATUS ERROR CODESError
- 配置NDK syntax error: unexpected end of file 解決Error
- Q:[Vue warn]: Duplicate keys detected: ‘PAYACT‘. This may cause an update error.VueError
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- error C2061: syntax error : identifier '__RPC__out_xcount_part'ErrorIDERPC
- [Near Protocol] Near開發Demo淺析-Gamble Game Near(一):智慧合約ProtocolGAM
- vue報錯之Duplicate keys detected: '0'. This may cause an update error.VueError
- C++ Programming Error/Warning Analysis (2) extra qualificationC++Error
- Error bpbrm (pid=909384) client restore EXIT STATUS 5ErrorclientREST
- rabbitMq的status報錯Error: unable to perform an operation on node ‘rabbit……MQErrorORM
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- AIX 11gR2 grid root.sh Error: with status:FAIL.Error code is 256AIError
- 解決laravel出現Syntax error or access violation: 1055 ‘***‘ isn‘t in GROUP BYLaravelError
- [轉]Android Studio匯入工程報錯 Error:Cause: peer not authenticated 解決方案AndroidError
- ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Coul...ErrorDatabaseSpringFrameworkJDBCOTGException
- 織夢提示dedecms error warning錯誤的解決方法Error
- pbootcms模板 後臺升級程式後導致網站打不開 Parse error: syntax error, unexpecboot網站Error