File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes how to create a connection pool? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "how to create a connection pool?" Watch "how to create a connection pool?" New topic

how to create a connection pool?

niroshan iranga

Joined: Apr 28, 2004
Posts: 19
In a jsp i want to connect to oracle data base using the connection pool how can i do that?
need a complte code
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63844

"niroshan niroshan",
We're really glad that you are here with us in the JSP forum, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
JSP Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63844

No one here is going to give you "a complte code". You need to either: search using google to find a package that someone has already written, try to write your own (in which case people here will fall all over themselves to help you when you run into trouble), or use container-managed pooling if your servlet container supports it (as Tomcat does).
Harry Wood

Joined: Jan 28, 2004
Posts: 16
DB connection pooling JSPs/servlets
Surfing the internet on the topic of database connection pooling left me a little bit confused, because there are two different approaches. There is a whole chapter in the O'reilly book "Java Server Pages" which clarifies this nicely (get it from

Here's a sumary:
You can either use a JDBC 2 DataSource object, which means the webserver manages the connections, or you can have a java class which manages connections. JDBC 2 Datasource approach should be your first choice. It involves putting a <resource> tag somewhere in your web server configuration. This is web server specific, and is not supported by all web-servers. I am having to use the static class approach. I am using DbConnectionBroker from There's a different one from here here: Either way you should construct the manager/broker class in your servlet/JSP init method.
For the connection itself, you should always get --> use --> release a connection for every request (i.e. in the 'doPost' method). Don't get a connection in the init method, and Dont keep a connection as a session variable, or in a bean. It might seem like a good idea, but it isn't.
I agree. Here's the link:
subject: how to create a connection pool?
It's not a secret anymore!