Re: Timestamp problems - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Timestamp problems
Date
Msg-id 3E429520.904@xythos.com
Whole thread Raw
In response to Timestamp problems  (Peter Katzmann <p.katzmann@thiesen.com>)
List pgsql-jdbc
Peter,

When you say you tried with the current version what do you mean?
Specifically have you tried the latest 7.3 build from
jdbc.postgresql.org?  There were some recent bug fixes in this area that
I think may fix your problem.

If the current code still has this problem, can you submit a test case
that we can compile and run that demonstrates the problem?

thanks,
--Barry


Peter Katzmann wrote:
> High,
> i' currently working with hibernate. They represent Calendar types as
> timestamps. During prepareStatement and setTimestamp the data generated for
> the query has a modified date. The date is something original:
>
>
> insert into hours  ( entrydate, activitydate, remark, time, userid,
> checked,
> phaseid, activityid, zkub, id ) values  '2003-02-06 11:11:29.338000000+00',
> '2003-02-06 11:11:29.338000000+00', 'öfölsdajklö', 120, 'pk1057', 'f',
> null,
> null, null, 12747 )
>
>
> And this will be aftter the data was read back, the checked flag changed
> and
> wrote back
>
> update hours set entrydate = '2003-02-05 23:00:00.000000000+00',
> activitydate
> = '2003-02-05 23:00:00.000000000+00', remark = 'öfölsdajklö', time = 120,
> userid = 'pk1057', checked = 't', phaseid = 5, activityid = 3, zkub = ' '
> where id = 12747
>
> First occured the problem with postgres 7.2 so i updated to a current
> version,
> but no go either.
>
>
> peter
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>




pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: moveToInsertRow SQL Exception "No Primary Keys"
Next
From: Kris Jurka
Date:
Subject: Re: Obtaining precision and scale of NUMERIC types