1. Always enclose your database access in try/catch/finalize blocks, and
free the connection in the finalize block. Feel free to release it as
soon as you're done with it, but ALWAYS have a close in the finalize.
2. Get a good book on J2EE patterns. Understand Model View Controller
(MVC).
3. NEVER do any database access in the View (JSP) and you shouldn't in
the Controller. Always in DAOs called from business logic components
called from the controller.
4. Good luck. It's a lot more development overhead than a scripting
language, but a lot more powerful.

-----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