How to solve the error that parameter #2 in mybatis is set to null?

When adapting to oracle database, mybatis reported that null parameter was set incorrectly, and the bug found that there was a null value in the parameter. For Mybatis, if the parameters of jdbcType are not specified during the operation, it may cause problems.

PostgreSQL, MySQL and SQLSERVER all support JdbcType. NULL type, but Oracle does not. This problem also caused mybatis to report an error when adapting.

For example, if #{submitDate} was previously configured, it will report an error in oracle: an error occurred when setting an empty parameter.

Change it to #{submitDate, jdbcType=DATE}. Note that jdbcType is case-sensitive.

Cixi People's Hospital is in urgent need of money. I'll let you have an operation if there's a little trouble, saying it will cost more than 10 thousand Go to Ningbo hospital to take hundreds of medic

Which plastic surgery hospital in Nanyang has a good nose?

Where is Linyi Global Business Valley?

Jilin central hospital feature department

What are the famous snack bars in Kunming?

16 Shanghai F 1, what was the result of massa's practice match?

List of agricultural information concept stocks What are the agricultural information concept stocks?

Cultivation methods and matters needing attention of Siji fruit, and how to raise Siji fruit.

What about moldy leather?

What is a baby muscle needle? What is a baby muscle needle?