Re: limit, offset and random

unludo wrote: OK thanks a lot for your answers. Regarding the 'ORDER BY RANDOM()', you also plan to have something similar? ORDER BY RANDOM() already works for me. Example: ij select i from t where i 5; I --- 1 2 3 4 4 rows selected ij select i from t where i 5 order by random();

Re: Statement/PreparedStatement performance difference and problem

Thanks Knut, I don't think this is the problem here as there has been no updates, the same happens if you create the db from scratch and run the program. Thanks anyway, I will look at the mechanism in play with the statistics. Cheers Knut Anders Hatlen wrote: DerbyNovice [EMAIL PROTECTED]

Re: Statement/PreparedStatement performance difference and problem

In the fresh db case, do you create your indexes before or after the data has been inserted? From you java repro I'm guessing indexes first, then inserts? If I'm not mistaken there's still a possibility for experiencing outdated statistics when done in this order (as inserts are updates to

Re: A network protocol error was encountered and the connection has been terminated

Sorry about that. I added something to dump follow getNextException() and getCause(). I got the following exception from getCause(), I believe. I don't think getNextException() returned anything. org.apache.derby.client.am.DisconnectException: A network protocol error was encountered and

Re: A network protocol error was encountered and the connection has been terminated

org.apache.derby.client.am.DisconnectException: A network protocol error was encountered These can be a bit complicated to diagnose, but there is a wealth of information about how to do so online at: http://wiki.apache.org/db-derby/ProtocolDebuggingTips Please try to pursue this problem and

load data from comma delimeted file into derby

I can’t manage to find the information that I used previously on how to load data from a comma delimited file into derby. Could someone either provide the code, or the link to the information on it. Thanks No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus

Re: load data from comma delimeted file into derby

Brandon Dohman wrote: I can’t manage to find the information that I used previously on how to load data from a comma delimited file into derby. Could someone either provide the code, or the link to the information on it. Thanks No virus found in this outgoing message. Checked by AVG.

RE: load data from comma delimeted file into derby

Exactly it! Thanks much Rick. B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 1:26 PM To: Derby Discussion Subject: Re: load data from comma delimeted file into derby Brandon Dohman wrote: I can’t manage to find the information

Bug #DERBY-3593

Hi, I found a bug that i`d described in jira, but no answer up tp now. Did i do something wrong in the bug post? I thought a little strange haven`t found this bug in jira when a posted it, because it`s simple to reproduce and someone should have found it before me. If someone could help me..