I have a table that contains a
date field (
end_date) that the default value is null.
I have created a
stored procedure to insert data to this table.
CREATE PROCEDURE `insert_illness_mapping`(IN `onset_dt` DATE, IN `end_dt` DATE, IN `c_id` INT(11)) NO SQL INSERT INTO illness_mapping (`onset_date`, `end_date`, `coding_id`, ) VALUES (onset_dt, end_dt, c_id)
When I call the
phpmyadmin without filling a value for the
end_date filled, it’s working properly.
When I trying to call the
stored-procedure within my java rest-api I get:
nulljava.lang.IllegalArgumentException at java.sql.Date.valueOf(Unknown Source)
When I’m getting the value of the date from the json file, I get it as a string and then I’m converting it to date. May be this is the issue.
This is an example of the json string:
Do you have any idea?