Troubleshooting data access problems

Data access problems
WebSphere® Application Server diagnostic tools provide services to help troubleshoot database connection problems. Additionally, the IBM® website provides flexible searching capabilities for finding documented solutions to database-specific connection problems.
JDBC trace configuration
If your application displays JDBC-related exception messages, activate the JDBC trace service. The resulting log text can help you identify the problem.
Troubleshooting long running JDBC transactions
There are two DataSource MBean operations that are useful for investigation of long running JDBC transactions.