Standard JDBC diagnostics for Application Servers (Doc ID 467808.1)

Last updated on APRIL 05, 2017

Applies to:

JDBC - Version 9.0.1.0 and later
Information in this document applies to any platform.


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.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms