Thread: RV: Bad timestamp external representation ''

RV: Bad timestamp external representation ''

From
"Katalina Marcos"
Date:

 

Hi. In my earlier mail i wrote it’s not null, that is wrong, the columns can be null.

 

Thanks.

Kata

 

-----Mensaje original-----
De: Katalina Marcos [mailto:kmarcos@mazda.com.co]
Enviado el: lunes, 19 de abril de 2004 10:36
Para: 'pgsql-jdbc@postgresql.org'
Asunto: Bad timestamp external representation ''

 

 

Hi all.

 

In advance, sorry for my English mistakes…

 

I have a problem when i try to insert a row in a PostgreSQL 7.3 with jdbc:

 

The table have a timestamp column without time zone and it’s not null. If a send a date, the insert is ok, but if I put call.setNull(idxField,Types.TIMESTAMP);

I get Bad timestamp external representation ''

I tried too with call.setTimestamp(idxField,null); and I get the same error.

Somebody can help me? I tried with all the new versions in http://jdbc.postgresql.org/download.html

 

Thanks a lot!

Kata