aspose file tools*
The moose likes Servlets and the fly likes JDBC connections in servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "JDBC connections in servlets" Watch "JDBC connections in servlets" New topic
Author

JDBC connections in servlets

Chris Brat
Ranch Hand

Joined: May 22, 2003
Posts: 108
Hi,
I am trying to write a web-app using servlets (using "Java Servlets Developer's guide" by Karl Moss as a reference).
I have created my connection pool, established a connection, logged myself and moved on into my app.
My question deals with the creating and closing of the connections... In the example in the book the application is a one servlet class app (a login screen) and the connection, statment and resultset are created on doGet(), information is shown and then the these objects are all closed.
If I move past the login screen in my application, should i close the connection and then re-open it?!? seems like overkill - or can i assign my jdbc connection to the session?
What is the correct way to handle a connection between multiple screens. Think Im going to do some more reading, but any advice is appreciated.
Thanks,
Chris


SCJP 1.2, SCJP 5, SCBCD
Chris Brat
Ranch Hand

Joined: May 22, 2003
Posts: 108
think i just found my own answer ... using a connection pool.
is it still correct to close the connection each time I leave a page tho ?!?
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
Chris,
The subject of connecting to databases is one of great importance due to connections be so time consuming. Most application servers and containers come with in built facility for connection pooling. For example, I use Tomcat which has a JNDI Datasource.
What you might want to do is to have a Database class that takes care of the connection to the database and then use this whereever required.
HTH


The secret to creativity is knowing how to hide your sources.
Gayathri Prasad
Ranch Hand

Joined: Jun 25, 2003
Posts: 116
Hi,
It is always a good practice to do the DB connectivity in the init() of servlet and by using the servlet instance pooling which many servlet containers and app servers support you need not worry abt the DB connectivity pooilng separately.
Cheers,
Gaya3
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8898

is it still correct to close the connection each time I leave a page tho ?!?


Yes, you have to close the connection after finishing using it so that it is available to others.


Groovy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC connections in servlets
 
Similar Threads
WAS "minimum pool size" > true pool size
garbage collection and statement closing question
JDBC Usage in OC4J
DataSource Connection is not taking connection from the connection pool - new connection is created
How to change user credentials when accessing DB