Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A24A2173D9 for ; Mon, 13 Apr 2015 14:19:07 +0000 (UTC) Received: (qmail 48890 invoked by uid 500); 13 Apr 2015 14:19:07 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 48863 invoked by uid 500); 13 Apr 2015 14:19:07 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Delivered-To: moderator for derby-dev@db.apache.org Received: (qmail 24851 invoked by uid 99); 13 Apr 2015 12:24:30 -0000 X-ASF-Spam-Status: No, hits=3.2 required=5.0 tests=HTML_MESSAGE,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of rohitsonawat@gmail.com does not designate 162.253.133.43 as permitted sender) Date: Mon, 13 Apr 2015 05:08:57 -0700 (MST) From: rohitsonawat To: derby-dev@db.apache.org Message-ID: <1428926937223-143925.post@n7.nabble.com> Subject: Embedded Derby causing out of memory error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6467_1815658466.1428926937224" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_6467_1815658466.1428926937224 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit While Inserting the large data record content say (450kb)using CLOB it is throwing Out of Memory Error.this error is accruing after inserting 200 times data content.Below is the stack trace of it.DBAppender::updateParameters()::Data.Length()::432164 Exception in thread "AppointmentFileListener" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:2367) at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:130) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:114) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:415) at java.lang.StringBuffer.append(StringBuffer.java:237) at java.io.StringWriter.write(StringWriter.java:101)I tried all the possible solution what I am able to do like-Ensuring all the resultset statement are close after completing the transaction.-Setting the CLOB value with setString(),setClob(),setASCIIStream().-Heap size increment to 1GB and 2GB.Any suggestion on this really appreciated.Thanks -- View this message in context: http://apache-database.10148.n7.nabble.com/Embedded-Derby-causing-out-of-memory-error-tp143925.html Sent from the Apache Derby Developers mailing list archive at Nabble.com. ------=_Part_6467_1815658466.1428926937224 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit While Inserting the large data record content say (450kb)using CLOB it is throwing Out of Memory Error.this error is accruing after inserting 200 times data content. Below is the stack trace of it. DBAppender::updateParameters()::Data.Length()::432164 Exception in thread "AppointmentFileListener" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:2367) at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:130) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:114) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:415) at java.lang.StringBuffer.append(StringBuffer.java:237) at java.io.StringWriter.write(StringWriter.java:101) I tried all the possible solution what I am able to do like -Ensuring all the resultset statement are close after completing the transaction. -Setting the CLOB value with setString(),setClob(),setASCIIStream(). -Heap size increment to 1GB and 2GB. Any suggestion on this really appreciated. Thanks
View this message in context: Embedded Derby causing out of memory error
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
------=_Part_6467_1815658466.1428926937224--