RE: [INTERFACES] Re: [PATCHES] Patch for JDBC timezone problems
От | Peter Mount |
---|---|
Тема | RE: [INTERFACES] Re: [PATCHES] Patch for JDBC timezone problems |
Дата | |
Msg-id | 1B3D5E532D18D311861A00600865478CA058@exchange1.nt.maidstone.gov.uk обсуждение исходный текст |
Список | pgsql-interfaces |
I committed a patch for this some time ago. Check the JDBC CHANGELOG file, as I'm sure I mentioned it in there. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council. -----Original Message----- From: Bruce Momjian [mailto:maillist@candle.pha.pa.us] Sent: 07 July 1999 04:17 To: Andrew Merrill Cc: pgsql-interfaces@hub.org; pgsql-patches@hub.org Subject: [INTERFACES] Re: [PATCHES] Patch for JDBC timezone problems This was never applied. Can someone tell me if it should be. Peter? > The attached patch fixes the problems that the JDBC driver has with > timezones in getTimestamp. The issues were described in an earlier > post, this is just the patch. > > Andrew Merrill > > *** ./src/interfaces/jdbc/postgresql/jdbc1/ResultSet.java.orig Tue May 11 09:39:37 1999 > --- ./src/interfaces/jdbc/postgresql/jdbc1/ResultSet.java Tue May 11 09:40:56 1999 > *************** > *** 438,449 **** > > if (s != null) > { > int TZ = new Float(s.substring(19)).intValue(); > TZ = TZ * 60 * 60 * 1000; > TimeZone zone = TimeZone.getDefault(); > zone.setRawOffset(TZ); > String nm = zone.getID(); > ! s = s.substring(0,18) + nm; > try { > java.util.Date d = df.parse(s); > return new Timestamp(d.getTime()); > --- 438,451 ---- > > if (s != null) > { > + /* commented out by Andrew Merrill 5/1999 > int TZ = new Float(s.substring(19)).intValue(); > TZ = TZ * 60 * 60 * 1000; > TimeZone zone = TimeZone.getDefault(); > zone.setRawOffset(TZ); > String nm = zone.getID(); > ! s = s.substring(0,19) + nm; > ! */ > try { > java.util.Date d = df.parse(s); > return new Timestamp(d.getTime()); > *** ./src/interfaces/jdbc/postgresql/jdbc2/ResultSet.java.orig Tue May 11 09:41:14 1999 > --- ./src/interfaces/jdbc/postgresql/jdbc2/ResultSet.java Tue May 11 09:42:16 1999 > *************** > *** 440,451 **** > > if (s != null) > { > int TZ = new Float(s.substring(19)).intValue(); > TZ = TZ * 60 * 60 * 1000; > TimeZone zone = TimeZone.getDefault(); > zone.setRawOffset(TZ); > String nm = zone.getID(); > ! s = s.substring(0,18) + nm; > try { > java.util.Date d = df.parse(s); > return new Timestamp(d.getTime()); > --- 440,453 ---- > > if (s != null) > { > + /* commented out by Andrew Merrill 5/1999 > int TZ = new Float(s.substring(19)).intValue(); > TZ = TZ * 60 * 60 * 1000; > TimeZone zone = TimeZone.getDefault(); > zone.setRawOffset(TZ); > String nm = zone.getID(); > ! s = s.substring(0,19) + nm; > ! */ > try { > java.util.Date d = df.parse(s); > return new Timestamp(d.getTime()); -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-interfaces по дате отправления: