| 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: | Whole Thread | Raw Message | 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 |