File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connections issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connections issue" Watch "Connections issue" New topic
Author

Connections issue

Miltos Tereres
Ranch Hand

Joined: Sep 04, 2009
Posts: 32
Hello...
I have some classes within my model...which do some tasks..
For connections i use apache connection pooling stuff....
My question is..




getblabla() and getall() is ok to get a new connection from the pool ? Is there a better way to just use one connection as long as the servlet is being executed?
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

As you're using DBCP, then getting and releasing connection object in each method is good and widely used technique.
Actually, what you need is good tutorial on DAO and DTO, for this, follow:
http://balusc.blogspot.com/2008/07/dao-tutorial-data-layer.html


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connections issue
 
Similar Threads
Connection Pooling
Running out of database connections using JSP
Control the Connections in the Connection Pool?
what is connection pooling?
Connection Pooling