Well, it's tricky to do symbolic links since Derby creates the tables within a directory. I guess what you could do is create the tables, shut down Derby, move the table(s) to a different disk device, create a soft link, and start Derby up again. Hey, that might work! (ever the optimist)

David

Michael Segel wrote:
On Thursday 26 January 2006 3:19 pm, Rajesh Kartha wrote:

Only the database logs can be put on a separate device using the
'logDevice' attribute

http://db.apache.org/derby/docs/10.1/adminguide/cadminlog98.html

Please refer the Derby Admin Guide for more information on this.

-Rajesh


Well....

If you wanted to do something down and dirty, you could always have a couple of different instances running and then connect to the correct instance to write the table out and have each instance point to a different directory.
(But that's a lot of headache and its going to be a nightmare to maintain.)

I guess there may be one other option, that might work.

Has anyone tried doing either symbolic links or hard links? How will Derby handle this? In theory, it should work....


On 1/26/06, David W. Van Couvering <[EMAIL PROTECTED]> wrote:

My understanding is this is not possible right now with Derby.

David

Melvin Zamora wrote:

Hi Derbies,

Would it be possible to have the PK tables on hardisk-A and FK tables
on hardisk-B using only one database?

to envision:

CUSTOMER_DERBY_DB

CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B]

-Melvin

-----------------------------------------------------------------------
-

Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.
<http://us.rd.yahoo.com/mail_us/taglines/mailstorage/*http://mail.yahoo
.com/


begin:vcard
fn:David W Van Couvering
n:Van Couvering;David W
org:Sun Microsystems, Inc.;Database Technology Group
email;internet:[EMAIL PROTECTED]
title:Senior Staff Software Engineer
tel;work:510-550-6819
tel;cell:510-684-7281
x-mozilla-html:TRUE
version:2.1
end:vcard

Reply via email to