How to configure JNDI step by step in NetBeans..

Software	Version Required
NetBeans IDE	Java bundle, 6.8 or 6.9
Java Development Kit (JDK)	version 6,7
GlassFish server	v3 or Open Source Edition 3.0.1
SQL Server	2005
Type 4 Driver for SQL Server 2005	sqljdbc

SQL Server 2005 Type 4 driver

•First Download the SQL Server 2005 Type 4 driver.

•Set the classpath

Database Create a database and table in SQL Server 2005

Create a new web Application

index.jsp code

<%-- 
Document   : index
Created on : Nov 21, 2012, 3:42:17 PM
Author     : NIIT
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JNDI DEMO</title>
</head>
<body bgcolor="pink">
<h1>Login Management System</h1>
<form action="NewServlet" method="post">
<table align="center">
<tr>
<td>User Name </td>
<td><input type="text" name="txtuser" ></td>
</tr>
<tr>
<td>Password </td>
<td><input type="password" name="txtpass" ></td>
</tr>
<tr>
<td><input type="submit" value="Login"></td>
</tr>
</table>
</form>
</body>
</html>

Configuration of JNDI

Now Check your Connection Poll is working or not?

Create a Servlet

Servlet Code

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
@WebServlet(name = "NewServlet1", urlPatterns = {"/NewServlet1"})
public class NewServlet1 extends HttpServlet {


Connection con;
ResultSet rs;
Statement st;
InitialContext ctx;
DataSource ds;

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {

String uname,pass;
uname=request.getParameter("txtuser");
pass=request.getParameter("txtpass");
String qry="select * from Login";

ctx = new InitialContext();
ds = (DataSource)ctx.lookup("jdbc/myDatasource");
con=ds.getConnection();
st = con.createStatement();
rs = st.executeQuery(qry);
rs.next();
if(uname.equals(rs.getString(1)) && pass.equals(rs.getString(2)))
{
out.println("Your User Name and Password is correct<br>");
out.println("Welcome Mr. "+ uname);

}
else
{
out.print("Invalid User Name & Password");

}
}
catch(SQLException ex)
{
out.println(ex.getMessage());
}
catch(NamingException nx)
{
out.println(nx.getMessage());
}
}