Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 95184 invoked from network); 18 Aug 2007 03:30:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Aug 2007 03:30:32 -0000 Received: (qmail 49899 invoked by uid 500); 18 Aug 2007 03:30:28 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 49873 invoked by uid 500); 18 Aug 2007 03:30:28 -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 49862 invoked by uid 99); 18 Aug 2007 03:30:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Aug 2007 20:30:28 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.2 as permitted sender) Received: from [80.91.229.2] (HELO ciao.gmane.org) (80.91.229.2) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Aug 2007 03:30:49 +0000 Received: from root by ciao.gmane.org with local (Exim 4.43) id 1IMF0k-0008C1-7W for derby-user@db.apache.org; Sat, 18 Aug 2007 05:30:02 +0200 Received: from c-24-98-113-116.hsd1.ga.comcast.net ([24.98.113.116]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 18 Aug 2007 05:30:02 +0200 Received: from arthur.blake by c-24-98-113-116.hsd1.ga.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 18 Aug 2007 05:30:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Arthur Blake Subject: SQLTransientConnectionException with BLOB reads Date: Fri, 17 Aug 2007 23:27:15 -0400 Lines: 34 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: c-24-98-113-116.hsd1.ga.comcast.net User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) Sender: news X-Virus-Checked: Checked by ClamAV on apache.org Hello, I have been using Apache Derby 10.2.2.0 for a few months, and it has been working quite well for me. I upgrade to 10.3.1.4 just after the release came out, and I have been testing it out with my application. It seems to work fine, except when I read some BLOB fields from the database, this Exception is thrown: java.sql.SQLTransientConnectionException: No current connection. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source) at org.apache.derby.impl.jdbc.EmbedBlob.checkValidity(Unknown Source) at org.apache.derby.impl.jdbc.EmbedBlob.getBytes(Unknown Source) ...... If I downgrade back to 10.2.2.0, these Exceptions go away. Note, in each test, I completely recreate the DB from scratch. That is, the DB I'm testing on 10.2.2.0 was generated with the 10.2.2.0 Derby distribution and the DB I'm testing on 10.3.1.4 was generated with the 10.3.1.4 distribution, but everything else (non-Derby-wise) is equal, including the data that is stored in the DB. Any ideas? Thank You Arthur Blake