Forums Register Login

how to create a connection pool?

+Pie Number of slices to send: Send
In a jsp i want to connect to oracle data base using the connection pool how can i do that?
need a complte code
+Pie Number of slices to send: Send
"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.
Thanks!
bear
JSP Forum Bartender
+Pie Number of slices to send: Send
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).
+Pie Number of slices to send: Send
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 safari.com)

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 www.javaexchange.com There's a different one from here here: http://www.webdevelopersjournal.com/columns/connection_pool.html 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'm still in control here. LOOK at this tiny ad!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1325 times.
Similar Threads
Connection Pool Refreshing
Configure Datasource with Tomcat
connection pooling in tomcat
enterprise application with many users
Is open/close hibernate session in every business logic a good design?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 00:01:10.