making connection pool in Glassfish v3

[Sherif Shehab]

hi,
I;m trying to make MSSQL connection pool in Glassfish v3, and i got this exception

 javax.servlet.ServletException: No object bound to name java:comp/env/myJDBCResourceName

i reviewed this, post but still getting the same exception

here are my configurations :

pool name : test2
JDBC Resource---> jndi name:jdbc/myJDBCResourceName and associated with test2

here is my code :

public void init() throws ServletException
	{
		// TODO Auto-generated method stub

		Context env = null;
		try
		{
			env = (Context) new InitialContext().lookup("java:comp/env");
			pool = (DataSource) env.lookup("jdbc/myJDBCResourceName");
			if (pool == null)
			{
				throw new ServletException("'unknown DataSource");
			}
		}
		catch (NamingException ne)
		{
			throw new ServletException(ne.getMessage());
		}
	}


protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		try
		{

			
			Connection con = pool.getConnection();
	
			Statement st = con.createStatement();

			ResultSet rs = st.executeQuery("select menuid from ivrlog where datelog>='20120205' ;");

			System.out.println("excuting the query");
			while (rs.next())
			{
				System.out.println(rs.getString(0));
			}
		}
		catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (InstantiationException e)
		{
			System.out.println("instantiantion prblem");
			e.printStackTrace();
		}
		catch (IllegalAccessException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (ClassNotFoundException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
}

and this is the part of WEB.xml

 <resource-ref> 
  <res-ref-name>sherifPool</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
  <res-sharing-scope>Shareable</res-sharing-scope>
  </resource-ref>

and i added this part in sun-web.xml

<resource-ref>
    <res-ref-name>sherifPool</res-ref-name>
    <jndi-name>jdbc/myJDBCResourceName</jndi-name>
  </resource-ref>

anything i'm missing ??

[Sherif Shehab]

Guys , any solution?