Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 42328 invoked from network); 29 Apr 2008 15:17:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Apr 2008 15:17:39 -0000 Received: (qmail 27992 invoked by uid 500); 29 Apr 2008 15:17:40 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27971 invoked by uid 500); 29 Apr 2008 15:17:40 -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 Received: (qmail 27960 invoked by uid 99); 29 Apr 2008 15:17:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Apr 2008 08:17:40 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Apr 2008 15:16:55 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5DBDA234C105 for ; Tue, 29 Apr 2008 08:13:56 -0700 (PDT) Message-ID: <660456167.1209482036382.JavaMail.jira@brutus> Date: Tue, 29 Apr 2008 08:13:56 -0700 (PDT) From: "Golgoth 14 (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Issue Comment Edited: (DERBY-3650) Derby + Hibernate JPA 3.2.1 problem on entity with Blob/Clob In-Reply-To: <196200967.1209454556080.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593036#action_12593036 ] golgoth14 edited comment on DERBY-3650 at 4/29/08 8:12 AM: ------------------------------------------------------------ I've attached a test case. You should modify the value of the variable "childrenCout" into the method "insertData". If the value is about 10, the error not appear. If the value is about 100 or 1000, the exception describe below is thrown. was (Author: golgoth14): The test case > Derby + Hibernate JPA 3.2.1 problem on entity with Blob/Clob > ------------------------------------------------------------ > > Key: DERBY-3650 > URL: https://issues.apache.org/jira/browse/DERBY-3650 > Project: Derby > Issue Type: Bug > Components: Network Client > Affects Versions: 10.4.1.3 > Environment: Mac OSX 10.4 > JDK 1.5.0_13 > Hibernate EntityManager 3.2.1 > Reporter: Golgoth 14 > Attachments: DerbyHibernateTest.zip > > > Hi, > I'm using Derby in Client - Server mode with Hibernate JPA EJB 3.0. > When a query on an entity containing a Clob and some joins on other entites is executed, an exception with the following message is thrown: > XJ073: The data in this BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be committed, or its connection is closed. > This problem occurs when the property "hibernate.max_fetch_depth" is greater than 0. > When hibernate.max_fetch_depth=0, the query works. > If Derby is configured in embedded mode, the query works independently of the value of hibernate.max_fetch_depth. > On the Hibernate's documentation, the advised value of hibernate.max_fetch_depth is 3. > Could you explain me if I made something wrong ? > Thank you. > Stephane -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.