From admin@isorintrade.ca Thu Apr 15 12:29:25 1999 Received: from Airstrike.isorintrade (root@cpu1984.adsl.bellglobal.com [206.47.37.215]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA72227 for ; Thu, 15 Apr 1999 08:29:25 -0400 (EDT) (envelope-from admin@isorintrade.ca) Received: from asdf.sympatico.ca ([192.168.0.3]) by Airstrike.isorintrade (8.9.1/8.9.1) with SMTP id HAA16363 for ; Thu, 15 Apr 1999 07:58:04 -0400 Message-ID: <001101be873b$97211320$0300a8c0@sympatico.ca> From: "admin" To: Subject: JDBC and Postgres Date: Thu, 15 Apr 1999 08:29:21 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01BE871A.0FAABDE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01BE871A.0FAABDE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have two methods in my server side code, employee() which opens db = conenection, perform sql , close connection<-- works fine.. updateinfo() = opens connection perform sql, then i get the Error Column name not = found. The sql command is fine because if i put it in the first method = works fine.. any ideas? Also, any sql command I put in the second method = dosent' work. So my guess is its the db connection, but I can't find = anything wrong with the code. code is at http://www.isorintrade.ca/server.java Thaks Henry ------=_NextPart_000_000E_01BE871A.0FAABDE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I have two methods in my server = side code,=20 employee() which opens db conenection, perform sql , close = connection<--=20 works fine.. updateinfo() opens connection perform sql, then i get the = Error=20 Column name not found. The sql command is fine because if i  put it = in the=20 first method works fine.. any ideas? Also, any sql command I put in the = second=20 method dosent' work. So my guess is its the db connection, but I can't = find=20 anything wrong with the code.
 
 
code is at http://www.isorintrade.ca/= server.java
 
 
Thaks
 
Henry
------=_NextPart_000_000E_01BE871A.0FAABDE0-- From petermount@it.maidstone.gov.uk Thu Apr 15 13:45:10 1999 Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA85369 for ; Thu, 15 Apr 1999 09:45:10 -0400 (EDT) (envelope-from petermount@it.maidstone.gov.uk) Received: from [158.152.139.246] (helo=gatekeeper.maidstone.gov.uk) by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1) id 10XmRu-0001n6-0A for pgsql-interfaces@postgreSQL.org; Thu, 15 Apr 1999 13:44:58 +0000 Received: from exchange.maidstone.gov.uk (exchange.maidstone.gov.uk [172.16.0.211]) by gatekeeper.maidstone.gov.uk (8.8.4/8.8.4) with ESMTP id NAA18802 for ; Thu, 15 Apr 1999 13:43:30 GMT Received: by exchange.maidstone.gov.uk with Internet Mail Service (5.0.1457.3) id <29YLL2C9>; Thu, 15 Apr 1999 14:42:53 +0100 Message-ID: From: Peter Mount To: admin , pgsql-interfaces@postgresql.org Subject: RE: [INTERFACES] JDBC and Postgres Date: Thu, 15 Apr 1999 14:42:49 +0100 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1457.3) Content-Type: text/plain Can you post the full stacktrace that's thrown when this exception occurs. Quickly looking at your code, I cant see anything obviously wrong. Peter -- Peter T Mount, IT Section petermount@it.maidstone.gov.uk Anything I write here are my own views, and cannot be taken as the official words of Maidstone Borough Council -----Original Message----- From: admin [mailto:admin@isorintrade.ca] Sent: Thursday, April 15, 1999 1:29 PM To: pgsql-interfaces@postgreSQL.org Subject: [INTERFACES] JDBC and Postgres Hi, Ihave two methods in my server side code, employee() which opens db conenection, perform sql , close connection-- works fine.. updateinfo() opens connection perform sql, then i get the Error Column name not found. The sql command is fine because if i put it in the first method works fine.. any ideas? Also, any sql command I put in the second method dosent' work. So my guess is its the db connection, but I can't find anything wrong with the code. code is at http://www.isorintrade.ca/server.java Thaks Henry