From: | Antje(dot)Stejskal(at)ppi(dot)de |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Bug in JDBC-Driver? |
Date: | 2004-11-29 12:34:55 |
Message-ID: | 6D48B8403D926449BDE8440EC7EEC46D021F2026@max.ppinet.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi all,
I am testing Postgres 8.0.0 beta4 on Windows 2000. I checked the changelog
but could not find a corresponding topic.
I am facing a time problem with timestamp handling. Here is what I did: I
insert data via JDBC. The timestamp value in the prepared statement is still
'2003-08-19 11:40:08.0' as the debugger (of Eclipse) confirms. Inserted in
the database gets a tiemstamp 2003-08-19 09:40:08.0'. CURRENT_TIME of
DB-Server is an hour back to server time.
Before I do the insert I do a select to check if such data is already in the
DB. The select does not change the timestamp - so program goes in insert
method.
I used the JDBC-Driver pg80b1.308.jdbc3.jar coming with the German
postgresql-8.0.0-beta4.msi
Windows says RevisionNo: {6ABA084E-D3FB-4253-95FF-68A0A066F69B}, if that is
of any help?
Today I tried my program using the JDBC-Driver of Postgres 7.4.6
(pg74.215.jdbc3.jar). With that JDBC- driver everything works fine. Is there
any parameter I missed to set in version 8, or is it a bug?
Regards,
Antje Stejskal
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent Duperval | 2004-11-29 14:57:57 | No error code on unique constraint violation |
Previous Message | Tom Lane | 2004-11-28 22:23:04 | Re: [JDBC] Strange server error with current 8.0beta driver |