Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 9045 invoked from network); 18 Sep 2006 12:05:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Sep 2006 12:05:08 -0000 Received: (qmail 42069 invoked by uid 500); 18 Sep 2006 12:05:07 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 41837 invoked by uid 500); 18 Sep 2006 12:05:06 -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 41826 invoked by uid 99); 18 Sep 2006 12:05:06 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 05:05:06 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [85.207.124.0] (HELO brutus.loc) (85.207.124.0) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 05:04:56 -0700 Received: by brutus.loc (Postfix, from userid 1007) id 0D848F15F; Mon, 18 Sep 2006 14:04:06 +0200 (CEST) Received: from [192.168.0.88] (unknown [192.168.0.88]) by brutus.loc (Postfix) with ESMTP id 54566F13E for ; Mon, 18 Sep 2006 14:04:05 +0200 (CEST) Message-ID: <450E8C94.6030602@post.cz> Date: Mon, 18 Sep 2006 14:09:56 +0200 From: Radek Terber User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; cs-CZ; rv:1.8.0.4) Gecko/20060516 SeaMonkey/1.0.2 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Insert large using SQL Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Checker-Version: SpamAssassin 2.64 (2004-01-11) on brutus.loc X-Spam-Level: X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, hits=-0.6 required=4.0 tests=BAYES_01 autolearn=ham version=2.64 X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I need insert large text (over 100 KB) into column type CLOB (created as max. available size - cca 2GB) using SQL command, but derby (latest release) inserts only cca 32 KB. If text is larger, derby throws SQL exception with description 'A string constant starting with ''inserted text ... &' is too long'. Is it a derby bug, or I do enything wrong ? I am new in derby. Thanks for every response.