The Basics of Building an Application

Regardless of the language you use to build an application, you follow the same guidelines to build an application that takes advantage of the high-performance features of a JSON database:

  • Connect through an Oracle client. When you connect to the database through an Oracle client, almost all connection-management operations are performed by the client, permitting you to concentrate on the business logic of your application. Depending on your programming language, you use the Oracle Database JDBC Driver or the Oracle Instant Client.

  • Use connection pools. When you code your application to use connection pools instead of creating and destroying connections individually, you gain performance improvements. How you code to use connection pools depends on your programming language.

  • Connect to the appropriate database service. Autonomous JSON Database provides several database services to use when connecting to your database. These database connection services are designed to support different kinds of database operations, as described in Database Service Names for Autonomous Transaction Processing and Autonomous JSON Database in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

Also regardless of the language you use to build an application, you perform the same basic tasks to configure your system to support application development:

  1. Download and install the basic software to develop in the given language. For example, you download and install JDK to develop Java applications.

  2. Download and install any extension library or module necessary to permit applications in the given language to connect to an Oracle Database and make SQL calls. For example, you download and install the cx_Oracle extension module to develop Python applications.

  3. Download and install the Oracle client appropriate for the given language and extension library or module.

  4. Download the client credentials for the database and make them available to Oracle client you installed.