• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WSAD DataSource Connection Exception

 
Rammohan Bandakunta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having a problem configuring the DataSource using WSAD ,

please,let me know from the following Exception what could be done

R java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at java.sql.DriverManager.getConnection(DriverManager.java:538)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at java.sql.DriverManager.getConnection(DriverManager.java:210)
[10/23/05 21:09:38:797 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrToolDAO.openConnection(MicrToolDAO.java:28)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrToolDAO.insertUserAccData(MicrToolDAO.java:78)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrtoolwelcomeAction.execute(MicrtoolwelcomeAction.java:54)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)[10/23/05 21:09:39:047 EDT] 530b96cd SystemOut O accnum:HH::::55

[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R java.lang.NullPointerException
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrToolDAO.insertUserAccData(MicrToolDAO.java:80)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrtoolwelcomeAction.execute(MicrtoolwelcomeAction.java:54)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R java.lang.NullPointerException
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrToolDAO.insertUserAccData(MicrToolDAO.java:93)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.webapp.micrapp.MicrtoolwelcomeAction.execute(MicrtoolwelcomeAction.java:54)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)[10/23/05 21:09:39:047 EDT] 530b96cd SystemOut O targettttttttttcbform

[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[10/23/05 21:09:39:047 EDT] 530b96cd SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rammohan,
Can you connect to Oracle throught SQL Plus? This will narrow down if it a connection problem or a datasource problem.
 
Rammohan Bandakunta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne Boyarsky ,
I was away for awhile,

I am able to connect through SQL PLUS.

I need to know if the connection works proper through WSAD.

Let me know please..
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rammohan,
I am using Oracle through WSAD and it works fine. So the problem is something in the datasource configuration. Double check your driver, URL connection string, password, etc.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic