From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: How to solve invalid input for tyep timestamp problem? |
Date: | 2005-11-02 12:19:45 |
Message-ID: | 27594329-AE29-4E59-A89C-C0545433D72D@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2005-11-02 13:10:48 | Re: How to solve invalid input for tyep timestamp problem? |
Previous Message | Joost Kraaijeveld | 2005-11-02 10:57:17 | How to solve invalid input for tyep timestamp problem? |