Eclipse Community Forums: DTP » Connecting to Derby via Embedded Driver

Help

Home

Home » Eclipse Projects » DTP » Connecting to Derby via Embedded Driver

Show: Today's Messages :: Show Polls :: Message Navigator

Connecting to Derby via Embedded Driver [message #22692]

Tue, 07 November 2006 01:14

Eclipse User

Originally posted by: rhr2.psu.edu

I've just installed DTP on Windows XP and am experiencing problems setting
up the embedded driver and connection as recommended in the "Getting
Started with DTP" instructions. I modified the eclipse.ini file to set
the derby.system.home property to point to C:\DB as the derby system
directory. When I set up the driver with URL jdbc:derby:;create=true and
new database name SI_DB, then try to connect, I get a couple of "unable to
create database" errors and the derby.log shows the following:

ERROR XBM0J: Directory C:\DB\C:\DB already exists.

Any ideas? I've tried many other permutations for the URL including
specifying the full path jdbc:derby:C:\DB\SI_DB;create=true, specifying
just the database jdbc:derby:SI_DB;create=true, etc. - all with the same
result.

Report message to a moderator

Re: Connecting to Derby via Embedded Driver [message #22957 is a reply to message #22692]

Thu, 09 November 2006 01:46

Anil Samuel

Messages: 108
Registered: July 2009

Senior Member

I usually use the following as the jdbc url for the embedded db
jdbc:derby:/tmp/DerbyDB

and I use the same with ";create=true" optionwhen I connect using ij
from cmd line. This way the url is consistent when I use on a unix env.
as well.

Remember to create a /tmp directory on your current drive (E: in my case
with Win XP)

I didnot ever had to modify any sys variables; so I suggest get rid of
derby.system.home.

Anthos

bob rivoir wrote:
> I've just installed DTP on Windows XP and am experiencing problems
> setting up the embedded driver and connection as recommended in the
> "Getting Started with DTP" instructions. I modified the eclipse.ini
> file to set the derby.system.home property to point to C:\DB as the
> derby system directory. When I set up the driver with URL
> jdbc:derby:;create=true and new database name SI_DB, then try to
> connect, I get a couple of "unable to create database" errors and the
> derby.log shows the following:
> ERROR XBM0J: Directory C:\DB\C:\DB already exists.
>
> Any ideas? I've tried many other permutations for the URL including
> specifying the full path jdbc:derby:C:\DB\SI_DB;create=true, specifying
> just the database jdbc:derby:SI_DB;create=true, etc. - all with the same
> result.
>
>

Report message to a moderator