Re: Finding length of a result set

2006-02-01 Thread Bernt M. Johnsen
I apologize for this mail. At last I have learned (once again) to read the whole mail before I answr. At least Craig sent a decent replay. Thanks Craig. Sorry John. Bernt M. Johnsen wrote (2006-01-31 09:56:34): I would suggest you use the SQL COUNT() function (in the same transaction). E.g.

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread John Embretsen
Michael Segel wrote: I think that there are two issues. One how Derby handles itself and attempts to clean up stale objects. The second is that whoever wrote the test didn't know what they were doing. So that question is: Should Derby be smart enough to protect bad programmers from

RE: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread derby
-Original Message- From: John Embretsen [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 9:12 AM To: Derby Discussion Subject: Re: OutOfMemoryErrors when testing Derby with DOTS Michael Segel wrote: I think that there are two issues. One how Derby handles itself

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread John Embretsen
Craig L Russell wrote: If this test code is representative of the actual application, then the application is in trouble and should be reimplemented in the jdbc area. It is a very well-understood requirement of well-behaved applications that result sets and prepared statements and

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread Craig L Russell
On Feb 1, 2006, at 8:06 AM, John Embretsen wrote: Craig L Russell wrote: If this test code is representative of the actual application, then the application is in trouble and should be reimplemented in the jdbc area. It is a very well-understood requirement of well- behaved

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread John Embretsen
Craig L Russell wrote: [snip] Again, I want to say that I came into this discussion late, and was originally under the impression that you had an application that you were looking to optimize. I apologize if my comments took everyone off track. Yes, I was a bit worried that the length

Re: Specifying the Derby Database Location

2006-02-01 Thread Manjula G Kutty
Afkham Azeez wrote: Hi Folks, I have my derby.properties file in $MY_PROJECT/conf directory. This is the directory pointed to by the derby.system.home System property. But no my database is getting created under $MY_PROJECT/conf e.g. as $MY_PROJECT/conf/DATABASE. I need my database to be

Re: Specifying the Derby Database Location

2006-02-01 Thread Manjula Kutty
Correction : You can not set the derby.system.home in the derby.properties file.You should always explicitly set the value of derby.system.home Thanks Manjula On 2/1/06, Manjula G Kutty [EMAIL PROTECTED] wrote: Afkham Azeez wrote:Hi Folks,I have my derby.properties file in $MY_PROJECT/conf

Re: Specifying the Derby Database Location

2006-02-01 Thread Afkham Azeez
Hi Folks, Thanks for all the replies, Let me simplify my question: I need to have my database and derby.properties file under different directories, and the derby.system.home points to the directory which contains the derby.properties file. And I need to use the relative path of the DB since, the