File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSF and the fly likes JSF Database Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » JSF
Bookmark "JSF Database Access" Watch "JSF Database Access" New topic

JSF Database Access

Josh Juneau
Ranch Hand

Joined: Jun 16, 2004
Posts: 86
I have written several JSF applications which implement database access now. However, I still feel that there must be a better way to manage database connections. Currently, my technique is to create a single serializable bean which every other bean within my application will extend. I put all of my "shared" methods and such within this bean including my database connection method. This seems to work fine, but it is causing multiple connections from a single user to occur each time the application is utilized.

Is there a better method of controlling database access within my JSF applications?

Database Administrator/Application Developer
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

The best way to handle database connections in any web application is using a Connection Pool.

GenRocket - Experts at Building Test Data
Josh Juneau
Ranch Hand

Joined: Jun 16, 2004
Posts: 86
Thanks for the response.

Yes, I agree that a connection pool is the best way to go. I am using an OracleConnectionPool Cache Manager to connect to my database. Still, even with the connection pool I am seeing multiple connections. I thought that the connection pool was supposed to alleviate this problem?

Thanks in advance for any suggestions...
I agree. Here's the link:
subject: JSF Database Access
It's not a secret anymore!