connecting to os/390 db2 from WAS on windows using java type 4 driver

[login to unmask email]

connecting to os/390 db2 from WAS on windows using java type 4 driver
I have a developer who is trying to establish this connection. She is using
the jcc driver. We have applied some ptf's , changed the zparms to desctat
yes and still are not able to make the connection. Has anyone here made
this connection or seen this error before?
The error messages are:


[1/12/06 12:52:30:734 EST] 7059cefd FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation of
the ManagedConnection for resource jdbc/Con2, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
PooledConnection from the DataSource.



Bud Greenman
Applications Programming Manager

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bart Mertens

Re: connecting to os/390 db2 from WAS on windows using java type 4 driver
(in response to BudGreenman@ONGOV.NET)
Bud,

Did you check the datasource definition in WebSphere is correct? It
looks like there are not enough available connections in de datasource.

Bart

-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
[login to unmask email]
Verzonden: donderdag 12 januari 2006 19:23
Aan: [login to unmask email]
Onderwerp: [DB2-L] connecting to os/390 db2 from WAS on windows using
java type 4 driver

I have a developer who is trying to establish this connection. She is
using the jcc driver. We have applied some ptf's , changed the zparms to
desctat yes and still are not able to make the connection. Has anyone
here made this connection or seen this error before?
The error messages are:


[1/12/06 12:52:30:734 EST] 7059cefd FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation
of the ManagedConnection for resource jdbc/Con2, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
PooledConnection from the DataSource.



Bud Greenman
Applications Programming Manager

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: connecting to os/390 db2 from WAS on windows using java type 4 driver
(in response to Bart Mertens)
Thanks Bart. I had her check that out & she will try creating a new
datasource to see if that corrects it.

Bud Greenman
Applications Programming Manager



"Mertens, Bart"
<[login to unmask email]
NL> To
Sent by: DB2 Data [login to unmask email]
Base Discussion cc
List
<[login to unmask email] Subject
ORG> Re: [DB2-L] connecting to os/390
db2 from WAS on windows using java
type 4 driver
01/13/2006 05:20
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






Bud,

Did you check the datasource definition in WebSphere is correct? It
looks like there are not enough available connections in de datasource.

Bart

-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
[login to unmask email]
Verzonden: donderdag 12 januari 2006 19:23
Aan: [login to unmask email]
Onderwerp: [DB2-L] connecting to os/390 db2 from WAS on windows using
java type 4 driver

I have a developer who is trying to establish this connection. She is
using the jcc driver. We have applied some ptf's , changed the zparms to
desctat yes and still are not able to make the connection. Has anyone
here made this connection or seen this error before?
The error messages are:


[1/12/06 12:52:30:734 EST] 7059cefd FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation
of the ManagedConnection for resource jdbc/Con2, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
PooledConnection from the DataSource.



Bud Greenman
Applications Programming Manager

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: connecting to os/390 db2 from WAS on windows using java type 4 driver
(in response to BudGreenman@ONGOV.NET)
Thanks Bart. I had her check that out & she will try creating a new
datasource to see if that corrects it.

Bud Greenman
Applications Programming Manager



"Mertens, Bart"
<[login to unmask email]
NL> To
Sent by: DB2 Data [login to unmask email]
Base Discussion cc
List
<[login to unmask email] Subject
ORG> Re: [DB2-L] connecting to os/390
db2 from WAS on windows using java
type 4 driver
01/13/2006 05:20
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






Bud,

Did you check the datasource definition in WebSphere is correct? It
looks like there are not enough available connections in de datasource.

Bart

-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
[login to unmask email]
Verzonden: donderdag 12 januari 2006 19:23
Aan: [login to unmask email]
Onderwerp: [DB2-L] connecting to os/390 db2 from WAS on windows using
java type 4 driver

I have a developer who is trying to establish this connection. She is
using the jcc driver. We have applied some ptf's , changed the zparms to
desctat yes and still are not able to make the connection. Has anyone
here made this connection or seen this error before?
The error messages are:


[1/12/06 12:52:30:734 EST] 7059cefd FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation
of the ManagedConnection for resource jdbc/Con2, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
PooledConnection from the DataSource.



Bud Greenman
Applications Programming Manager

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm