bug in getTime after insertRow with postgresql-8.1-404.jdbc3.jar

Поиск
Список
Период
Сортировка
От hpb@htl-steyr.ac.at
Тема bug in getTime after insertRow with postgresql-8.1-404.jdbc3.jar
Дата
Msg-id 43BD1383.8090702@htl-steyr.ac.at
обсуждение исходный текст
Ответы Re: bug in getTime after insertRow with postgresql-8.1-404.jdbc3.jar  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
hi,

I suspect, I bumpt into a bug with insertRow.

Here is my java code:

-------------------------------snipp-------------------------------
System.out.println("millisec before
update:"+((java.sql.Time)rs.getTime(dbAttribute)).getTime());

rs.updateTime(dbAttribute, new java.sql.Time( (
(java.util.Date)this.theValue).getTime()));

System.out.println("millisec after
update:"+((java.sql.Time)rs.getTime(dbAttribute)).getTime());

..
..
..


System.out.println("millisec before
insertRow:"+((java.sql.Time)this.db.rs.getTime("ist_von")).getTime());

this.db.rs.insertRow(); //write the actual insert row to table

System.out.println("millisec after
insertRow:"+((java.sql.Time)this.db.rs.getTime("ist_von")).getTime());
-------------------------------snipp-------------------------------

the output is

-------------------------------snipp-------------------------------
millisec before update:60000
millisec after update:60000
millisec before insertRow:60000
millisec after insertRow:3660000
-------------------------------snipp-------------------------------

what indicates that after the insertRow my timezone is added CET -> one
hour more -> 3600000 msec
if I use postgresql-8.0-314.jdbc3.jar
it behaves normal ->

-------------------------------snipp-------------------------------
millisec before update:60000
millisec after update:60000
millisec before insertRow:60000
millisec after insertRow:60000
-------------------------------snipp-------------------------------

thanks for any help

hpb



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Roland Walter
Дата:
Сообщение: Re: table full scan
Следующее
От: "Khaldoun Ateyeh"
Дата:
Сообщение: Re: table full scan