Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect

From: Ravi Periasamy <ravitx12(at)yahoo(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect
Date: 2007-01-12 13:06:31
Message-ID: 448045.99581.qm@web60519.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


A after thought- I was working with Oliver Cloud on a
similar issue and he has a fix for that issue, that
would solve this as well.

Basically the changeTime() method called from
Statement.getDate(int, Calendar) is causing the
problem. Make sure, the code from
ResultSet.getDate(int, Calendar) is reused here too.

I worked around this and it's working for me now.

Thanks
Ravi

--- Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:

> Ravi Periasamy wrote:
> > I do not think this is a server issue, seems like
> a
> > driver issue. When I connect to the DB from RHEL4
> > through the driver (running on RHEL4) it works.
> But,
> > when the driver is running on RHEL3 it fails.
>
> Oh, I hadn't realized that both clients were
> connecting to the same
> server. Yes, most likely this is a JDBC issue of
> some sort. Can't help
> you there.
>
> > What is IIRC?
>
> If I Recall Correctly.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom
> Development, 24x7 support
>


____________________________________________________________________________________
Never Miss an Email
Stay connected with Yahoo! Mail on your mobile. Get started!
http://mobile.yahoo.com/services?promote=mail

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zubkovsky, Sergey 2007-01-12 14:48:48 PG unexpected crash
Previous Message Alvaro Herrera 2007-01-12 12:57:56 Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect