| Connecting to Derby via Embedded Driver [message #22692] |
Mon, 06 November 2006 20: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.
|
|
|
| Re: Connecting to Derby via Embedded Driver [message #22957 is a reply to message #22692] |
Wed, 08 November 2006 20:46  |
| Eclipse User |
|
|
|
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.
>
>
|
|
|
| Re: Connecting to Derby via Embedded Driver [message #583001 is a reply to message #22692] |
Wed, 08 November 2006 20:46 |
| Eclipse User |
|
|
|
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.
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04339 seconds
Home