Standard JDBC diagnostics for Application Servers (Doc ID 467808.1)

Last updated on AUGUST 09, 2023

Applies to:

Goal

Retrieve diagnostic information about your JDBC/JDK environment used within a Java Enterprise container that is especially useful for Support Analysts. Includes: database version, JDBC driver version, JDK version, PATH, BOOTSTRAP, JRE Extensions directory, CLASSPATH and JDBC URL and debug flags information

This note is only meant for working in an application server environment. Refer to following note for retrieving the information in a Java standalone environment:
<Document 467804.1> How To Determine The Exact JDBC Driver Version For Standalone Programs.

The JSP in this note can only be used with Oracle JDBC drivers. For testing of non-Oracle JDBC drivers please refer to <Document 1264869.1> Sample JSP to get JDBC Information from a Generic ( non-Oracle) JDBC Driver in J2EE Environment.

This note was tested on Weblogic 14.1.1.0 running both on Linux and on Windows running both Java 8 and Java 11.

If you wish to verify your JDBC driver within OC4J 10.1.2.x or 10.1.3.x by deploying an EAR file, you can also use <Document 396187.1> EAR file to Determine JDBC Driver Version Used in OAS 10.1.3.

If you wish to verify your JDBC driver within WebLogic 10.3 by deploying an EAR file you can also use <Document 1160784.1> How to Verify the Oracle JDBC Driver Version for Oracle WebLogic 10.3.x.

Solution

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