Thread: Bad timestamp external representation ''

Bad timestamp external representation ''

From
"Katalina Marcos"
Date:

 

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

 

Re: Bad timestamp external representation ''

From
Dave Cramer
Date:
Kata,

Can we see the prepared statement SQL ?

Dave
On Mon, 2004-04-19 at 11:36, Katalina Marcos wrote:
>
>
> 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
>
>
>
>
> !DSPAM:4083f374180061005317689!
--
Dave Cramer
519 939 0336
ICQ # 14675561