RV: Bad timestamp external representation '' - Mailing list pgsql-jdbc

From Katalina Marcos
Subject RV: Bad timestamp external representation ''
Date
Msg-id 000c01c42625$3abee150$770210ac@kmarcos
Whole thread Raw
List pgsql-jdbc

 

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

 

pgsql-jdbc by date:

Previous
From: "Katalina Marcos"
Date:
Subject: Bad timestamp external representation ''
Next
From: James Robinson
Date:
Subject: Prepared Statements and large where-id-in constant blocks?