Getting DataSource from WAS - Cllient is outside the Container

[Anurag Gupta]

I am trying to get a database connection from a Java client application, which is outside the WAS container. i.e. a standalone java class.
A working DataSource is already configured in WAS 6, with connection pool [Security is NOT enabled].

A deployed servlet with the following code works fine:

  
 
InitialContext ic = new InitialContext ();
Objectl_obj =ic.lookup("jdbc/TestDB");
DataSource ds =(DataSource) l_obj;
Connection con = ds.getConnection();
// Creating PreparedStatement; Firing sqls; closing Statements and Connections

However if the java client outside the container, trys to get a connection from the same Connection pool, there is a error. (The difference is in getting the InitialContext only)

  
Hashtable env = new Hashtable(); 
env.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.websphere.naming.WsnInitialContextFactory"); 
 
env.put(Context.PROVIDER_URL, "corbaloc:iiop:localhost:2809");
 
InitialContext ic = new InitialContext (env);
Objectl_obj =ic.lookup("jdbc/TestDB");
DataSource ds =(DataSource) l_obj;   // Error thrown here.
Connection con = ds.getConnection();
// Creating PreparedStatement; Firing sqls; closing Statements and Connections

This code, throws a ClassCastException , because the l_obj returned is not of type DataSource, but of Resource type.

1) Does that mean, Webspher does not allow its own DataBase connection pool to be used outside the container ?
2) If it is allowed, then how do accomplish this, in a standlaone java client?

Thanks

[Shailesh Chandra]

As per my experience with websphere, We can not get the connection from datasource out of the container.

Shailesh