Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of rstrong@panix.com designates
 166.84.1.72 as permitted sender)
Message-ID: <4225DEA4.3020508@panix.com>
Date: Wed, 02 Mar 2005 10:41:24 -0500
From: Rick Strong <rstrong@panix.com>
Reply-To: rstrong@panix.com
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Creating DB with Derby Net Server
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greetings,

I am having difficulty creating a database using the net server.
I start the server programmatically in a standalong pgm like this:

****************************************************
NetworkServerControl server = new 
NetworkServerControl(InetAddress.getByName("localhost"), port);
server.start(null);
****************************************************
In this case port == default: 1527; also, I have tried this using 
"0.0.0.0" as the host address, same results.

Then attempt to create and connect to a database:

****************************************************
jdbc:derby:net://localhost:1527/demoDB:user=usr;password=pwd;create=true;retrieveMessagesFromServerOnGetMessage=true;
****************************************************

but this fails with the following error message:

****************************************************
com.ibm.db2.jcc.c.DisconnectException: The application server rejected 
establishment of the connection.  An attempt was made to access a 
database, demoDB, which was not found.
****************************************************

I should mention that it works fine with an existing DB, and also works 
fine in embedded mode. Have I missed something RE: directives, security, 
etc?

Thanks,

Rick Strong