× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. November 2004

Error with a Session bean calling an RPG Stored Procedure

I have a stored procedure that was created by someone who knows much
more than I do and I get the following error when I try to run it on my
machine using a WAS 5.0 Test Server.  I know this works because it has
worked on a machine outside of my company here.  The AS400 is local here
and I think I have my Server configured correctly.  I've updated my WSAD
5.1.2 with all the interim fixes through Fix 005 and that didn't seem to
help. Does anybody have any ideas?  Thanks,

 

Eric Bennion

Help Desk / Programmer

 

 

[11/18/04 15:55:22:675 MST] 2b7e44db FreePool      E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation
of the ManagedConnection for resource jdbc/artco, 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.<init>(DataSto
reAdapterException.java:244)

      at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataSto
reAdapterException.java:171)

      at
com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(Adapter
Util.java:191)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigu
rationHelper.java:694)

      at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSo
urce.java:440)

      at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedCon
nection(WSManagedConnectionFactoryImpl.java:566)

      at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(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.ja
va:658)

      at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

      at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

      at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

      at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

      at $Proxy1.validate(Unknown Source)

      at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

      at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

      at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

      at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

      at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

      at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

      at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

      at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

      at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

      at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.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)

---- Begin backtrace for nested exception

java.sql.SQLException: The application requester cannot establish the
connection.(Connection refused: connect)

      at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:480)

      at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnecti
on.java:2742)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:482)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:417)

      at
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.getPooledConnecti
on(AS400JDBCConnectionPoolDataSource.java:227)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.j
ava:676)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigu
rationHelper.java:671)

      at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSo
urce.java:440)

      at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedCon
nection(WSManagedConnectionFactoryImpl.java:566)

      at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(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.ja
va:658)

      at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

      at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

      at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

      at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

      at $Proxy1.validate(Unknown Source)

      at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

      at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

      at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

      at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

      at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

      at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

      at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

      at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

      at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

      at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.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)

Next Linked Exception:

java.sql.SQLException: The application requester cannot establish the
connection.(Connection refused: connect)

      at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:480)

      at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnecti
on.java:2742)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:482)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:417)

      at
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.getPooledConnecti
on(AS400JDBCConnectionPoolDataSource.java:227)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.j
ava:676)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigu
rationHelper.java:671)

      at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSo
urce.java:440)

      at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedCon
nection(WSManagedConnectionFactoryImpl.java:566)

      at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(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.ja
va:658)

      at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

      at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

      at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

      at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

      at $Proxy1.validate(Unknown Source)

      at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

      at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

      at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

      at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

      at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

      at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

      at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

      at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

      at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

      at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.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)

 

[11/18/04 15:55:22:738 MST] 2b7e44db ConnectionMan E J2CA0020E: The
Connection Pool Manager could not allocate a Managed Connection:
javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get
a PooledConnection from the DataSource.

      at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(FreePool.java:1282)

      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.ja
va:658)

      at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

      at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

      at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

      at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

      at $Proxy1.validate(Unknown Source)

      at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

      at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

      at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

      at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

      at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

      at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

      at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

      at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

      at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

      at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.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)

---- Begin backtrace for Nested Throwables

java.sql.SQLException: The application requester cannot establish the
connection.(Connection refused: connect)

      at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:480)

      at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnecti
on.java:2742)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:482)

      at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:417)

      at
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.getPooledConnecti
on(AS400JDBCConnectionPoolDataSource.java:227)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.j
ava:676)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigu
rationHelper.java:671)

      at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSo
urce.java:440)

      at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedCon
nection(WSManagedConnectionFactoryImpl.java:566)

      at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(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.ja
va:658)

      at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

      at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

      at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

      at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

      at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

      at java.security.AccessController.doPrivileged(Native Method)

      at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

      at $Proxy1.validate(Unknown Source)

      at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

      at java.lang.reflect.Method.invoke(Native Method)

      at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

      at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

      at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

      at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

      at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

      at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

      at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

      at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

      at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

      at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

      at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

      at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

      at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

      at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.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)

.

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R
java.sql.SQLException: The application requester cannot establish the
connection.(Connection refused: connect)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:480)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnecti
on.java:2742)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:482)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSour
ce.java:417)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.getPooledConnecti
on(AS400JDBCConnectionPoolDataSource.java:227)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.j
ava:676)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
java.security.AccessController.doPrivileged(Native Method)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigu
rationHelper.java:671)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSo
urce.java:440)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedCon
nection(WSManagedConnectionFactoryImpl.java:566)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrappe
r(FreePool.java:1244)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.
java:1030)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.ja
va:658)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.j
ava:446)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:215)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSourc
e.java:190)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.wgeb.address.AddressValidatorBean.getConnection(AddressValidatorBean
.java:121)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.wgeb.address.AddressValidatorBean.validate(AddressValidatorBean.java
:66)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.wgeb.address.EJSRemoteStatelessAddressValidator_f62b30e4.validate(EJ
SRemoteStatelessAddressValidator_f62b30e4.java:49)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
java.lang.reflect.Method.invoke(Native Method)

[11/18/04 15:55:22:785 MST] 2b7e44db SystemErr     R at
com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
java.security.AccessController.doPrivileged(Native Method)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
$Proxy1.validate(Unknown Source)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.wgeb.address._AddressValidator_Stub.validate(_AddressValidator_Stub.
java:296)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
java.lang.reflect.Method.invoke(Native Method)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodMo
del.java:68)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
610)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431)

[11/18/04 15:55:22:800 MST] 2b7e44db SystemErr     R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.