Re: Class loading deadlock

On Tue, 2005-09-20 at 10:20 -0700, Daniel John Debrunner wrote: The changes Knut pointed out have been merged to 10.1. If you can build the 10.1 branch and try them out that would be great, otherwise you could wait for a snapshot and try that out. Daniel, the version on the 10.1 branch

Re: derby.drda.startNetworkServer property

[EMAIL PROTECTED] writes: Hi Knut, Thanks for your quick response. Then, how can I verify whether Derby, started using derby.drda.startNetworkServer=true and org.apache.derby.jdbc.EmbeddedDriver, is ready or not to accept clients like NetworkServerControl#ping() ? Haven't tested, but I

Re: derby performance and 'order by'

Rick Hillegas wrote: It might help to add another column to the index so that it covers both the restriction and the ordering information. And if we could add a primary key to a temporary table, then something like the following might take us in the right direction: create index time_index

embeddedServer vs NetworkServer: any differences in terms of provileges

hi, I used to spawn a networkserver that I access through JDBC. I have to change my design to a Embedded Server. I have now a PriviledgeActionException (on client side) when opening socket to the server do you have any clue? -- Xavier VIGOUROUX - sun microsystems

Re: embeddedServer vs NetworkServer: any differences in terms of provileges

XV == Xavier Vigouroux [EMAIL PROTECTED] writes: XV hi, XV I used to spawn a networkserver that I access through JDBC. XV I have to change my design to a Embedded Server. XV I have now a PriviledgeActionException (on client side) when opening XV socket to the server XV

Re: derby performance and 'order by'

SAD == Suavi Ali Demir [EMAIL PROTECTED] writes: SAD Another little detail about optimization is that SAD Statement.setMaxRows() kind of functions on the JDBC side may SAD not be sufficient since it is called after SQL statement is SAD prepared and returned as an object (after

Re: derby performance and 'order by'

I agree with Øystein, given that the standard JDBC api for the maximum rows is Statement.setMaxRows then Derby should be able to take advantage of that regardless of when it is set. This doesn't imply that a plan gets reprepared, though that could be a solution, it could be implemented as a plan

Re: derby performance and 'order by'

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 worth beefing up our

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

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 create a writable database from a

derby wiki

The new derby wiki is here: http://wiki.apache.org/db-derby Please post questions/issues about the derby wiki to the derby list. I updated wiki.apache.org/general and wiki.apache.org/db to include the new derby wiki. On the db wiki I discovered a link to searchable db archives:

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

Hi Michael, I'm not sure I understand the problem you're wrestling with. Forgive me if I have garbled your message. It sounds as though you want to be able to create an empty database from a template database. This is pretty easy to do with Derby: 1) Nest another jar file inside your

Distributed databases

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 resource that shows me how to do