Interested to Buy Any Domain ? << Click Here >> for more details...
how do we get the connection from connection pool
- 1 Answers
- 4263 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 are the utilities of the callablestatement?
What are four types of JDBC driver?
How do I load a database driver with JDBC 4.0 / Java 6?
What does the jdbc databasemetadata interface?
What happens if connection is not closed in jdbc?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Explain how data flows from view to db and reverse
What port does jdbc use?
How to find that, a row is updated or not?
How to execute bulk number of queries at once?
Which package is used for jdbc application?
Explain the steps in writing a java program using jdbc?
Core Java 
