Return-Path: 
 <derby-user-return-2280-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 88904 invoked from network); 18 Oct 2005 14:56:51 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 18 Oct 2005 14:56:51 -0000
Received: (qmail 8522 invoked by uid 500); 18 Oct 2005 14:56:50 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 8502 invoked by uid 500); 18 Oct 2005 14:56:49 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 8491 invoked by uid 99); 18 Oct 2005 14:56:49 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Oct 2005 07:56:49 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of dremesh@gmail.com designates
 66.249.82.205 as permitted sender)
Received: from [66.249.82.205] (HELO xproxy.gmail.com) (66.249.82.205)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Oct 2005 07:56:50 -0700
Received: by xproxy.gmail.com with SMTP id t6so436885wxc
        for <derby-user@db.apache.org>; Tue, 18 Oct 2005 07:56:28 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=RWabAj7OQ+z0HHZK0ppI6w3nUiRNPVTWrcHba2R7jAS22Odj3DhDYu3yDLp7dzzBv4Z2vKxW9StxCbhGMpUZInEvSYFZP9dDMiU4LjXCDZsLe637pCCgh1ODSVckDFwhqjd7/SAQbk6cv4uMJsN8syrvXb1zICPeeWeYm0trb8U=
Received: by 10.70.34.1 with SMTP id h1mr2822281wxh;
        Tue, 18 Oct 2005 07:56:28 -0700 (PDT)
Received: by 10.70.132.17 with HTTP; Tue, 18 Oct 2005 07:56:28 -0700 (PDT)
Message-ID: <58ed70f50510180756t51a377cbg5bbb7a400e4611ad@mail.gmail.com>
Date: Tue, 18 Oct 2005 07:56:28 -0700
From: Deepa Remesh <dremesh@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: JDBC URL for NetworkServer
In-Reply-To: <43550310.2000801@cymulacrum.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <43550310.2000801@cymulacrum.net>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

On 10/18/05, Chong Yu Meng <chongym@cymulacrum.net> wrote:
> Hi all,
>
> I'm experimenting with Derby's NetworkServer deployment option and I
> came upon something that I'm not sure is unusual or not. I am using the
> ij tool to interface with Derby and I found that if I use the following
> syntax to conect to Derby and create a database:
> ij> connect 'jdbc:derby:someDB;create=3Dtrue';
>
> I get a "no suitable driver" error message.

This URL will not work with Network server but it will work with Derby
embedded driver.

The syntax of the URL that is required to access the Network Server
with network client driver is:
jdbc:derby://<server>[:<port>]/<databaseName>[;<URL attribute>=3D<value> [;=
...]]

>
> However, if I use this syntax:
> ij> connect 'jdbc:derby://localhost:1527/someDB;create=3Dtrue';
>
> I get a successful connection and the database gets created. Is this how
> Derby works?

This URL has the right syntax to connect to Network Server using
network client driver.

> There's probably something huge that I have missed
> somewhere. Can anyone give me a link to information either in the
> documentation or website that explains which URLs are to be used when?
>

For embedded driver URLs, you may refer to Section 'Database
connection examples' in Derby Developer's Guide at
http://db.apache.org/derby/docs/10.1/devguide/derbydev.pdf. For
Network Server URLs, you may refer to Section 'Accessing the Network
Server by using the network client driver' in Derby Server and
Administration Guide at
http://db.apache.org/derby/docs/10.1/adminguide/derbyadmin.pdf.

I hope this helps.

Deepa