Don't manage the driver yourself. Let Tomcat do it. Just get the
DataSource by lookup from the Context.

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of famia2003
Sent: Wednesday, July 13, 2005 12:03 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Pool Exhausted

I always get an error that says "Cannot get a connection pool exhausted"
after 10-20 queries have been done. I need to restart the server inorder
to make any more queries.

I'm making a website using JSP, IBEasy as my database, Firebird as the
database server and Jakarta Tomcat as my web server.

These are the drivers and connections I use:

Connection con = null;
Class.forName("org.apache.commons.dbcp.PoolingDriver");
Class.forName("org.firebirdsql.jdbc.FBDriver");
con=DriverManager.getConnection("jdbc:apache:commons:dbcp:/scoutcon");

I'm new to using databse thru Java and I don't have learned knowledge in
this(my co-worker just gave me a few layout his boss made and told me to
follow it), so I don't know much about these erros (and my co-worker
says he doesn't know too).

Any help is greatly appreciated.

Thanks







Yahoo! Groups Links