Interested to Buy Any Domain ? << Click Here >> for more details...
how do we get the connection from connection pool
- 1 Answers
- 4350 Views
- I also Faced
- E-Mail Answers
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 |
What is meant by jdbc and odbc?
What are JDBC Best Practices?
What is connection commit?
What is DML?
What is the syntax of URL to get connection?
What are the types of jdbc drivers that exist?
Can we use the one instance of Statment to execute more than one query ?
What are the steps to connect to a database in java?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
What is dburl?
How do you insert images into database using jdbc?
How do I disallow NULL values in a table?
Core Java 
