My Oracle Support Banner

WebLogic Server (WLS) Support Pattern: Investigating JDBC Issues (Doc ID 1280894.1)

Last updated on JANUARY 01, 2021

Applies to:

JDBC - Version 10.1.0.4 and later
Oracle WebLogic Server - Version 10.3.6 to 10.3.6
Information in this document applies to any platform.

Purpose

Problem Description

We conventionally refer to as JDBC issues all problems involving database-related application code, Weblogic Datasource/Pooling, drivers, DBMS and network.

Problem Troubleshooting

This pattern provides troubleshooting tips and is aimed at educating on how to narrow down where JDBC problems lie. Understanding the issue is key to understand how to debug and resolve it. The following topics will be covered in this document.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Problem Description
 Problem Troubleshooting
Troubleshooting Steps
 JDBC Datasource/Pooling Issues
 ResourceException during JDBCDataSource.getConnection() (weblogic.common.ResourceException: No resources available)
 Bad performance of the RDBMS or the network, so that connection requests to the underlying database lead to very long startup times for the WebLogic Server
 Connection refresh/reconnect problems after the database was down
 Database Issues
 Too Many Open Cursors in the Oracle database
 getVendorConnection()is called and physical connection is automatically refreshed after each usage by the application (when RemoveInfectedConnections="true")
 WebLogic Server Issues
 WebLogic Server Crashes because of native JDBC driver libraries
 WebLogic Server or application hangs in JDBC driver methods or functions
 A memory leak of JDBC objects leads to an OutOfMemoryError or growing process size
 General Topics
 Troubleshooting JDBC problems by debugging or tracing JDBC
 How to tune JDBC connection pools for production environments?
 WebLogic Server and Oracle RAC/TAF
 Known Issues
 Need further help?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.