The connection to the database is done in the init() method and i call the init() method in the ejbCreate() method of this bean.
Following code is written in the init() method for connection:
DataSource ds = (DataSource) procInitial.lookup("jndiLookup");
con = ds.getConnection("userid","password");
But while calling the JSP, the j2ee console stops with the doInitBody() and connection fails.