使用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
- Mybatis什麼時候需要宣告jdbcType?MyBatisJDBC
- MySQL案例-TIMESTAMP NOT NULL與NULLMySqlNull
- MySQL過程報 Parameter number N is not an OUT parameter錯誤MySql
- mybatis報錯MyBatis
- springboot開發介面報錯Optional int parameter 'userId' is present but cannot be translated into a null v......Spring BootNull
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- mybatis報錯解決MyBatis
- vipca報錯 Error 0PCAError
- error: unknown error 22 setting key 'kernel.shmmax'ErrorHMM
- error: "Invalid argument" setting key "net.ipv4.ip_local_port_range"Error
- ERROR 1045 (28000): ProxySQL Error: 報錯ErrorSQL
- Null pointer (NULL array pointer is passed) in function cvGetMat, 報這樣的錯NullFunction
- 使用Boost庫報error C4996錯誤Error996
- MYSQL SOURCE報錯 ERROR: ASCIIMySqlErrorASCII
- error:declared inside parameter listErrorIDE
- git (v2.18.0) error setting certificateGitError
- ant打包出現null returned: 1報錯Null
- mybatis plus saveBatch報錯問題MyBatis
- mysql報錯ERROR 1093MySqlError
- 【Redis】slaveof 報錯 Background transfer errorRedisError
- Oracle安裝報錯syntax errorOracleError
- struts2報Error filterStart錯ErrorFilter
- 故障分析 | MySQL 遷移後 timestamp 列 cannot be nullMySqlNull
- ora - 100501 Non oracle errorOracleError
- mybatis 報錯： Invalid bound statement (not found)MyBatis
- Install Error : ERROR:SQLException null Resultset [ID 875002.1]ErrorSQLExceptionNull
- Ubuntu 系統 apt 報錯:relocation errorUbuntuAPTError
- pip install scrapy報錯：error: UnableError
- MySQL報錯 Error_code: 1045MySqlError
- mybatis Parameter index out of range (1 > number of parameters, which is 0)MyBatisIndex
- mybatis3呼叫瀚高procedure報錯MyBatisS3
- weblogic報錯： OPatch failed with error code 73WebAIError
- redis報錯Windows error 0x70RedisWindowsError
- Mybatis-Plus 更新欄位為 NULLMyBatisNull
- Initianization Parameter (4) : CPU_COUNT
- gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1Error