Derby and offset

I have understood that in derby doesn't support offset in sql. However in hibernate with derby this is possible using Query.setFirstRow(int row). What it actually to do that?

Can derby split log files

Can derby split log files to several files after previous log file is too large like derby.log derby.log.1 derby.log.2 or is it possible to use log4j in derby? -Original Message- From: Daniel John Debrunner [mailto:[EMAIL PROTECTED] Sent: 24. lokakuuta 2007 20:02 To: Derby Discussion

RE: Command history in ij

One good sql client is henplus(http://www.java-source.net/open-source/sql-clients/henplus) which support also history. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20. heinäkuuta 2007 9:30 To: Derby Discussion Subject: Re: Command history in ij Jørgen

RE: Sum of time

Maybe easiest way is use big int type in duration field and store duration time in milliseconds -Original Message- From: Dmitri Pissarenko [mailto:[EMAIL PROTECTED] Sent: 17. heinäkuuta 2007 11:08 To: Derby Discussion Subject: Re: Sum of time Hello! On 7/17/07, Peter Ondruska [EMAIL

Re: How much derby need memory?

Thanks, this help a lot and answer was fast! On 2/28/07, Knut Anders Hatlen [EMAIL PROTECTED] wrote: Pertti Ylijukuri [EMAIL PROTECTED] writes: Hi! I'am using derby nework server. I have started deby with following properties: derby.storage.pageCacheSize = 2 derby.storage.pageSize

How much derby need memory?

Hi! I'am using derby nework server. I have started deby with following properties: derby.storage.pageCacheSize = 2 derby.storage.pageSize = 4096 -Xmx200408k I expect that derby need 2 * 4096k = 80M memories. Anyway sometimes derby throw java.lang.OutOfMemoryError Java heap space XJ001.