db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Strong <rstr...@panix.com>
Subject Re: Creating DB with Derby Net Server
Date Wed, 02 Mar 2005 18:05:04 GMT
Thanks all - as you've all noticed my problem was a simple syntax mixup. 
Much appreciated. I've been working with Cloudscape for many years, but 
in embedded mode only until recently.

Rick

Jonathan Eric Miller wrote:

> 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