This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Struts and the fly likes Connection Pooling Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Connection Pooling Problem" Watch "Connection Pooling Problem" New topic

Connection Pooling Problem

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1043
Our application runs under WebLogic and Oracle.

The problem we ran into was creating "Manager" classes from a Struts action class (a Singleton). The actual problem was that our connection count kept increasing even though we closed the connections. We could see the connection
count climbing (in the Weblogic monitor) with each DAO access.

It seems that after the first action class did its thing with the database and then the next action class created some classes (DAOs), connections weren't being closed property. The code explicitly calls close on the connection, the result set and the statement.

Once we moved the instantiation of the manager classes to an EJB (and out of an action class), the problem went away. No more connection pooling issues.

Is an action class, therefore, a bad place to create objects which have connections the database via, say, connection pooling?

Thanks in advance for any comments.

Chris Boldon
Ranch Hand

Joined: Aug 10, 2006
Posts: 190
Your view should never directly create or access a database connection.
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1043
Hi Chris,

I guess my posting wasn't clear.

We're creating database connections in a J2EE application the correct way with DAO and related classes. We're also using connection pooling.

I agree. Here's the link:
subject: Connection Pooling Problem
Similar Threads
Connection pooling with my own cofiguration file instead of Initial Context.
interesting question on conncection pooling
Pleaes Help: Structs and Connection Pooling...
Connection Pool Problem in weblogic 9.2 MP3
Invalid state, the Statement object is closed.