From derby-dev-return-46597-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Jul 13 01:58:27 2007 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 54282 invoked from network); 13 Jul 2007 01:58:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Jul 2007 01:58:27 -0000 Received: (qmail 55601 invoked by uid 500); 13 Jul 2007 01:58:28 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 55561 invoked by uid 500); 13 Jul 2007 01:58:28 -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 55551 invoked by uid 99); 13 Jul 2007 01:58:28 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jul 2007 18:58:28 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jul 2007 18:58:25 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id DEA0371420D for ; Thu, 12 Jul 2007 18:58:04 -0700 (PDT) Message-ID: <32222170.1184291884907.JavaMail.jira@brutus> Date: Thu, 12 Jul 2007 18:58:04 -0700 (PDT) From: "Kathey Marsden (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-2892) Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks In-Reply-To: <28283072.1183475946233.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2892?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512336 ]=20 Kathey Marsden commented on DERBY-2892: --------------------------------------- Thanks so much Bryan for your help. Well, I think I know what the problem is. It comes straight from the getBi= naryStream javadoc and I assume getCharacterStream works the same way. Note: All the data in the returned stream must be read prior to getting the= value of any other column. The next call to a getter method implicitly clo= ses the stream. Also, a stream may return 0 when the method InputStream.ava= ilable is called whether there is data available or not. Since we are doing the getInt() after the getCharacterStream(), it closes = the stream. So, my patch is no good. In order to use ResultSet.getCharact= erStream, ResultSet.getBinaryStream() I am going to have to defer opening t= he stream until it is ready to send. I'll see if that is possible. I thin= k it should be because we don't need to know if the stream is empty until t= hat time.=20 > Closing a resultset after retrieving a large > 32665 bytes value with Net= work Server does not release locks > -------------------------------------------------------------------------= ---------------------------------- > > Key: DERBY-2892 > URL: https://issues.apache.org/jira/browse/DERBY-2892 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.2.2.0, 10.3.1.1 > Environment: JDK: build 1.6.0_01-b06 (WinXP & Gentoo/SuSE) > Hardware: Intel x86 > Client/Server environment > Reporter: Thomas Niessen > Priority: Critical > Attachments: DERBY-2892_07_10_07_try1_diff.txt, DERBY-2892_07_10_= 07_try1_stat.txt, protocolErrorRepro.zip > > > This is the same issue as DERBY-255 (https://issues.apache.org/jira/brows= e/DERBY-255). The test attached to DERBY-255 shows the locks being not rele= ased. Everything is fine when using Derby 10.1.3.1 . > I would think it's a regression bug. > Output from sysinfo: > ------------------ Java-Informationen ------------------ > Java-Version: 1.6.0_01 > Java-Anbieter: Sun Microsystems Inc. > Java-Home: C:\work\applications\development\java\jdk1.6u1-SE\jre > Java-Klassenpfad: C:\work\applications\development\derby-10.2.2.0/lib/der= by.jar;C:\work\applications\development\derby- > 0.2.2.0/lib/derbynet.jar;C:\work\applications\development\derby-10.2.2.0/= lib/derbyclient.jar;C:\work\applications\devel > pment\derby-10.2.2.0/lib/derbytools.jar > Name des Betriebssystems: Windows XP > Architektur des Betriebssystems: x86 > Betriebssystemversion: 5.1 > Java-Benutzername: thomas.niessen > Java-Benutzerausgangsverzeichnis: C:\Dokumente und Einstellungen\thomas.n= iessen > Java-Benutzerverzeichnis: C:\work\applications\development\derby-10.2.2.0 > java.specification.name: Java Platform API Specification > java.specification.version: 1.6 > --------- Derby-Informationen -------- > JRE - JDBC: Java SE 6 - JDBC 4.0 > [C:\work\applications\development\derby-10.2.2.0\lib\derby.jar] 10.2.2.0 = - (485682) > [C:\work\applications\development\derby-10.2.2.0\lib\derbytools.jar] 10.2= .2.0 - (485682) > [C:\work\applications\development\derby-10.2.2.0\lib\derbynet.jar] 10.2.2= .0 - (485682) > [C:\work\applications\development\derby-10.2.2.0\lib\derbyclient.jar] 10.= 2.2.0 - (485682) > ------------------------------------------------------ > ----------------- Informationen zur L=C3=B5ndereinstellung --------------= --- > Aktuelle L=C3=B5ndereinstellung: [Deutsch/Deutschland [de_DE]] > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [cs] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [de_DE] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [es] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [fr] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [hu] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [it] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [ja_JP] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [ko_KR] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [pl] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [pt_BR] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [ru] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [zh_CN] > Version: 10.2.2.0 - (485682) > Es wurde Unterst=C2=B3tzung f=C2=B3r die folgende L=C3=B5ndereinstellung = gefunden: [zh_TW] > Version: 10.2.2.0 - (485682) --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.