Environmental Science:
Oracle Database
Error content:
### Cause: org. apache. ibatis. type. TypeException: Error setting null for parameter #10 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.Sqlexception: invalid column type
When mybatis inserts a null value, you need to specify a jdbctype because mybatis cannot convert
Solution:
In the insert statement, add JDBC type
For example:
#{name,jdbcType=VARCHAR}
Similar Posts:
- [Solved] Mybatis multi-table query error: Column ‘id’ in field list is ambiguous
- Error attempting to get column ‘xxx’ from result set. Cause: java.sql.sqlexception: unable to convert to internal representation. Error resolution during Oracle database query
- [Solved] Mybatis Mapping Error: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named ‘id’ in ‘class java.lang.String
- pymysql.err.OperationalError: (1054, “Unknown column’aa’in’field list’)
- java.sql.SQLException: Error; uncategorized SQLException; SQL state [null]; error code [0];
- [Solved] EF An error occurred while updating the entries. See the inner exception for details.
- MySQL database insert into statement with parameters Error
- Duplicate entry ‘1’ for key ‘PRIMARY'() [How to Solve]
- [Solved] When mybatis query result type is char: cause: Java. Lang. stringindexoutofboundsexception: string index out of range: 0
- [Solved] mybatis Bulk Insert Error: Column count doesn‘t match value count at row 1