From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'Bruce Momjian'" <maillist(at)candle(dot)pha(dot)pa(dot)us>, Andrew Merrill <andrew(at)compclass(dot)com> |
Cc: | pgsql-interfaces(at)hub(dot)org, pgsql-patches(at)hub(dot)org |
Subject: | RE: [INTERFACES] Re: [PATCHES] Patch for JDBC timezone problems |
Date: | 1999-07-07 07:29:55 |
Message-ID: | 1B3D5E532D18D311861A00600865478CA058@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us]
Sent: 07 July 1999 04:17
To: Andrew Merrill
Cc: pgsql-interfaces(at)hub(dot)org; pgsql-patches(at)hub(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania
19026
From | Date | Subject | |
---|---|---|---|
Next Message | Rolland Crunk | 1999-07-07 08:30:18 | Re: [INTERFACES] JDBC - large objects |
Previous Message | Peter Mount | 1999-07-07 07:27:57 | RE: [INTERFACES] postmaster & JDBC |