Skip site navigation (1) Skip section navigation (2)

Bug in JDBC-Driver?

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: (view raw, whole thread or download thread mbox)
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
I used the JDBC-Driver pg80b1.308.jdbc3.jar coming with the German
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?

Antje Stejskal


pgsql-jdbc by date

Next:From: Laurent DupervalDate: 2004-11-29 14:57:57
Subject: No error code on unique constraint violation
Previous:From: Tom LaneDate: 2004-11-28 22:23:04
Subject: Re: [JDBC] Strange server error with current 8.0beta driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group