db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Creating DB with Derby Net Server
Date Wed, 02 Mar 2005 18:29:33 GMT
Hopefully we can address all these idiosyncrasies once Derby Client that
was announced makes to Apache. I find this extremely confusing too.

Satheesh

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