db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: Creating DB with Derby Net Server
Date Wed, 02 Mar 2005 17:58:49 GMT
I find the fact that you have to ";" terminate the URL a bit confusing as 
well. i.e. it isn't just for separating attributes.

Jon

----- Original Message ----- 
From: "Jonathan Eric Miller" <jemiller@uchicago.edu>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Wednesday, March 02, 2005 11:56 AM
Subject: Re: Creating DB with Derby Net Server


> Yeah, the create=true has to go on the other side of the ":". Confusingly, 
> there are two different sets of attributes/properties. If I remember 
> correctly, one for Derby and one for the driver.
>
> Jon
>
> ----- Original Message ----- 
> From: "Mamta Satoor" <msatoor@gmail.com>
> To: "Derby Discussion" <derby-user@db.apache.org>; <rstrong@panix.com>
> Sent: Wednesday, March 02, 2005 11:30 AM
> Subject: Re: Creating DB with Derby Net Server
>
>
>> Hi Rick,
>>
>> If you goto
>> http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgId=1871157
>> you will find good information on how database and server properties
>> get set on the url. From a quick look at your code, I think the jdbc
>> url is incorrect, and it should look like following
>> jdbc:derby:net://localhost:1527/demoDB;create=true:user=usr;password=pwd;retrieveMessagesFromServerOnGetMessage=true;
>>
>> Mamta
>>
>>
>>
>> On Wed, 02 Mar 2005 10:41:24 -0500, Rick Strong <rstrong@panix.com> 
>> wrote:
>>> 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
>>>
>>>
>>
> 


Mime
View raw message