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欄位名稱來解決。
相關文章
- 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
- 如何解決"Parse error: syntax error"Error
- 【shell 】syntax error in conditional expressionErrorExpress
- Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause:...ApacheBATUIExceptionErrorSQLAPP
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- Solaris syntax error: unexpected end of fileError
- dedecms 搬家 / dedecms error warning!錯誤Error
- Check failed: status == CUDNN_STATUS_SUCCESS (4 vs. 0) CUDNN_STATUS_INTERNAL_ERRORAIDNNError
- 帝國CMS提示parse error syntax error的解決方法Error
- 如何解決"You have an error in your SQL syntax"ErrorSQL
- Q:[Vue warn]: Duplicate keys detected: ‘PAYACT‘. This may cause an update error.VueError
- vue報錯之Duplicate keys detected: '0'. This may cause an update error.VueError
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- Error - RtlWerpReportException failed with status code :-1073741823. Will try to launch the processErrorExceptionAI
- [Near Protocol] Near開發Demo淺析-Gamble Game Near(一):智慧合約ProtocolGAM
- rabbitMq的status報錯Error: unable to perform an operation on node ‘rabbit……MQErrorORM
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- 織夢提示dedecms error warning錯誤的解決方法Error
- [轉]Android Studio匯入工程報錯 Error:Cause: peer not authenticated 解決方案AndroidError
- 執行遷移檔案報錯: Syntax error or access violation: 1166 ...Error
- Syntax Error: ValidationError: Invalid options object. Stylus Loader has been initialized using anErrorObjectZed
- 解決laravel出現Syntax error or access violation: 1055 ‘***‘ isn‘t in GROUP BYLaravelError
- RuntimeError: cuDNN error: CUDNN_STATUS_EXECUTION_FAILED解決辦法ErrorDNNAI
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- pbootcms模板 後臺升級程式後導致網站打不開 Parse error: syntax error, unexpecboot網站Error
- eclipse 引入外部js檔案報Syntax error on token 錯解決方案EclipseJSError
- Fatal error: can't check configuration file '/home/watt/proxy/dError
- PbootCMS 升級後網站打不開,解析錯誤 Parse error: syntax error, unexpected ‘:’, expecting ‘{’怎麼辦boot網站Error
- 13.MyBatis報錯:Error querying database. Cause: org.apache.ibatis.binding.BindingException: ParameterMyBatisErrorDatabaseApacheException
- 解決報錯 cuDNN error: CUDNN_STATUS_NOT_SUPPORTED. This error may appear if you passed in a non-contiguous input.DNNErrorAPP
- 記錄Windows failed fast startup with error status 0xC00000D4.WindowsAIASTError
- Laravel 8使用 佇列任務出現 「 syntax error, unexpected ')' 」錯誤解決Laravel佇列Error
- Springboot中配置動態sql查詢出現的錯誤syntax error, expect ‘)‘Spring BootSQLError
- 錯誤內容:You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverErrorMySqlServer
- Laravel5.4 資料庫遷移錯誤 SQLSTATE [42000] Syntax error or access violation 1071Laravel資料庫SQLError
- [報錯:字元太長] SQLSTATE [42000]: Syntax error or access violation: 1071 Specified key was t oo long;字元SQLError
- Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)AISQLServerError