Re: Distributed databases

2005-09-22 Thread James A Craig/O/VCU
Thank you, I'll take a look at C-JDBC. I'm actually a little surprised how fast I got an answer to all my questions. Thank you to everyone. James-Rajesh Kartha <[EMAIL PROTECTED]> wrote: -To: Derby Discussion From: Rajesh Kartha <[EMAIL PROTECTED]>Date: 09/22/2005 11:24AMSubject: Re: Distri

Re: derby performance and 'order by'

2005-09-22 Thread Rick Hillegas
Thanks for the pointer to this presentation, Oyvind. It's a pretty startling observation though I'm not sure how to use it. I'd be interested in hearing your thoughts about this some time. Cheers, -Rick That reminds me of a very entertaining presentation which was held at VLDB this year:

Re: Distributed databases

2005-09-22 Thread Rajesh Kartha
James A Craig/O/VCU wrote: Hi, I'm fairly new to Derby but I was curious if its possible to use it in a distributed setup. I currently have a small cluster and want to set it up so that I have a distributed database on it using Derby. So my questions are: 1) Is this possible? 2) Is there a r

Re: Can you use createFrom to create a database from a backup database stored in a JAR file?

2005-09-22 Thread Daniel John Debrunner
Michael Vinca wrote: > Hello, > I wasn't sure if this was going to work or not. There was nothing in the > documentation to suggest it would, I was just hopeful. I tried searching > the archives for "createFrom" but only got one hit, so I hope this is > not a repeat question. > I am attempting to

Re: Distributed databases

2005-09-22 Thread Daniel John Debrunner
James A Craig/O/VCU wrote: > Thank you for the fast response. I was looking to set it up so that it > was a single database with table 1 on node 1, table 2 on node 2, etc. > But if I'm reading what you said correctly, this isn't possible. I was > reading a book that dealt with doing this and I want

Re: Distributed databases

2005-09-22 Thread Jean T. Anderson
Carlos A. Carnero Delgado wrote: Hi, if you will ultimately access your database using JDBC, you might want to check this: http://c-jdbc.objectweb.org/. I'm not sure if that fits the bill in your situation but you could waste 5 minutes reading the blurbs there ;) Emmanuel Cecchet wrote a "HOWT

Re: Distributed databases

2005-09-22 Thread Carlos A. Carnero Delgado
Hi, if you will ultimately access your database using JDBC, you might want to check this: http://c-jdbc.objectweb.org/. I'm not sure if that fits the bill in your situation but you could waste 5 minutes reading the blurbs there ;) Regards, Carlos.

Re: Distributed databases

2005-09-22 Thread James A Craig/O/VCU
Thank you for the fast response. I was looking to set it up so that it was a single database with table 1 on node 1, table 2 on node 2, etc. But if I'm reading what you said correctly, this isn't possible. I was reading a book that dealt with doing this and I wanted to try it out in practice (it di

Re: Distributed databases

2005-09-22 Thread Michael J. Segel
On Thursday 22 September 2005 04:07, Øystein Grøvlen wrote: > > "JAC" == James A Craig/O/VCU <[EMAIL PROTECTED]> writes: > > JAC> Hi, I'm fairly new to Derby but I was curious if its possible > JAC> to use it in a distributed setup. I currently have a small > JAC> cluster and want t

Locks not released on error

2005-09-22 Thread Lars Clausen
Hi! We're using Derby version 10.1 (Bundle-Version: 10.1.100.208786) embeddedly in our system. Even though I've put extensive rollback and statement closing handling in the code, we still occasionally see cases where a table gets permanently locked after an error during update (detail below).

Re: Distributed databases

2005-09-22 Thread John Embretsen
James A Craig/O/VCU wrote: 4) Does anyone know of any decent tutorials when it comes to Derby? I haven't found anything that great thus far. The recent Linux Magazine article referenced in a previous thread on this mailing list might function as a sort of general tutorial for (newbie) derby

Re: Distributed databases

2005-09-22 Thread Øystein Grøvlen
> "JAC" == James A Craig/O/VCU <[EMAIL PROTECTED]> writes: JAC> Hi, I'm fairly new to Derby but I was curious if its possible JAC> to use it in a distributed setup. I currently have a small JAC> cluster and want to set it up so that I have a distributed JAC> database on it usin

Re: derby performance and 'order by'

2005-09-22 Thread Oyvind . Bakksjo
Rick Hillegas wrote: Hi Oyvind, I agree that this is inelegant. As you note, this approach step by step forces a plan which the current Derby optimizer is capable of considering--with or without the covering index. Regardless of whether we teach the optimizer some better tricks, I think it's