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
|
Список | 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 по дате отправления: