Bug in JDBC-Driver?
От | Antje.Stejskal@ppi.de |
---|---|
Тема | Bug in JDBC-Driver? |
Дата | |
Msg-id | 6D48B8403D926449BDE8440EC7EEC46D021F2026@max.ppinet.de обсуждение исходный текст |
Ответы |
Re: Bug in JDBC-Driver?
|
Список | 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
В списке pgsql-jdbc по дате отправления: