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 SAA24636 for ; Mon, 18 Jan 1999 18:40:11 -0500 (EST) (envelope-from gholmer@weycogroup.com) Received: from shadow.sna.ibm.com (ferengal-2-153.mdm.mke.execpc.com [169.207.130.91]) by mailgw00.execpc.com (8.9.1) id RAA07118 for ; Mon, 18 Jan 1999 17:40:00 -0600 Message-Id: <199901182340.RAA07118@mailgw00.execpc.com> From: "Glenn Holmer" To: "Postgres Interface list" Date: Mon, 18 Jan 1999 17:31:31 +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.F5S18J138764=_=_=_" Subject: JDBC -- can't create table --_=_=_=IMA.BOUNDARY.F5S18J138764=_=_=_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I am running Postgres 6.3 on a Linux box (S.u.S.E. 5.3, kernel 2.0.35) and connecting from another Linux box. Both are running Java 1.1.7 from Blackdown. I can connect to the remote machine and even create a database, but I am unable to create a table. I've included the code as an attachment. The exact output is as follows: -------------------------------------------------------- loading JDBC class "postgresql.Driver"... connecting to jdbc:postgresql://miranda:5432/factory... creating skid table... ERROR: cannot create skids -------------------------------------------------------- I do wind up with an empty file named "skids" on the server at /var/lib/pgsql/data/base/factory. I can't understand if this is just some simple permissions problem or something else I overlooked. Does anybody see anything obvious? Is there a way to get a more detailed error message than "cannot create skids"? I created the database by hand with psql as user "factory" on the server before running this test code. -- ____________________________________________________________ Glenn Holmer gholmer@weycogroup.com Programmer/Analyst phone: 414.263.8827 Weyco Group, Inc. fax: 414.263.8808 --_=_=_=IMA.BOUNDARY.F5S18J138764=_=_=_ Content-Type: application/octet-stream; name="test.java" Content-Transfer-Encoding: base64 LyoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKiANCiAgdGVzdC5qYXZhIC0tIENyZWF0ZSBlbXB0eSB0YWJsZXMg Zm9yIGZhY3RvcnkgcHJvamVjdC4KIA0NCiAgcmV2aXNpb24gaGlzdG9yeToNDQogIC0tLS0tLS0t LS0tLS0tLS0tDQ0KICAwLjAxIGdoIDAxLzE5OTkNDQogKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqLyANDQoN CmltcG9ydCBqYXZhLmxhbmcuKjsNCmltcG9ydCBqYXZhLm5ldC4qOw0KaW1wb3J0IGphdmEuc3Fs Lio7DQppbXBvcnQgamF2YS51dGlsLio7DQoNCnB1YmxpYyBjbGFzcyB0ZXN0IHsNCiAgU3RyaW5n IHVybCwgczsNCiAgQ29ubmVjdGlvbiBjOw0KICBTdGF0ZW1lbnQgc3RtdDsNCiAgU3RyaW5nIFNR THN0bXQ7DQoNCiAgdGVzdCAoKSB7DQ0KICAgIHRyeSB7IA0KICAgICAgU3lzdGVtLm91dC5wcmlu dGxuKCJcbmxvYWRpbmcgSkRCQyBjbGFzcyBcInBvc3RncmVzcWwuRHJpdmVyXCIuLi4iKTsNCiAg ICAgIENsYXNzLmZvck5hbWUoInBvc3RncmVzcWwuRHJpdmVyIik7DQoKICAgICAgdXJsID0gImpk YmM6cG9zdGdyZXNxbDovL21pcmFuZGE6NTQzMi9mYWN0b3J5IjsNCiAgICAgIFN5c3RlbS5vdXQu cHJpbnRsbigiXG5jb25uZWN0aW5nIHRvICIgKyB1cmwgKyAiLi4uIik7DQogICAgICBjID0gRHJp dmVyTWFuYWdlci5nZXRDb25uZWN0aW9uKHVybCwgImZhY3RvcnkiLCAiZmFjdG9yeSIpOyANDQoN ICAgICAgc3RtdCA9IGMuY3JlYXRlU3RhdGVtZW50ICgpOwogICAgICBTeXN0ZW0ub3V0LnByaW50 bG4oIlxuY3JlYXRpbmcgc2tpZCB0YWJsZS4uLiIpOyAgICAgICAgDQ0KICAgICAgU1FMc3RtdCA9 ICJDUkVBVEUgVEFCTEUgc2tpZHMgKCINCiAgICAgICAgICAgICAgKyAiICB0aGlzIGNoYXIoNCks Ig0KICAgICAgICAgICAgICArICIgIHRoYXQgaW50Ig0KICAgICAgICAgICAgICArICIpIjsNCiAg ICAgIHN0bXQuZXhlY3V0ZVVwZGF0ZShTUUxzdG10KTsNCiAgICAgIFN5c3RlbS5vdXQucHJpbnRs bigiXG5jbG9zaW5nIGNvbm5lY3Rpb24uLi4iKTsNCiAgICAgIGMuY2xvc2UoKTsJCQkJICAgICAg DQogICAgfSBjYXRjaCAoRXhjZXB0aW9uIGUpIHsNCiAgICAgIFN5c3RlbS5vdXQucHJpbnRsbiAo ZS5nZXRNZXNzYWdlKCkpOw0KICAgICAgU3lzdGVtLmV4aXQoMSk7DQogICAgfQ0KICB9DQoNCiAg Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vLy8NCiAgLy8gZW50cnkgcG9pbnQ6DQ0KICAvLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Lw0KICBwdWJsaWMgc3RhdGljIHZvaWQgbWFpbihTdHJpbmcgYXJndltdKSB7DQogICAgbmV3IHRl c3QoKTsNCiAgfQ0KfQ0KDQo= --_=_=_=IMA.BOUNDARY.F5S18J138764=_=_=_--