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 (nike.apache.org: domain of bpendleton.derby@gmail.com
 designates 209.85.161.174 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=KfnUAtq5uAF6PN461nI8ShuU/dVVu5pOzbw1cP/IKgK1D37IpC8ZyqPETppYLVpiBo
         Vdb898zI67GEsAabJeu84uIvwuY78wTpwimWI/eOjLCItlL3BFGAKW2+R5WJBdsZZY+l
         YO1NH3fLx1MskurXFBF0UMcXASOjRr3Eescws=
Message-ID: <4D0192AF.9070907@gmail.com>
Date: Thu, 09 Dec 2010 18:38:39 -0800
From: Bryan Pendleton <bpendleton.derby@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Derby : No suitable driver found for jdbc:derby:db;create=true
References: <30335341.post@talk.nabble.com> <4CF436D4.7080101@gmail.com>
 <30339246.post@talk.nabble.com>
 <AANLkTi=SGPBfxYfxuDKR7wLWF8Obx+-h6PkQ=E3in250@mail.gmail.com>
 <30347946.post@talk.nabble.com> <4CF65ABC.7090803@gmail.com>
 <30352053.post@talk.nabble.com> <4CF6FDEF.7020201@gmail.com>
 <30359597.post@talk.nabble.com> <4CF7F7FC.8040707@oracle.com>
 <30366664.post@talk.nabble.com> <30398519.post@talk.nabble.com>
 <4CFEED9E.2080107@gmail.com> <30406849.post@talk.nabble.com>
 <4D007137.6040509@gmail.com> <30418078.post@talk.nabble.com>
In-Reply-To: <30418078.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> the problem now is that if I run login server with embeddeddriver, and
> client with clientdriver, once the client tries to connect to to the
> database it raises an error saying that "maybe another instance of derby is
> running the server".

The embedded driver uses a lock file to detect two copies of the driver
accidentally accessing the same database, so perhaps even though you think
you are using the client driver for your second connection, your code is
falling through into the embedded driver in both cases, and so both programs
are trying to access the database directly, which is not allowed.

> Reading the manuals, it seems that the server that uses the embeddeddriver
> can use the relative path to find the db, while the client can't and need to
> use //localhost:port/blahblah.. or am I wrong?

The "blahblah" part of the client connection URL can also be either a relative
or absolute database path name, just as is true with the EmbeddedDriver. So you
should be able to have your client URL be something like:

   jdbc:derby://localhost:1527//home/user/app/db

I can't remember for sure whether you need two slashes after the 1527 when you do this.

thanks,

bryan