使用mybatis報錯：Error setting non null for parameter #4 with JdbcType TIMESTAMP
一次性報的異常主要有以下幾個：
java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException:
Could not set parameters for mapping: ParameterMapping{time=’time’, mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId=’null’, jdbcTypeName=’null’, expression=’null’}.
Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property.
Cause: java.sql.SQLException: Parameter index out of range (4 > number of parameters, which is 3).
最後發現原來是。。。
mapper.xml對映檔案裡有註釋！！！！！
把註釋刪掉，一切OK！
相關文章
- MYSQL timestamp NOT NULL插入NULL的報錯問題MySqlNull
- 13.MyBatis報錯：Error querying database. Cause: org.apache.ibatis.binding.BindingException: ParameterMyBatisErrorDatabaseApacheException
- springboot開發介面報錯Optional int parameter 'userId' is present but cannot be translated into a null v......Spring BootNull
- 解決報錯 cuDNN error: CUDNN_STATUS_NOT_SUPPORTED. This error may appear if you passed in a non-contiguous input.DNNErrorAPP
- Mybatis什麼時候需要宣告jdbcType?MyBatisJDBC
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- git (v2.18.0) error setting certificateGitError
- mybatis報錯MyBatis
- ERROR 1045 (28000): ProxySQL Error: 報錯ErrorSQL
- 使用Boost庫報error C4996錯誤Error996
- `jsonb` 報錯 `invalid input syntax for type timestamp with time zone ““JSON
- 故障分析 | MySQL 遷移後 timestamp 列 cannot be nullMySqlNull
- SpingBoot - Mybatis報錯：For artifact {com.mysql:mysql-connector-j:null:jar}: The version cannot be empty.bootMyBatisMySqlNullJAR
- mybatis報錯解決MyBatis
- libtorch使用model.forward報std::runtime_error錯誤ForwardError
- ant打包出現null returned: 1報錯Null
- Spring Boot整合Swagger報錯："this.condition" is nullSpring BootSwaggerNull
- 【Redis】slaveof 報錯 Background transfer errorRedisError
- 網站報錯：“Database Server Error”網站DatabaseServerError
- pip install scrapy報錯：error: UnableError
- DataTables 1.10錯誤： requested unknown parameter
- gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1Error
- mybatis plus saveBatch報錯問題MyBatis
- Ubuntu 系統 apt 報錯:relocation errorUbuntuAPTError
- weblogic報錯： OPatch failed with error code 73WebAIError
- ogg報錯error 11, Resource temporarily unavailableErrorAI
- 反序列 unserialize(): Error 報錯問題Error
- matconvnet-1.0-beta25報錯：Reference to non-existent field ‘dilate‘.
- mpi4py安裝報錯error: Cannot compile MPI programs. Check your configuration!!!ErrorCompile
- Oracle dataguard報錯：Error 1017 received logging on to the standbyOracleError
- linux系統報錯AER PCIe Bus ErrorLinuxError
- 使用CocoaPods出錯，[!] Oh no, an error occurred.Error
- 執行flutter run命令報錯：:ERROR: Could not connect to lockdownd, error code -17FlutterError
- Mybatis-Plus 更新欄位為 NULLMyBatisNull
- VUE前端打包報錯：TypeError: Class extends value undefined is not a constructor or nullVue前端ErrorUndefinedStructNull
- appium start session 時報錯 Error executing adbExec. Original error 求指點APPSessionError
- VUE: npm run dev報錯Error: error:0308010C:digital envelope routines::unsupportedVueNPMdevErrorGit
- cmake報錯CMake Error: Could not find CMAKE_ROOTError