Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (herse.apache.org: 32.97.182.146 is neither permitted
 nor denied by domain of Stan.Bradbury@gmail.com)
Message-ID: <4575E467.5020102@gmail.com>
Date: Tue, 05 Dec 2006 13:28:07 -0800
From: Stanley Bradbury <Stan.Bradbury@gmail.com>
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: XJ200 error
References: 
 <OF38D0D32F.023FCBC5-ONC125723B.002ED5B6-C125723B.002FE32A@abengoa.com>
In-Reply-To: 
 <OF38D0D32F.023FCBC5-ONC125723B.002ED5B6-C125723B.002FE32A@abengoa.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

jorge.martindelrio@telvent.abengoa.com wrote:
> Hi all,
>       after using Apache Derby some time i have the following error:
>
>       "Exceeded maximum number of sections 32K"
>   
=== SNIP ===
>
> This is the content of the derby.properties file:
>
> derby.connection.requireAuthentication=true
> derby.authentication.provider=BUILTIN
> derby.user.PEPE=pepito
> derby.drda.host=0.0.0.0
> derby.storage.pageSize=32768
> derby.storage.pageCacheSize=5000
>
>   
Hi -

It strikes me that you are using a large pageSize and pageCacheSize 
(potentially requiring 40 times the memory the default Derby 
configuration).  This could lead to resource limitations, it this case 
it appears to be 'sections' (don't know what they are).  The stack trace 
associated with the error will indicate the area in which the problem 
occurs.  Is it a derby class throwing this?  Does this problem happen 
when you are running with the default pageCacheSize?