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.*

Explain what should be done when a SQL exception is raised?

0 Answers  

---

why are using type4 driver in realtime projects?

4 Answers  

---

What are different types of JDBC Drivers?

0 Answers  

---

Explain the life cycle of jdbc.

0 Answers  

---

How a driver can be loaded?

1 Answers  

---

Explain the difference between rowset vs. Resultset in jdbc?

0 Answers  

---

Can we make a database connection from HTML ?

6 Answers   Aptech, BOB Technologies, Cap Gemini, Wipro,

---

How do I connect to jdbc?

0 Answers  

---

In JDBC, All the API?s are interfaces? Where is the actual implementation?

3 Answers   HCL,

---

How the JDBC application works?

0 Answers  

---

How do I set properties for a JDBC driver and where are the properties stored?

0 Answers  

---

What is a jdbc url?

0 Answers  

---