Answer Posted / 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.*

What are the different types of resultset?

952

---

How to set the attribute concurrency in resultset?

913

---

How do I disallow NULL values in a table?

970

---

Does jpa use jdbc?

904

---

How to connect multiple database in jdbc?

1056

---

Where is jdbc url mysql?

964

---

Can I use JDBC to execute non-standard features that my DBMS provides?

973

---

What do you mean by odbc?

1006

---

Explain creation of statement object with connection method create method with help of an example.

952

---

What is setautocommit in jdbc?

904

---

How to check jdbc driver version in websphere?

1072

---

What is data source in java?

937

---

What do you understand by jdbc datasource?

1006

---

What is dburl?

976

---

What is createstatement method in java?

944

---