db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Limit to number of active databases?
Date Fri, 03 Jun 2005 17:18:47 GMT
I also don't think there is a limit, but as Shreyas suggests you may
be running into some sort of resource limit in JVM/OS. On unix OS's
sometimes we run into open file limits, so you may be bumping into

Most of the resources allocated by derby are per database, which means
that for 100 databases there are 100 buffer caches, 100 logging systems,
100 statement caches, 100 background threads, ....   So architecture is 
not the best for your
app, but may work if you can figure out what resource you are running
into.  The error in derby.log for the failed connection may give a hint.

I have heard requests for support for concurrent 1000's of dbs, which
is interesting but definitely needs work to get there.

Do you have a maximum db limit in mind for you application?

Shreyas Kaushik wrote:
> I don't think there is any restriction as such. Try running your VM with 
> extra heap size and it should be fine. I was able to create 100 
> databases and connect to each of them.
> The default heap memory allocated by the VM may be insufficient for such 
> a high number of active databases.
> Hope this helps
> ~Shreyas
> Neal Dewing wrote:
>> Hi,
>> I have the following odd requirement...
>> I require opening a single connection to multiple databases concurrently.
>> The Derby embedded driver seems to fall out while attempting to open 
>> 75 - 85
>> different databases.
>> Is there any record of this limitation? What are my options?
>> Any help will be appreciated!
>> Kind Regards,
>> Neal

View raw message