How to get a connection from the connection pool in a servlet

chaitanya karthikk

Ranch Hand

Posts: 806

I like...

posted 8 years ago

Hi everybody, I am stuck in middle of an application. I am using connection pooling to connect to the database.

This is the context.xml file under META-INF which is responsible to maintain the connection pool.

Now I want to use a connection from this pool in a servlet. How can I do this.

Thank you all in advance.

Love all, trust a few, do wrong to none.

chaitanya karthikk

Ranch Hand

Posts: 806

I like...

posted 8 years ago

Using a jsp I am retrieving the data,

but I have to shift this into a MVC architecture. To do so, I need the connection in the servlet. How can I get a connection from the pool in a servlet?

Love all, trust a few, do wrong to none.

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 8 years ago

It will be something like this...

BTW, this code was taken directly from the Tomcat docs.

chaitanya karthikk

Ranch Hand

Posts: 806

I like...

posted 8 years ago

Gregg Bolinger wrote:It will be something like this...

InitialContext cxt = new InitialContext(); if ( cxt == null ) { throw new Exception("Uh oh -- no context!"); } DataSource ds = (DataSource) cxt.lookup( "java:/comp/env/jdbc/TestDB" ); if ( ds == null ) { throw new Exception("Data source not found!"); }

BTW, this code was taken directly from the Tomcat docs.

Thanks Gregg, for the quick reply, can you help me more? How can I get the connection object from DataSource and can you please explain what is

Thank you in advance.

Love all, trust a few, do wrong to none.

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 8 years ago

I tried to be subtle with my hint to the Tomcat docs. Here is something more obvious. These are easily answered with some simple Google searches and looking at the API. Please try to find some information before asking very common questions.

http://java.sun.com/javase/6/docs/api/javax/sql/DataSource.html

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 8 years ago

This is also not JSP related so moving...

chaitanya karthikk

Ranch Hand

Posts: 806

I like...

posted 8 years ago

Its okay Gregg, thank you.