Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g08ERdB67740 for ; Tue, 8 Jan 2002 09:27:44 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id g08E1js56681 for pgsql-sql@postgresql.org; Tue, 8 Jan 2002 09:01:45 -0500 (EST) (envelope-from news) From: "Ty" X-Newsgroups: comp.databases.postgresql.sql Subject: Meta Data/Schema/DDL Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. Organization: WebUseNet Corp. - "ReInventing The UseNet" Date: Tue, 8 Jan 2002 08:48:47 -0600 To: pgsql-sql@postgresql.org X-Archive-Number: 200201/129 X-Sequence-Number: 6217 Hello, I'm trying to complete a Forte for Java tutorial using Red Hat Linux 7.2. Wierd things: Using MySQL -- All records in table show-up on my initial connection select query using jsp, jdbc connection SELECT * FROM CD; Using PostgreSQL -- only the last record shows up in the jsp, jdbc connection (if I write as small console data query app. this works fine-- not in jsp though) At a certain point in the tutorial, I had to import the database schema, and forte would generate fields, set and get methods (functions) to access the tables in the database-- PostgreSQL doesn't return and db fields. I verified referential integrity would be enforced, this wasn't possible in MySQL, that's why I switched to Postgres. I'd appreciate any explanation anyone could offer. Thanks, Tyrone