Return-Path: 
 <derby-user-return-6170-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 69132 invoked from network); 16 Feb 2007 08:13:39 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Feb 2007 08:13:39 -0000
Received: (qmail 426 invoked by uid 500); 16 Feb 2007 08:13:45 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 396 invoked by uid 500); 16 Feb 2007 08:13:45 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 384 invoked by uid 99); 16 Feb 2007 08:13:45 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Feb 2007 00:13:45 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of naarani@gmail.com designates
 64.233.184.224 as permitted sender)
Received: from [64.233.184.224] (HELO wr-out-0506.google.com) (64.233.184.224)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Feb 2007 00:13:35 -0800
Received: by wr-out-0506.google.com with SMTP id 67so1493788wri
        for <derby-user@db.apache.org>; Fri, 16 Feb 2007 00:13:14 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=uH23TWXpc95aFjuMKHd/+MmIBLZucdXVwssJIua7hAmCrDlIE+H7XQwK2hDX0ya4QXpzgChBjo8dN5uaKaCLWiapvOCq0gG4jJmlaqeftcbTg6QAPYsP2jCYhM1C+rBLNRtHF6cTGBr4934ciYFTOC/T+zR7x2htn8Me2uKuA5s=
Received: by 10.115.108.1 with SMTP id k1mr1600619wam.1171613594139;
        Fri, 16 Feb 2007 00:13:14 -0800 (PST)
Received: by 10.114.241.12 with HTTP; Fri, 16 Feb 2007 00:13:13 -0800 (PST)
Message-ID: <3b2806290702160013v4fe80dcardce86258f28b6af0@mail.gmail.com>
Date: Fri, 16 Feb 2007 09:13:13 +0100
From: "Diego Zanga" <naarani@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: getColumn( table.field) / getInt( table.field )
In-Reply-To: <45D4A2B5.2040300@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <3b2806290702150926l3bb26df8gf48029c370df3ebb@mail.gmail.com>
	 <45D4A2B5.2040300@gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

2007/2/15, Stanley Bradbury <Stan.Bradbury@gmail.com>:
> Diego Zanga wrote:
> > hi!
> >
> > I've seen there is some problem to use a syntax like
> > resultset.getString( "TABLENAME.FIELDNAME" )
> > 'cause it works only with
> > resultset.getString( "FIELDNAME" )
> > ( with every getXXXX method, even getColumn)
> > is there a workaround to allow table.field syntax
> > to identify columns?

> The Java API doc lists columnName or columnIndex as the parameters to
> use with ResultSet.getString.  Do you know if the JDBC specification

yep, however near all the database implements as columnName
the single <columnName> or <table.column>: reading the derby
sql syntax i tought even this db has this syntax
http://db.apache.org/derby/docs/10.1/ref/
-> it works in a select, it doesn't while getting the field value


> states that columnName references support TABLENAME.COLUMNNAME
> syntax?   If so then please file a bug in JIRA to get this corrected.
i'm going to check it :O) when i found where's the references documents :OP
(i've no idea, but hope to find 'em with google)
however can tell me where (address) i could then file it in JIRA?
(i've never submitted a bug, if it's a bug)


cya, Thanks :-)
-- 
Diego Zanga
------------------------------
http://www.eLawOffice.it
http://www.blogstudiolegale.eu
http://www.javablog.eu
Skype NAARANI