null params dates

[solinad21]

Could you help me to send null params for dates ?

[timmolter]

I'd love to help. Can you be more specific?

[solinad21]

i get this error:

java.sql.SQLException: Data truncation: Incorrect date value: '' for column 'fechacad' at row 1 Query: INSERT INTO inventarios (Cod_Mov, Cod_Almacen, Cod_Proveedor, Cod_Articulo, tipodesc, Cod_IVA, cod_sesion, claveEmpleado,Stock_Mov, descuento_Mov, Costo_Mov, prov_garantia, IVA,Fecha_Mov,Hora_Mov, Cod_Caja,Doc_Fuente, paquete,Tipo_Mov,desc_mov,num_serie,lote,fechacad) VALUES (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?) Parameters: [[5, 1, 581, 1, 1, 13747, 12, 1, 0.0, 36.00, 0, 4.97, 2013-08-17, 12:43:00, 1050000099611, 99611, 0, S, V, , , ]]

i want set null to "fechacad" column.

i try with '', 'null', etc.

[timmolter]

it looks like you're passing in 22 parameters but your SQL statement is expecting 23. Is that the problem?

[solinad21]

not, in my code the params match ok.
i have double checked it.

I think the problem arises because the quotes are added automatically to the parameter.
and then the parameter is never passed as null (without quotes).
when I put directly the parameter to null the query runs perfectly.