Links may not function; however, this content may be relevant to outdated versions of the product.
Troubleshooting: Embedded SQL Server driver (WebSphere 6.0.1)
Symptom
The WebSphere Application Server 6.0.1 embedded MSSQL Server JDBC driver has a transaction bug that may cause connections to remain open exhausting a WAS datasource connection pool.
Solution
To avoid this problem, upgrade to WAS fixpack 6.0.2 or higher.
This is a known issue with WAS 6.0.1 and 6.0.0.3. See the following IBM articles for additional detail on the issue:
javax.transaction.xa.XAException: [DataDirect][SQLServer JDBC Driver]There is Uncommitted local transaction work