Received: from mailgw00.execpc.com (sendmail@mailgw00.execpc.com [169.207.1.78]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA24698 for ; Fri, 22 Jan 1999 18:21:42 -0500 (EST) (envelope-from gholmer@weycogroup.com) Received: from shadow.sna.ibm.com (zanak-1-51.mdm.mke.execpc.com [169.207.93.51]) by mailgw00.execpc.com (8.9.1) id RAA17816 for ; Fri, 22 Jan 1999 17:21:39 -0600 Message-Id: <199901222321.RAA17816@mailgw00.execpc.com> From: "Glenn Holmer" To: "Postgres interface list" Date: Fri, 22 Jan 1999 17:20:34 +0000 Reply-To: "Glenn Holmer" Priority: Normal X-Mailer: PMMail 1.96 For OS/2 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="_=_=_=IMA.BOUNDARY.F5ZFEA138764=_=_=_" Subject: JDBC throws with error code 0 --_=_=_=IMA.BOUNDARY.F5ZFEA138764=_=_=_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I am still having troubles trying to determine the source of some rather bizarre behavior here. My database "factory" is on Postgres 6.3 on a Linux box, and I am attempting to access it with a Java program. The database was created using psql "create database SkidData;" and "\i SkidData.i". SkidData.i looks like this: CREATE TABLE SkidData ( WIPno char(6), Style char(8), Color char(3), Width char(3), Size char(3), UPC char(12), Pairs int, SkidNo char(5), CaseNo char(2), SkidType char(2), bCaseFull boolean, bSentTo400 boolean, DatePacked date, TimePacked time, DateShipped date, TimeShipped time, StationID char(1) ); The table was loaded from a flat file using a Java program. When I open psql on the server and type factory=> select distinct SkidNo from SkidData; I get a nice list of skid numbers. The attached file, however, when compiled, produces the following output: loading JDBC class "postgresql.Driver"... connecting to jdbc:postgresql://miranda:5432/factory... executeQuery... Unknown Response Type: return code is: 0 This is making me very confused. Why does it throw if the return code is 0? Can anybody shed some light on this? -- ____________________________________________________________ Glenn Holmer gholmer@weycogroup.com Programmer/Analyst phone: 414.263.8827 Weyco Group, Inc. fax: 414.263.8808 --_=_=_=IMA.BOUNDARY.F5ZFEA138764=_=_=_ Content-Type: application/octet-stream; name="test.java" Content-Transfer-Encoding: base64 LyoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqDQogIHRlc3QuamF2YSANCiAqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKi8NCg0K aW1wb3J0IGphdmEuc3FsLio7DQppbXBvcnQgamF2YS51dGlsLio7DQoNCnB1YmxpYyBjbGFzcyB0 ZXN0IHsNCiAgU3RyaW5nIHVybCwgU1FMc3RtdDsNCiAgQ29ubmVjdGlvbiBjOw0KICBTdGF0ZW1l bnQgc3RtdDsNCiAgUmVzdWx0U2V0IHJzOw0KDQogIHB1YmxpYyB0ZXN0ICgpIHsNCiAgICB0cnkg eyANCiAgICAgIFN5c3RlbS5vdXQucHJpbnRsbiAoIlxubG9hZGluZyBKREJDIGNsYXNzIFwicG9z dGdyZXNxbC5Ecml2ZXJcIi4uLiIpOw0KICAgICAgQ2xhc3MuZm9yTmFtZSAoInBvc3RncmVzcWwu RHJpdmVyIik7DQogICAgfSBjYXRjaCAoRXhjZXB0aW9uIGVEcml2ZXIpIHsNCiAgICAgIFN5c3Rl bS5vdXQucHJpbnRsbiAoImNhbid0IGxvYWQgSkRCQyBkcml2ZXI6Iik7DQogICAgICBTeXN0ZW0u b3V0LnByaW50bG4gKGVEcml2ZXIuZ2V0TWVzc2FnZSgpKTsNCiAgICAgIFN5c3RlbS5leGl0ICgx KTsNCiAgICB9DQoNCiAgICB0cnkgew0KICAgICAgdXJsID0gImpkYmM6cG9zdGdyZXNxbDovL21p cmFuZGE6NTQzMi9mYWN0b3J5IjsNCiAgICAgIFN5c3RlbS5vdXQucHJpbnRsbiAoIlxuY29ubmVj dGluZyB0byAiICsgdXJsICsgIi4uLiIpOw0KICAgICAgYyA9IERyaXZlck1hbmFnZXIuZ2V0Q29u bmVjdGlvbiAodXJsLCAiZmFjdG9yeSIsICJmYWN0b3J5Iik7IA0KICAgICAgc3RtdCA9IGMuY3Jl YXRlU3RhdGVtZW50ICgpOw0KICAgIH0gY2F0Y2ggKEV4Y2VwdGlvbiBlQ29ubmVjdCkgew0KICAg ICAgU3lzdGVtLm91dC5wcmludGxuICgiY2FuJ3QgY29ubmVjdCB0byBkYXRhYmFzZToiKTsNCiAg ICAgIFN5c3RlbS5vdXQucHJpbnRsbiAoZUNvbm5lY3QuZ2V0TWVzc2FnZSgpKTsNCiAgICAgIFN5 c3RlbS5leGl0KDEpOw0KICAgIH0NCiAgICANCiAgICBTeXN0ZW0ub3V0LnByaW50bG4gKCJleGVj dXRlUXVlcnkuLi4iKTsNCiAgICBTUUxzdG10ID0gIlNFTEVDVCBESVNUSU5DVCBTa2lkTm8gRlJP TSBTa2lkRGF0YSI7DQogICAgdHJ5IHsNCiAgICAgIHJzID0gc3RtdC5leGVjdXRlUXVlcnkgKFNR THN0bXQpOw0KICAgIH0gY2F0Y2ggKFNRTEV4Y2VwdGlvbiBlU1FMKSB7DQogICAgICBTeXN0ZW0u b3V0LnByaW50bG4gKGVTUUwuZ2V0TWVzc2FnZSAoKSk7DQogICAgICBTeXN0ZW0ub3V0LnByaW50 bG4gKCJyZXR1cm4gY29kZSBpczogIiArIGVTUUwuZ2V0RXJyb3JDb2RlKCkpOw0KICAgICAgU3lz dGVtLmV4aXQgKDEpOw0KICAgIH0NCg0KICAgIHRyeSB7DQogICAgICB3aGlsZSAocnMubmV4dCAo KSkgew0KICAgICAgICBTeXN0ZW0ub3V0LnByaW50bG4gKHJzLmdldFN0cmluZyAoIlNraWRObyIp KTsNCiAgICAgIH0NCiAgICB9IGNhdGNoIChTUUxFeGNlcHRpb24gZVNRTCkgew0KICAgICAgU3lz dGVtLm91dC5wcmludGxuICgidGhyb3duISBjYXVnaHQhIik7DQogICAgfQ0KICB9IA0KDQogIHB1 YmxpYyBzdGF0aWMgdm9pZCBtYWluIChTdHJpbmcgYXJndltdKSB7DQogICAgbmV3IHRlc3QgKCk7 DQogIH0NCn0NCg== --_=_=_=IMA.BOUNDARY.F5ZFEA138764=_=_=_--