Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

2 EARs Sharing 1 Data Source

 
Elle Atechsy
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34672
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic