From user-return-7004-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Sat Jul 14 15:44:47 2007 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 87235 invoked from network); 14 Jul 2007 15:44:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Jul 2007 15:44:36 -0000 Received: (qmail 28987 invoked by uid 500); 14 Jul 2007 15:44:36 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 28948 invoked by uid 500); 14 Jul 2007 15:44:36 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 28937 invoked by uid 99); 14 Jul 2007 15:44:36 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Jul 2007 08:44:36 -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 (herse.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Jul 2007 08:44:33 -0700 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I9jn2-0004eM-D9 for user@geronimo.apache.org; Sat, 14 Jul 2007 08:44:12 -0700 Message-ID: <11594848.post@talk.nabble.com> Date: Sat, 14 Jul 2007 08:44:12 -0700 (PDT) From: Glen Mazza To: user@geronimo.apache.org Subject: Re: Derby DB in Geronimo In-Reply-To: <0E0419A6-5F09-4A85-8E36-0BFB9CFB322E@yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: glen.mazza@gmail.com References: <11562877.post@talk.nabble.com> <6DF98CC5-524B-48F4-9E2A-243A7E7310AF@yahoo.com> <11585231.post@talk.nabble.com> <0E0419A6-5F09-4A85-8E36-0BFB9CFB322E@yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org >Last I heard (several years ago) derby didn't support read only >databases -- it needed somewhere to write locks or something like >that. Can derby work from a resource url? Actually, I don't care if the DB is read-only or not; after initial loading I don't plan on adding more rows or updating them (whether or not the DB enforces that is not important to me). >> To test this, I tried to log into my sample Derby database I >> created in >> Geronimo (located in geronimo/var/derby/mydbname) from ij -- it >> failed when >> Geronimo was running, but worked after I shut down Geronimo. I did >> this >> last year with Derby standalone and documented it: >> >> [1] http://www.jroller.com/page/gmazza? >> entry=apache_derby_in_network_server >well, from this gbean in system-database: > class="org.apache.geronimo.derby.DerbyNetworkGBean"> > DerbySystemreference> > localhost > 1527 > >and the success of a bunch of tck tests that use app client access to >the derby instance running in the server, I'm pretty sure that the >network connector is turned on and working. Maybe the host=localhost >rather than 0.0.0.0 or a specific interface is the problem? What >connect string did you use for ij? Yes, thankfully I stand corrected here--Geronimo's Derby *does* run in network server mode and hence databases managed by it can be accessed externally. (From ij, I was trying to connect using the embedded URL format--such as connect 'jdbc:derby://usr/myapps/geronimo/var/derby/testdb'--instead of the Network URL format, which was my problem) Anyway, I created a Sandbox page with my observations, in case this helps other Derby users: http://cwiki.apache.org/GMOxSBOX/using-derby-with-geronimo.html Thanks again, Glen -- View this message in context: http://www.nabble.com/Derby-DB-in-Geronimo-tf4068958s134.html#a11594848 Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.