Hi all,

I would like to connect remotely to the DB2 in linux machine using the JNDI lookup.

In websphere development 5.1, this portion of code is working in 5.1 env :

/////////////////////////////////////////////////////////////////////////
Context MyCtx = null;
DataSource MyDS = null;
Hashtable parms = new Hashtable();
Connection conn = null;

parms.put(Context.INITIAL_CONTEXT_FACTORY,
"com.ibm.websphere.naming.WsnInitialContextFac tory ");

MyCtx = new InitialContext(parms);
MyDS = (DataSource) MyCtx.lookup("jdbc/Employee");
conn = MyDS.getConnection();

/////////////////////////////////////////////////////////////////////////

But after i recompile in websphere rational 6.0 in windows XP env, the code is not working anymore. It said :

=> Cannot instanciate com.ibm.websphere.naming.WsnInitialContextFactory. .

I have imported the db2jcc.jar, db2jcc_license_cu.jar, can anyone giv me some clue what is happening? Thanks alot.

This is how to do it using SJSAS, I'm confident it will work with any server by supplying the correct URI and port numbers (and of course including the correct jars in your classpath):

This looks up EJB resources, but JDBC resources should be no different.

I've seen a lot of people trying what you did (and tried it myself just on the off chance it might work and to see why it didn't).
It's not only something that (generally) won't work (might work inside the container but don't count on it) but it's bad programming practice as it introduces a hard dependency on a specific appserver.