Create Oracle DB Connection

Here we go!
Information that you need to know:

Database Connection is a configuration file where you define all the details of the Database. With a Database connection, you can read data from Database tables, perform SQL queries or insert records into Database tables.

Note: You can connect to any database for which you have connection details.

In this post, we will learn how create a Oracle Database Connection.

1.- We need to start the JDeveloper IDE.

2.- Click on File menu, then click on New option, followed immediately by Application option.

For Example:

3.- Then on the New Gallery window, choose Connections option in General Category, then choose Database Connection item.

For Example:

4.- Then on the Create Database Connection screen, choose Connections option in General Category, then choose Database Connection item.

For Example:

5.- Then we need to enter all the details of the Oracle Database.

Enter the following information:

Connection Name Your connection name, in this exercise we will leave the default value: Connection
Connection Type Oracle (JDBC)
Username Your username, in this exercise we will use the hr user
Password Your password, in this exercise we will use the hr password
Driver thin
Host Name Host name of the computer where Oracle Database 12c Release 1 (12.1) is installed
JDBC Port 1521
SID XE

Note: If the database is on the same computer, then for the Host Name parameter, enter localhost.

Click Test Connection. If the connection is successful, the word Success! is displayed in the Status field.

For Example:

Comments

Post a Comment

Popular posts from this blog

SOA 12c - Fault Handling (Creating Fault Policies and Fault Bindings)

Image
Here we go! Information that you need to know: Using Fault Handling in a BPEL Process. Fault handling allows a BPEL process service component to handle error messages or other exceptions returned by outside web services, and to generate error messages in response to business or runtime faults. For more detailed information read the following URLs: https://docs.oracle.com/cloud/latest/soa121300/SOASE/GUID-FE546F09-E9DF-4859-AEF6-A1C7A3F40C75.htm#SOASE478 Fault management framework is used to catch faults and perform user-specified actions defined in a fault policy file. In SOA Suite 12c we have a wizard to create fault policies and fault binding files. In this post, we will learn how to add a Fault Policy in an SOA project. We need to start the JDeveloper IDE. Click on File menu, then click on New option, followed immediately by Application option. For Example: Then on the New Gallery window, choose Applications option in General Category, then choose SOA Application ...
Read more

SOA 12c - FTP Adapter (List Files)

Image
Here we go! Information that you need to know: The Oracle FTP Adapter polls for files in a target directory and lists files from the target directory to specified FTP locations. The contents of the files are not read. This feature of the Oracle FTP Adapter lets you use an invoke activity to retrieve a list of files from a target directory. This list of files is returned as an XML document and contains information such as file name, directory name, file size, and last modified time. For listing files, you must select the List Files operation from the Operation Type page of the Adapter Configuration Wizard. In the File Directories page of the Adapter Configuration Wizard, you must specify information about the directory to use for reading file names for the list operation. You can choose to list files recursively within directories. The File Filtering page of the Adapter Configuration Wizard enables you to specify details of the files to retrieve or ignore. For more detailed in...
Read more

SOA 12c - DB Adapter (Perform an Operation on a Table)

Image
Here we go! Information that you need to know: Data manipulation language (DML) operations align with basic SQL INSERT , UPDATE , and SELECT operations. SQL INSERT , UPDATE , DELETE , and SELECT are all mapped to Web Service operations of the same name. The MERGE is either an INSERT or UPDATE , based on the results of an existence check. A distinction is made between the data manipulation operations—called outbound writes—and the SELECT operations—called outbound reads. The connection between the Web Service and the SQL for merge (the default for outbound write) and queryByExample are not as obvious as for basic SQL INSERT , UPDATE , and SELECT . For more detailed information read the following URL: https://docs.oracle.com/cd/E28280_01/integration.1111/e10231/adptr_db.htm#CHDFGBGD In this post, we will learn how create a SOA Project with Database Adapter - Operation Type: Perform an Operation on a Table The next images are the SOA Project execution: We are going...
Read more