Received: from palle.girgensohn.se (c213.89.164.11.cm-upc.chello.se [213.89.164.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f492k7A55660; Tue, 8 May 2001 22:46:07 -0400 (EDT) (envelope-from girgen@partitur.se) Received: from partitur.se (localhost [127.0.0.1]) by palle.girgensohn.se (8.11.3/8.11.3) with ESMTP id f492jwr18388; Wed, 9 May 2001 04:45:58 +0200 (CEST) (envelope-from girgen@partitur.se) Message-ID: <3AF8AF64.DC970DA@partitur.se> Date: Wed, 09 May 2001 04:45:56 +0200 From: Palle Girgensohn Organization: Partitur X-Mailer: Mozilla 4.76 [en] (X11; U; FreeBSD 4.3-RELEASE i386) X-Accept-Language: sv, en MIME-Version: 1.0 To: Bruce Momjian CC: Juhan-Peep Ernits , pgsql-interfaces@postgresql.org, pgsql-jdbc@postgresql.org Subject: Re: [JDBC] Re: Trouble with JDBC2 ResultSet.getDate() References: <200105081644.f48GiPH09382@candle.pha.pa.us> Content-Type: multipart/mixed; boundary="------------2CB95F0F72E82FB224E52D27" X-Archive-Number: 200105/41 X-Sequence-Number: 1567 This is a multi-part message in MIME format. --------------2CB95F0F72E82FB224E52D27 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Here's a patch that works fine for me. Cheers, Palle Bruce Momjian wrote: > > > Well, I didn't see the patch, but my message (probably you just > > received) points to the fact that getDate shall work on a > > timestamp column, and some kind of patch shall be applied. I > > something like this: > > > > if s.length() == 10 > > return java.sql.Date.valueOf(s) > > else do the old 7.0.3 SimpleDateFormatter stuff. > > > > *or* > > > > try { > > return java.sql.Date.valueOf(s) > > } catch (SQLException e) { > > do the old SimpleDateFormatter stuff... > > } > > > > sort of... gotta go, or I'd have sent you a full patch. > > Would you, please? Thanks. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@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 --------------2CB95F0F72E82FB224E52D27 Content-Type: application/octet-stream; name="patch-jdbc-getdate" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="patch-jdbc-getdate" LS0tIHNyYy9pbnRlcmZhY2VzL2pkYmMvb3JnL3Bvc3RncmVzcWwvamRiYzIv UmVzdWx0U2V0LmphdmF+CUZyaSBGZWIgMjMgMTk6MTI6MjMgMjAwMQorKysg c3JjL2ludGVyZmFjZXMvamRiYy9vcmcvcG9zdGdyZXNxbC9qZGJjMi9SZXN1 bHRTZXQuamF2YQlXZWQgTWF5ICA5IDA0OjMxOjExIDIwMDEKQEAgLTQyMyw4 ICs0MjMsMTMgQEAKICAgICBTdHJpbmcgcyA9IGdldFN0cmluZyhjb2x1bW5J bmRleCk7CiAgICAgaWYocz09bnVsbCkKICAgICAgIHJldHVybiBudWxsOwot Ci0gICAgcmV0dXJuIGphdmEuc3FsLkRhdGUudmFsdWVPZihzKTsKKyAgICAv LyBsZW5ndGggPT0gMTA6IFNRTCBEYXRlCisgICAgLy8gbGVuZ3RoID4gIDEw OiBTUUwgVGltZXN0YW1wLCBhc3N1bWVzIFBHREFURVNUWUxFPUlTTworICAg IHRyeSB7CisgICAgICByZXR1cm4gamF2YS5zcWwuRGF0ZS52YWx1ZU9mKChz Lmxlbmd0aCgpID09IDEwKSA/IHMgOiBzLnN1YnN0cmluZygwLDEwKSk7Cisg ICAgfSBjYXRjaCAoTnVtYmVyRm9ybWF0RXhjZXB0aW9uIGUpIHsKKyAgICAg IHRocm93IG5ldyBQU1FMRXhjZXB0aW9uKCJwb3N0Z3Jlc3FsLnJlcy5iYWRk YXRlIiwgcyk7CisgICAgfQogICB9CiAKICAgLyoqCkBAIC00NDEsOCArNDQ2 LDEzIEBACiAKICAgICBpZihzPT1udWxsKQogICAgICAgcmV0dXJuIG51bGw7 IC8vIFNRTCBOVUxMCi0KLSAgICByZXR1cm4gamF2YS5zcWwuVGltZS52YWx1 ZU9mKHMpOworICAgIC8vIGxlbmd0aCA9PSA4OiBTUUwgVGltZQorICAgIC8v IGxlbmd0aCA+ICA4OiBTUUwgVGltZXN0YW1wCisgICAgdHJ5IHsKKyAgICAg IHJldHVybiBqYXZhLnNxbC5UaW1lLnZhbHVlT2YoKHMubGVuZ3RoKCkgPT0g OCkgPyBzIDogcy5zdWJzdHJpbmcoMTEsMTkpKTsKKyAgICB9IGNhdGNoIChO dW1iZXJGb3JtYXRFeGNlcHRpb24gZSkgeworICAgICAgdGhyb3cgbmV3IFBT UUxFeGNlcHRpb24oInBvc3RncmVzcWwucmVzLmJhZHRpbWUiLHMpOworICAg IH0KICAgfQogCiAgIC8qKgo= --------------2CB95F0F72E82FB224E52D27--