Two applications use the db, the first one has (max) 10 threads, each thread
has his own
connection, the second one use only one connection.

No more than 11 concurrent connections.

I'm working on closing all statements manually, then i will try to make the
application
running for 24h in production.

May be the problem is related on batchAdd (JDBC) ? Each thread push around
1000/1500
SQL MERGE command in the batch queue.

This is a porting from PostgreSQL, where applications work fine.

----- Original Message -----
From: "Ricardo Uzcategui" <ricardouven@...>
To: "firebird-support" <firebird-support@yahoogroups.com>
Sent: Tuesday, August 17, 2010 4:57 PM
Subject: Re: [firebird-support] Too many handles to database


> Maybe many users currenty connected and no enough memory to answer that
> request?..
>
>
>
> 2010/8/17 Alessio <alexpaol@...>
>
>>
>>
>> Hello everyone,
>>
>> I'm using Firebird 2.1 on Linux (x86_64) for a Java application through
>> JDBC.
>>
>> During testing the application works fine, but when moved to production
>> (full load), i got many exceptions with the following message "Too many
>> handles to database". This happens after some our of computation, and
>> seems
>> to be completely random, so i'm unable to debug it.
>>
>> I googled for two days but i was not able to find nothing more than .h
>> file
>> with that message.
>>
>> Please help me finding a solution.
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>
>
>
> --
> Ricardo...
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>