Return-Path: Delivered-To: apmail-db-ojb-user-archive@www.apache.org Received: (qmail 773 invoked from network); 20 Jun 2005 09:41:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 20 Jun 2005 09:41:48 -0000 Received: (qmail 86136 invoked by uid 500); 20 Jun 2005 09:41:46 -0000 Delivered-To: apmail-db-ojb-user-archive@db.apache.org Received: (qmail 86111 invoked by uid 500); 20 Jun 2005 09:41:46 -0000 Mailing-List: contact ojb-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "OJB Users List" Reply-To: "OJB Users List" Delivered-To: mailing list ojb-user@db.apache.org Received: (qmail 86097 invoked by uid 99); 20 Jun 2005 09:41:45 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jun 2005 02:41:41 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [213.115.149.212] (HELO manta.curalia.se) (213.115.149.212) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jun 2005 02:41:33 -0700 Received: from manta.curalia.se (manta.curalia.se [213.115.149.212]) by manta.curalia.se (Postfix) with ESMTP id F17D9ABC032 for ; Mon, 20 Jun 2005 11:41:37 +0200 (CEST) Received: from [172.20.6.103] (raa-se.raa.se [193.10.40.128]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by manta.curalia.se (Postfix) with ESMTP id D8615ABC008 for ; Mon, 20 Jun 2005 11:41:37 +0200 (CEST) Message-ID: <42B68FC1.4060106@apache.org> Date: Mon, 20 Jun 2005 11:43:29 +0200 From: =?ISO-8859-1?Q?Martin_Kal=E9n?= Organization: ASF User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Users List Subject: Re: OJB 1.0.3 error reading Oracle LONG through reference References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AV-Checked: ClamAV using ClamSMTP X-Old-Spam-Check-By: apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Ravi Aramanethota wrote: > I am trying to upgrade our application from OJB 0.97 to OJB 1.0.3. > > When I try to read objects with database column type LONG in oracle I > get > > the exception "java.sql.SQLException: Stream has already been closed". > This happens only when this abject is retrieved as reference from > other objects. If the LONG values are retrieved in ojbConcreteClass, it > works fine. Oracle has some constraints with the order of columns read from a ResultSet if any columns are of type BLOB, CLOB, LONGVARBINARY (and more?). Do you have any such "large" columns in your object or the object referencing this one? You can try to use the ordering attribute of the repository.xml to make sure columns are read in the right order. If you still don't get it to work, use P6Spy to debug which SQL statements OJB sends to Oracle. If you find out through P6Spy that your particular setup causes OJB to select the same value column from the ResultSet more than once, you can update from CVS on branch OJB_1_0_RELEASE since Armin has recently fixed a problem related to this. Regards, Martin --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org For additional commands, e-mail: ojb-user-help@db.apache.org