Thread

1. Milliseconds problem with PostgreSQL 7.2 jdbc driver (pgjdbc2.jar )

   Yuva Chandolu <ychandolu@ebates.com> — 2002-06-18T19:57:44Z

   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)
   
   

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

   Barry Lind <barry@xythos.com> — 2002-06-19T19:03:36Z

   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
   >
   >  
   >