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)

Tue, 18 Jun 2002 12:57:44 -0700
Yuva Chandolu <ychandolu@ebates.com>
Milliseconds problem with PostgreSQL 7.2 jdbc driver (pgjdbc2.jar
	)
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@postgresql.org
>
>  
>



Wed, 19 Jun 2002 12:03:36 -0700
Barry Lind <barry@xythos.com>
Re: [HACKERS] Milliseconds problem with PostgreSQL 7.2 jdbc driver