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
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- 【shell 】syntax error in conditional expressionErrorExpress
- exp tables sh: Syntax error: `(' is not expectedError
- One cause leads to the error(The specified nodes are not clusterable)Error
- MySQL 報錯MySQL server syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'MySqlServerMIT
- Solaris syntax error: unexpected end of fileError
- Oracle安裝報錯syntax errorOracleError
- line 10:syntax error: unexpected end of fileError
- Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause:...ApacheBATUIExceptionErrorSQLAPP
- 配置NDK syntax error: unexpected end of file 解決Error
- CUSTOMER INTERFACE STATUS ERROR CODESError
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- Q:[Vue warn]: Duplicate keys detected: ‘PAYACT‘. This may cause an update error.VueError
- 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
- 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
- eclipse 引入外部js檔案報Syntax error on token 錯解決方案EclipseJSError
- 執行遷移檔案報錯: Syntax error or access violation: 1166 ...Error
- com.badlogic.gdx.utils.SerializationException: Error parsing XML on line 1 nearExceptionErrorXML
- RuntimeError: cuDNN error: CUDNN_STATUS_EXECUTION_FAILED解決辦法ErrorDNNAI
- Mail To SyntaxAI
- C++ Programming Error/Warning Analysis (1) cannot have cv-qualifierC++Error
- 如何修復 Ubuntu 上“…script returned error exit status 1”的錯誤UbuntuError
- jdbc連線sql server 出現 java.sql.SQLException: Network error IOException: Connection refused:JDBCSQLServerJavaExceptionError