How to Test and Validate JDBC Connections to the Database

Highlights:

Cloning, Patching or AutoConfig SRs often come in with a failed JDBC connection. Here is a way to isolate the E-Business suite and test a simple JDBC connection to the database.

Reviewed the following:

• JDBC connections to the database are used to establish a Java based "channel" to the database.
  
• Typically used to load, seed or execute large objects such as Java Classes or Large Binary Objects
• SQL and PL/SQL is used to seed or execute packages, or query views and tables. Typical object types.
  
• SQL connections and JDBC connections work in conjunction with each other, but are not related.