From derby-user-return-9588-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Jul 22 04:05:00 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 16074 invoked from network); 22 Jul 2008 04:05:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Jul 2008 04:05:00 -0000 Received: (qmail 32683 invoked by uid 500); 22 Jul 2008 04:04:59 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 32658 invoked by uid 500); 22 Jul 2008 04:04:58 -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 32647 invoked by uid 99); 22 Jul 2008 04:04:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Jul 2008 21:04:58 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dmclean62@gmail.com designates 64.233.184.236 as permitted sender) Received: from [64.233.184.236] (HELO wr-out-0506.google.com) (64.233.184.236) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jul 2008 04:04:05 +0000 Received: by wr-out-0506.google.com with SMTP id 67so1093526wri.3 for ; Mon, 21 Jul 2008 21:04:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=w0v1IzaUW0qBttFH1SPWISthgJOycAfKr7NgTcYFAfk=; b=S/p3/Tso/pTQZW+MQynGxH58n/yng7prgiMHYkYhXIz6x9/MlOD8kJYwrovOKOJDt6 XxbqVtzo/v9OzoL6FRlXh+2jqnic099zEI+0diFfy50Mjj3LdPNcmJ4NhoWT4vk/gpeA mJ1tY8qur/K31VQokv50x3srQYjj9svRxTSGA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=ZVxv5ASirfELkDo6WYqOOqgqKK0zvTY0fxvADY+HbNGiNCdjQPDAjFocMWRkSh7nsv XtIqbTft7AwLtClWMEgRbWYWxQHAOeub/ZelpcGOQ+llyWiBGEvav4lIr0bisyFEATjc rSC8Gy01kHRl/VrwOiVM1ZaLrgmOxZ6JBV7VY= Received: by 10.90.96.15 with SMTP id t15mr2681544agb.8.1216699469633; Mon, 21 Jul 2008 21:04:29 -0700 (PDT) Received: by 10.90.84.19 with HTTP; Mon, 21 Jul 2008 21:04:29 -0700 (PDT) Message-ID: <5627810d0807212104p51b4ead0m36ebf4987787c7fc@mail.gmail.com> Date: Tue, 22 Jul 2008 00:04:29 -0400 From: "Donald McLean" To: "Derby Discussion" Subject: Re: cannot invoke other java.sql.Clob In-Reply-To: <48855942.1050408@nuix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <488547B0.2050908@nuix.com> <5627810d0807212045i51bed057t3f4bb872608f05e0@mail.gmail.com> <48855942.1050408@nuix.com> X-Virus-Checked: Checked by ClamAV on apache.org I've seen cases like this where autocommit didn't seem to want to STAY off. Try turning it off just before the select - just to be completely sure. What could it hurt? Donald On Mon, Jul 21, 2008 at 11:51 PM, Daniel Noll wrote: > Donald McLean wrote: >> >> With clobs and blobs this error is almost always caused by autocommit. >> When autocommit is on, the select is committed before you get a chance >> to retrieve the value of the clob or blob column. Obviously then, if >> you are going to select a clob or blob column, you have to turn it off >> first. >> >> Sometimes this is inconvenient, but can't be avoided. > > We don't have autocommit turned on either. Or rather, we explicitly turn it > off after getting the connection.