2 EARs Sharing 1 Data Source

[Elle Atechsy]

Hi,

EAR file 1 opens connections when needed and then closes after done. While EAR file 1 may be running, EAR file 2 needs to connect to the same datasource. But it seems that EAR file 2 can never get a connection from the pool. Please see the following errors I get.

*****************
J2CA0045E: Connection not available while invoking method queueRequest for resource jdbc/InterfaceMonitor

J2CA0020E: The Connection Pool Manager could not allocate a Managed Connection: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException:
*****************

Can anyone tell me if 2 EAR files on the same application server, in WAS 5.1, can use the same datasource & connection pool at the same time? If so, what am I doing wrong?

Thanks,
Lulu

[Jeanne Boyarsky]

Lulu,
You can definitely have two EARs using the same data source at the same time. check the number of "max connections" for the datasource and make sure it isn't one.

You can check this by going to the WAS admin console and looking at the datasource (under resources.)