Re: How to solve invalid input for tyep timestamp problem?

What version of the driver are you using ?
Does log4j use prepared statements?

This is the right column, but the , between 57,844 is wrong, there
was a bug in the HEAD driver which would
have caused this if the answer to the first 2 questions is HEAD, and
yes.

If this doesn't solve your problem, then I suspect it is locale
related. The comma (,) is commonly used for the decimal
place in EU.

Dave
On 2-Nov-05, at 5:57 AM, Joost Kraaijeveld wrote:

> Hi,
>
> I want log4j to log in a PostgreSQL database. Log34j uses "2005-11-02
> 11:49:57,844" as it's timestamp format. I used TIMESTAMP as a
> columntype
> but apparenty that is not the correct type:
>
> java.sql.SQLException: ERROR: invalid input syntax for type timestamp:
> "2005-11-02 11:49:57,844"
>
> What should be the type I should use for the column?
>
>
> --
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
> web: www.askesis.nl
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>
>