Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 16543 invoked from network); 4 Oct 2005 23:13:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Oct 2005 23:13:29 -0000 Received: (qmail 29886 invoked by uid 500); 4 Oct 2005 23:13:28 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 29867 invoked by uid 500); 4 Oct 2005 23:13:28 -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 29856 invoked by uid 99); 4 Oct 2005 23:13:28 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 16:13:28 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=RCVD_BY_IP,RCVD_IN_BL_SPAMCOP_NET,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of ksunithaghm@gmail.com designates 72.14.204.207 as permitted sender) Received: from [72.14.204.207] (HELO qproxy.gmail.com) (72.14.204.207) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 16:13:31 -0700 Received: by qproxy.gmail.com with SMTP id o12so33601qba for ; Tue, 04 Oct 2005 16:13:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=QExyQc5y8vL6wnLY/KNCYjnxMbndTskFi/3I3v8qUuSxS8aEl0pN0tCGj66w90U7H6RBgxeHgDP3F9XXzUmN9JBow8sjttw95wfUXHGXzugpiVxNMSEkloqESOtYSa/J1HmcZEU1Lpyd/c0nzjcFUPVIKfvIjqy381rngJZWZbs= Received: by 10.64.251.10 with SMTP id y10mr68625qbh; Tue, 04 Oct 2005 16:13:05 -0700 (PDT) Received: from ?71.131.60.63? ( [71.131.60.63]) by mx.gmail.com with ESMTP id o32sm92520qbe.2005.10.04.16.13.05; Tue, 04 Oct 2005 16:13:05 -0700 (PDT) Message-ID: <43430C64.8090605@gmail.com> Date: Tue, 04 Oct 2005 16:12:36 -0700 From: Sunitha Kambhampati User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: CLOBs and the Client driver References: <4342312E.600@nuix.com.au> <4342BA4D.3000902@Source-Zone.Org> <43430BE3.8020100@nuix.com.au> In-Reply-To: <43430BE3.8020100@nuix.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Daniel Noll wrote: > Rajesh Kartha wrote: > >> Hi Daniel, >> >> Can you post the way you are retrieving the CLOBs from the >> ResultSet. I have used the rs.getAsciiStream() and >> rs.getCharacterStream() >> methods for getting CLOBs in the past (with the Client driver) and it >> seemed to work just fine. > > > Hmm, maybe that's it. In this case we knew we needed the whole CLOB > in advance, so we were reading it with getString(). Perhaps the > client driver always returns "" for this whereas the embedded driver > actually returns us the data. > > I'd expect getString() to return the data when you use the client driver, similar to the embedded driver. If it is possible, can you post the code that seems to have a problem and open a jira entry for it. Thanks. Sunitha.