aspose file tools*
The moose likes JDBC and the fly likes Setting Location for database to be used by javadb Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Setting Location for database to be used by javadb" Watch "Setting Location for database to be used by javadb" New topic
Author

Setting Location for database to be used by javadb

Yaki Kumar
Greenhorn

Joined: Feb 01, 2010
Posts: 12

Hello,

I am stuck figuring out how to set directory location to be used by javadb. Below is the code I using to create database, a test table and few queries - it uses some other class too to find appropriate location of database.


I have used - Line Number 43-44.
But running this shows me the database directory as DBLocation: /home/vikesh/.logbook/db[/b], whereas it creates the database directory named db_log_data in the same directory from where I run this. Is there any other way I can specify location of database. What I am doing wrong?

Here is the output of above:

DBLocation: /home/vikesh/.logbook/db
Got A Connection: org.apache.derby.impl.jdbc.EmbedConnection40@26977856 (XID = 152), (SESSIONID = 1), (DATABASE = db_log_data), (DRDAID = null)
Got: 1, hmmmm


Thanks for helping.
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Hi,

read this: http://db.apache.org/derby/docs/10.8/ref/rrefproper32066.html
and note that derby.system.hom is a static property - if Derby is running, you must reboot it for changes to take effect.

But an easier method is just to set directory locaction in the connection URL, like this:

In this example, Derby will create dbmane subirectory in /home/korkodrilko/test/.

On windows you can use drive letter plus colon in the path, and probably (don't remember) both slashes and backshlashes:
Yaki Kumar
Greenhorn

Joined: Feb 01, 2010
Posts: 12

Thanks a lot, I got it sorted. It seems the problem in my case was that the directory supposed to contain db files was already present and not created by execution of following.
.
Once I did not have the particular directory in place before above code executed, it all got fine.

Thanks a lot!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Setting Location for database to be used by javadb