Maybe your transactions are too long... or take many records and need to be
commited.

2010/8/17 Alessio <alexpaol@...>

>
>
> 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@... <ricardouven%40cantv.net>
> >
> To: "firebird-support" <firebird-support@yahoogroups.com<firebird-support%40yahoogroups.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@... <alexpaol%40tin.it>>
> >
> >>
> >>
> >> 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
> >
> >
> >
>
>
>

--
Ricardo...


[Non-text portions of this message have been removed]