Skip site navigation (1) Skip section navigation (2)

Re: Bad timestamp external representation ''

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: kmarcos(at)mazda(dot)com(dot)co
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Bad timestamp external representation ''
Date: 2004-04-19 16:27:53
Message-ID: 1082392072.1554.97.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
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


In response to

pgsql-jdbc by date

Next:From: Anton KomarevtsevDate: 2004-04-19 20:31:06
Subject: binary data in `bytea' column
Previous:From: James RobinsonDate: 2004-04-19 15:56:06
Subject: Prepared Statements and large where-id-in constant blocks?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group