Timestamp problems - Mailing list pgsql-jdbc

From Peter Katzmann
Subject Timestamp problems
Date
Msg-id 3E4266AC.4060907@thiesen.com
Whole thread Raw
Responses Re: Timestamp problems  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
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



pgsql-jdbc by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Connection pooling problems
Next
From: jr@amanue.com (Jim Rosenberg)
Date:
Subject: Re: moveToInsertRow SQL Exception "No Primary Keys"