Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of johnemb@gmail.com designates
 74.125.82.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:reply-to:user-agent:mime-version:to:subject
         :references:in-reply-to:content-type:content-transfer-encoding;
        b=JNkLbTyGQYLZz1zK9oOZW+rGpDRdd7MFQyq12DjNukbJPCNo9BHXLszG3Z1DoPSgu3
         xUo+47dIF280ymPSfdqBRbJw7pwQjx9Z8WgtSPh3dmzPttdAp8SA1Z6kCTGKMfQhNWBk
         olSTSSoyUd+t/Kp7aRaughCiPOM82ksovk1kY=
Message-ID: <4D4A63EF.8040403@gmail.com>
Date: Thu, 03 Feb 2011 09:14:39 +0100
From: "John H. Embretsen" <johnemb@gmail.com>
Reply-To: derby-dev@db.apache.org
User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US;
 rv:1.9.1.9) Gecko/20100318 Lightning/1.0b1 Thunderbird/3.0.4
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: Retrieving value of derby.drda.host from currently running system
References: <9892EC6224DBC54598164D1F77721D754E6AC33F@IBIUSMBSB.ibi.com>
In-Reply-To: <9892EC6224DBC54598164D1F77721D754E6AC33F@IBIUSMBSB.ibi.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

On 02/02/11 20:38, Logan, Douglas wrote:
> Hello,
>
> I have the network client of Derby running as a service on a Windows
> machine. From another machine, I�d like to connect to a Derby database
> and query the value of �derby.drda.host� as is set within the
> derby.properties file.

[snip]

> Does anyone have an idea on how I can get this value?

You may want to check out Derby's JMX monitoring capabilities. The 
NetworkServerMBean has an attribute called "DrdaHost" that you can read 
in order to get the value of derby.drda.host that the server is 
currently using. (At least in theory, it has been a long time since I 
actually tried this).

See
http://db.apache.org/derby/javadoc/publishedapi/jdbc4/org/apache/derby/mbeans/drda/NetworkServerMBean.html#getDrdaHost%28%29

For more info on using JMX with Derby, see

http://wiki.apache.org/db-derby/DerbyJMX
http://wiki.apache.org/db-derby/DerbyJMXQuickStart
http://db.apache.org/derby/javadoc/publishedapi/jdbc4/


Hope it helps,

-- 
John