Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 60361 invoked from network); 16 Apr 2007 14:29:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Apr 2007 14:29:16 -0000 Received: (qmail 27567 invoked by uid 500); 16 Apr 2007 14:29:20 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 27543 invoked by uid 500); 16 Apr 2007 14:29:20 -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 27532 invoked by uid 99); 16 Apr 2007 14:29:20 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Apr 2007 07:29:20 -0700 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 rubenfonseca@di.uminho.pt designates 193.136.19.25 as permitted sender) Received: from [193.136.19.25] (HELO mx2.di.uminho.pt) (193.136.19.25) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Apr 2007 07:29:13 -0700 Received: (qmail 20817 invoked from network); 16 Apr 2007 14:28:51 -0000 Received: from localhost (HELO [192.168.67.151]) ([127.0.0.1]) (envelope-sender ) by mx2.di.uminho.pt (qmail-ldap-1.03) with SMTP for ; 16 Apr 2007 14:28:51 -0000 Subject: Re: Store very large Strings From: Ruben Fonseca To: Derby Discussion In-Reply-To: References: <1176472207.14806.10.camel@localhost.localdomain> <461F8C11.4000202@sun.com> <1176473270.4064.1.camel@localhost.localdomain> <461FBBAE.4050907@sbcglobal.net> <1176488485.15037.1.camel@0x82> Content-Type: text/plain Date: Mon, 16 Apr 2007 15:28:44 +0100 Message-Id: <1176733724.4242.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org On Fri, 2007-04-13 at 11:31 -0700, Raymond Kroeker wrote: > Hi Ruben, > The connection object has a setAutoCommit(boolean) api. If you > can easily reference it and are not running within a transaction > manager framework set it to false for the method call. > Ok, this really solved my problem. THANK YOU. Now my second question is: is this the expected behaviour? It is really necessary to disable AutoCommit when dealing with large BLOBs in Derby? Ruben