Mule ESB 3.4.4: Configure Oracle JDBC driver in Mule Developer Studio
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.
