Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 11061 invoked from network); 25 May 2008 18:48:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 May 2008 18:48:19 -0000 Received: (qmail 73733 invoked by uid 500); 25 May 2008 18:48:20 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 73709 invoked by uid 500); 25 May 2008 18:48:20 -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 73698 invoked by uid 99); 25 May 2008 18:48:20 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 May 2008 11:48:20 -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; Sun, 25 May 2008 18:47:34 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id CA9DB234C122 for ; Sun, 25 May 2008 11:47:55 -0700 (PDT) Message-ID: <1557163984.1211741275828.JavaMail.jira@brutus> Date: Sun, 25 May 2008 11:47:55 -0700 (PDT) From: "Kristian Waagan (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (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=12599705#action_12599705 ] Kristian Waagan commented on DERBY-3650: ---------------------------------------- This issue is still on my radar, but I find it had to start working on a fix... Does anyone have more information that could be used to determine where the fix should be made? Does the store support having two streams serving the same data in a single row? (i.e. select myblob as stream1, myblob as stream2) My next step would be to work through one of the repros attached and see if there are any obvious poins of incorrect behavior. Since I have some other issues in the pipeline, I do not know when I can get around to do this. > 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.3.3.0, 10.4.1.3 > Environment: Mac OSX 10.4 > JDK 1.5.0_13 > Hibernate EntityManager 3.2.1 > Reporter: Golgoth 14 > Attachments: derby-3650_tests_diff.txt, Derby3650EmbeddedRepro.java, Derby3650FullClientRepro.java, Derby3650FullRepro.java, Derby3650Repro.java, DerbyHibernateTest.zip, testdb.zip, traces_on_FormatIdStream_alloc.txt, UnionAll.java > > > 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.