My Oracle Support Banner

Primary Note for Oracle Containers for J2EE (OC4J) Data Source Connecting to Oracle Database (Doc ID 1146123.1)

Last updated on JUNE 30, 2021

Applies to:

Oracle Containers for J2EE - Version 9.0.4.0.1 to 10.1.3.5.0 [Release AS10g to AS10gR3]
Information in this document applies to any platform.

Purpose

This Primary Note answers the most frequently asked questions about Oracle Containers for J2EE's Data-Source

This note is intended for Oracle J2EE developers who use Oracle databases.

Questions and Answers

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
Questions and Answers
 Oracle Documentation
 Oracle Application Server Containers for J2EE Services Guide 9.0.4
 Oracle Application Server Containers for J2EE Services Guide 10g Release 2 (10.1.2) 
 Oracle Containers for J2EE Services Guide 10g (10.1.3.5.0)
 What is Data-Source?
 How to Create Data-Source
 Thin Driver
 OCI Driver
 Standalone OC4J
 How to Test Data-Source
 Troubleshooting Data-Sources
 Certification
 File Location
 What is Connection Pool?
 Useful Connection Pool Timeout Related Parameters
 Abandoned-connection-timeout
 Time-to-live-timeout
 Inactivity-timeout
 OAS 10.1.3x parameter for Checking the Validity of the obtained connection.
 Logging
 datasource.verbose=true
 jdbc.debug=true
 jdbc.connection.debug=true
 XA Support
 DataSource and RAC database
 Recomended Reading 
References

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