Tuesday, August 20, 2013

Mule ESB 3.4.4: Configure Oracle JDBC driver in Mule Developer Studio

Mule ESB 3.4.4: Configure  Oracle JDBC driver in Mule Developer Studio

JDBC driver is a software component enabling a Java application to interact with a database

To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database.

  • Right Click on Project Explorer
  • Right Click on Build Path
  • Right Click on Add External Archives


  • Choose the location of the Oracle JDBC driver. Press Open.

  • You can the driver in the Referenced Libraries .

Create a Data Source

  • 1.) Click on Global Elements; 2.) Click on Create; 3.) Click on Data Sources; 4.) Click on Oracle Data Sources;5.)Click on OK

  • 1.) Enter JDBC URL;2.) Enter user name; 3.)Enter password.

Create a connector

  • 1.) Click on Global Elements; 2.) Click on Create; 3.) Click on Connectors; 4.) Click on Database;5.)Click on OK

  • Choose the Data Source and Press OK.

No comments:

Post a Comment

SOA Cloud 12c GIT Repository

When a project is created, you can choose to initialize the project with one project Git repository for the project. A Maven repository is a...