Probelm in connection pool

[anil anil]

I Configured connection pool in websphere . i has given datasource name test/anil.
Hashtable parms = new Hashtable();
parms.put Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
parms.put(javax.naming.Context.PROVIDER_URL, "iiop://websphere");
Context ctx = new InitialContext(parms);

DataSource ds = (DataSource)ctx.lookup("test/anil");
conn = ds.getConnection();
When i try to access the .jsp page it is giving error in websphere is
[03.08.13 10:10:41:786 GMT+05:30] 5932293d WebGroup X Servlet Error: : java.lang.NullPointerException
at Common.TestConnection_jsp_31._jspService(TestConnection_jsp_31.java:126)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:139)

plz give me the solution how to proceeds the next. what r all changes r requried to run properly

[David O'Meara]

"anil anil",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
With respect to your question, which line is throwing the exception? I think your JNDI connection information is suspect, try this instead:

//make a connection to the default JNDI server
Context ctx = new InitialContext(); 
DataSource ds = (DataSource)ctx.lookup("test/anil");
conn = ds.getConnection();

Dave

[Lakshmi Kishore]

try this, its working for me in WAS4,
Hashtable env = new Hashtable();
env.put( Context.INITIAL_CONTEXT_FACTORY , "com.ibm.websphere.naming.WsnInitialContextFactory");
javax.sql.DataSource ds =(javax.sql.DataSource)javax.rmi.PortableRemoteObject.narrow((new InitialContext()).lookup("DataSourceName"),javax.sql.DataSource.c
lass);
java.sql.Connection con = ds.getConnection();
java.sql.Statement stmt = con.createStatement();
java.sql.ResultSet rs = stmt.executeQuery("select * from tab");