Oracle connection and WSAD 5.1
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   kp_k
Posted On:   Wednesday, February 18, 2004 02:34 AM

Hi, There was a post by Nguyen Dinh Cuong on Nov 8 about Datasource connection in WSAD(about jndi. Thread is http://www.jguru.com/forums/view.jsp?EID=1127175 ). I saw the replies and did as suggested by Sanjay. Still I am getting the following error. [2/18/04 15:34:33:156 IST] 4d82cc1d FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/MyDataSource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource. at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException. (DataStoreAdapterException.java:244) at com.ibm.ws.rsadapter.exception   More>>

Hi,
There was a post by Nguyen Dinh Cuong on Nov 8 about Datasource connection in WSAD(about jndi. Thread is http://www.jguru.com/forums/view.jsp?EID=1127175 ). I saw the replies and did as suggested by Sanjay. Still I am getting the following error.
[2/18/04 15:34:33:156 IST] 4d82cc1d FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/MyDataSource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException. (DataStoreAdapterException.java:244)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException. (DataStoreAdapterException.java:171)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:191)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:694)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
at DatabaseTestServlet.doPost(DatabaseTestServlet.java:45)
at DatabaseTestServlet.doGet(DatabaseTestServlet.java:22)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:948)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:530)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

Is this beacuse of some network problems because the Oracle server is in some other location and I have specified the IP address of the server in the URL. Can somebody help me and tell me if I have missed out on something.

Thanks in advance,
KP

   <<Less

Re: Oracle connection and WSAD 5.1

Posted By:   Thang_PHAN  
Posted On:   Saturday, March 13, 2004 05:41 PM

In the modify data source set up on the app server,make sure you have both component and container managed aliased to "localhost/abcUser" and this alias is programmed in JAAS set up.

In the resource properties, you only need the url in the format (jdbc:oracle:thin:@xyzServer:1521:F" where 1521 can be a different port, F is the default Oracle ID (your may be different).

An one last thing, make use you have download jdbc driver classes12.zip from Oracle and it is in your classpath.

Hope this helps.
About | Sitemap | Contact