Hi,
I am using websphere 5 to connect to my DB2 server. I have not installed DB2 client in the system, where i am having websphere.
I am using the following code to connect to DB2 server using Version 5 data Source, which i created thru' admin console.
Context context = null;
DataSource datasource = null;
String JNDI_NAME = null;
String providerURL = "iiop://localhost:2809/";
try {
//get the JNDI name from property file
JNDI_NAME = conrad.getJndiName();
Hashtable ht = new Hashtable();
//add all constants to separte file
ht.put(Context.INITIAL_CONTEXT_FACTORY, initialContextFactory);
ht.put(Context.PROVIDER_URL, providerURL);
context = new InitialContext(ht);
JNDI_NAME=conrad.getJndiName();
//JNDI_NAME="jdbc/ConRad";
System.out.println("Context Details..................");
System.out.println(context.getClass());
datasource = (DataSource) context.lookup("jdbc/conrad");
System.out.println("Datasource Details**************");
System.out.println("Ds "+datasource);
System.out.println(datasource.getConnection().getM etaData().getUserName());
It is showing me this error
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R javax.servlet.ServletException: SQLConnect
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:143)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.metlife.us.ins.conrad.integration.ControllerSe rvlet.doPost(ControllerServlet.java:105)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
[11/15/05 22:02:00:130 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:343)
[11/15/05 22:02:00:146 GMT+05:30] cf1aedb SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:592)
Do i need to have DB2 client installed in the PC where i am having websphere?
Please help me in resolving this.
Please mail your replies to my id
vijayakumar_o_a@yahoo.com.
Thanks,
Vijay
Websphere DB2
