Java. SQL. SQLException: ORA-01861: Text and format strings do not match,

Java. SQL. SQLException: ORA-01861: Text and format strings do not match,

1. Error description

Java. SQL. SQLException: ORA-01861: Text and format strings do not match

2. Error cause

When the field name is statis_date, the Data Type stored in the database is Date, while when splicing an SQL statement in Java, the parameter is passed as a string type, and the type does not match, resulting in an error

3. Solution

(1) modify the Data Type of this field in the database

This method is not recommended

(2) modify the parameter passing method during splicing and use to_date to convert the parameters