Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 72682 invoked from network); 21 Mar 2008 15:35:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2008 15:35:47 -0000 Received: (qmail 88292 invoked by uid 500); 21 Mar 2008 15:35:44 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 88260 invoked by uid 500); 21 Mar 2008 15:35:43 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 88249 invoked by uid 99); 21 Mar 2008 15:35:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Mar 2008 08:35:43 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Mar 2008 15:34:55 +0000 Received: from [127.0.0.1] (dell380-desktop [10.10.12.221] (may be forged)) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id m2LFZCNf022225 for ; Fri, 21 Mar 2008 08:35:13 -0700 (PDT) Message-ID: <47E3D5B1.2000100@amberpoint.com> Date: Fri, 21 Mar 2008 08:35:13 -0700 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Timestamp error References: <270119.55583.qm@web33305.mail.mud.yahoo.com> In-Reply-To: <270119.55583.qm@web33305.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > java.sql.SQLException: Column '0' not found. It sounds like you are calling rs.getString("0"). If you want to get the first column in the result, you should know that columns in the JDBC api are numbered starting at 1: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#getString(int) Perhaps you should call rs.getString(1) instead. thanks, bryan