Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how do we get the connection from connection pool



how do we get the connection from connection pool..

Answer / paletipatisrinu

import java.io.*;
import java.sql.*;
inport javax.sql.*;
import javax,servlet.http.*;
public class connection extends HttpServlet
{
public void service(HttpServletRequest
req,HttpServletResponse res)throws ServletException,IOException
{
Connection con=makeConnectionPool();
Statement st =con.createStatement();

----------reqular code as like as jdbc--------









}
public void Connection makeConnectionPool()
{
Connection con=null;
try
{
InitialContext ic =new InitialContext();
DataSource ds =(DataSource)ic.lookUp(" jndi logical Name in
Application server");
con=ds.getcConnection();
}catch(Exception e)
{
e.printStackTrace();
}
return con;
}



Note:-First u create logical name of jndi in application
server and refer this api javax.sql.*

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More JDBC Interview Questions

What is the difference between ojdbc6 and ojdbc7?

0 Answers  


Explain in detail about JDBC and its general features?

0 Answers  


How do I check in my code whether a maximum limit of database connections have been reached?

0 Answers  


Why do we use jdbc?

0 Answers  


What is the difference between triggers and procedures?

1 Answers  


What driver should I use for scalable Oracle JDBC applications?

0 Answers  


Diff. types of triggers..

4 Answers   Logica CMG,


How can I write to the log used by DriverManager and JDBC drivers?

0 Answers  


What is JDBC?

3 Answers   Akamai Technologies,


What is url in jdbc connection?

0 Answers  


How to execute bulk number of queries at once?

3 Answers   Wipro,


What is difference between java.util.Date and java.sql.Date?

0 Answers  


Categories