Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 94301 invoked from network); 29 Jan 2009 13:55:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Jan 2009 13:55:50 -0000 Received: (qmail 98365 invoked by uid 500); 29 Jan 2009 13:55:49 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 98343 invoked by uid 500); 29 Jan 2009 13:55:49 -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 98334 invoked by uid 99); 29 Jan 2009 13:55:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 05:55:49 -0800 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 13:55:39 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n0TDtI2x018928 for ; Thu, 29 Jan 2009 13:55:18 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0KE800401JUV5500@fe-emea-09.sun.com> (original mail from Martin.Walsh@Sun.COM) for derby-user@db.apache.org; Thu, 29 Jan 2009 13:55:18 +0000 (GMT) Received: from [217.46.220.81] (host217-46-220-81.in-addr.btopenworld.com [217.46.220.81]) by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0KE800G9YK05RC10@fe-emea-09.sun.com> for derby-user@db.apache.org; Thu, 29 Jan 2009 13:55:18 +0000 (GMT) Date: Thu, 29 Jan 2009 13:57:02 +0000 From: Martin Walsh Subject: Re: NPE from NoRowsResultSetImpl.close() In-reply-to: <4981A54A.9090908@Sun.COM> Sender: Martin.Walsh@Sun.COM To: Derby Discussion Message-id: <4981B5AE.9020302@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <21725256.post@talk.nabble.com> <4981A54A.9090908@Sun.COM> User-Agent: Thunderbird 2.0.0.17 (X11/20081104) X-Virus-Checked: Checked by ClamAV on apache.org Hi Kristian, > Can you specify the Derby version you used, and on which operating > system you saw the problem? Derby - 10.4.2.0 OS - Solaris snv103 J2SE 6 When creating a fresh DB and running the script it worked for me also. I was using a DB that was already there. But once I applied the following properties it starts to fail again. I am trying to identify which property is causing the issue now. -- Only use properties stored in the database. call syscs_util.syscs_set_database_property( 'derby.database.propertiesOnly', 'true'); -- Set access permissions. call syscs_util.syscs_set_database_property( 'derby.authentication.provider', 'BUILTIN'); call syscs_util.syscs_set_database_property( 'derby.connection.requireAuthentication', 'true'); call syscs_util.syscs_set_database_property( 'derby.database.fullAccessUsers', 'auth'); call syscs_util.syscs_set_database_property( 'derby.database.readOnlyAccessUsers', 'readonly'); -- Create the readonly user. call syscs_util.syscs_set_database_property( 'derby.user.readonly', 'readonly'); -- Drop the default schema. drop schema app restrict; -- Change the page size for the database. -- call syscs_util.syscs_set_database_property( -- 'derby.storage.pageSize', '4096'); -- Save query plans - only for development. call syscs_util.syscs_set_database_property( 'derby.language.logQueryPlan', 'true'); commit; Martin