Re: [HACKERS] Milliseconds problem with PostgreSQL 7.2 jdbc driver

From: Barry Lind <barry(at)xythos(dot)com>
To: Yuva Chandolu <ychandolu(at)ebates(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [HACKERS] Milliseconds problem with PostgreSQL 7.2 jdbc driver
Date: 2002-06-19 19:03:36
Message-ID: 3D10D588.2060204@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Yuva,

Your question would be more appropriate for the pgsql-jdbc mailing list.

The fix to your problem is in version 1.48 of
org/postgresql/jdbc2/ResultSet.java. This happens to be the first
change after 7.2 which is version 1.47. Thus you should have no problem
applying this fix to your 7.2 driver. (you can go to the webcvs
interface off of developer.postgresql.org to see the diffs for yourself).

thanks,
--Barry

Yuva Chandolu wrote:

>Hi,
>
>We observed a "String index out of range: 23" problem when we tried to
>retrieve timestamp field value that has milliseconds. We are trying to find
>a quick fix for the millisecond problem for Timestamp.
>
>We notice there is a beta driver(devpgjdbc2.jar) that contains this fix
>currently, but was wondering if the fix is issolated to just one or a few
>classes that we might get from the beta driver and insert into the
>production driver jar(pgjdbc2.jar).
>
>Is this an potential option or is the dependency risk too high?
>
>Thanks
>Yuva
>Ebates Shopping.com (http://www.ebates.com)
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ryan 2002-06-19 19:19:25 count and group by question
Previous Message Bruce Momjian 2002-06-19 17:39:20 Re: COPY syntax improvement

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Adler 2002-06-19 21:33:57 Re: COPY support in pgsql-jdbc driver
Previous Message Yuva Chandolu 2002-06-19 18:13:27 String index out of range: 23 problem with timestamp milliseconds