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

Funny! If I use
postgresql-8.0-314.jdbc3.jar
it works fine
if I use
postgresql-8.1-404.jdbc3.jar
it shows this error.

May be that there is another issue than the driver ??????

hpb

Pradeep Sharma schrieb:
> Which driver you are currently using. I found the same issue with
> postgresql-8.0-314.jdbc3.jar
>
> After that I am using the latest driver from postgres site, and it seems
> to be working fine.
>
> One thing is sure it is a problem with the driver.
>
> Pradeep
>
> On 1/5/06, *hpb(at)htl-steyr(dot)ac(dot)at <mailto:hpb(at)htl-steyr(dot)ac(dot)at>*
> <hpb(at)htl-steyr(dot)ac(dot)at <mailto:hpb(at)htl-steyr(dot)ac(dot)at>> wrote:
>
> 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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org
> <mailto:majordomo(at)postgresql(dot)org> so that your
> message can get through to the mailing list cleanly
>
>
>
>
> --
> Pradeep Sharma
> In2M Corporation,
> Mumbai
> Mob.- +91-9892853803