Oracle Datasource in Fuse ESB / Apache Karaf

Creating a Oracle data-source in Fuse ESB [Apache Karaf]

  1. Create a blueprint xml file as shown below –


<?xml version="1.0" encoding="UTF-8"?>
<blueprint xmlns="">

  <bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource">
      <property name="URL" value="jdbc:oracle:thin:@[hostname]:[port]/[service-name]"/>
      <property name="user" value="username"/>
      <property name="password" value="password"/>

 <service interface="javax.sql.DataSource" ref="dataSource">
   <entry key="" value="jdbc/oracleds"/>
   <entry key="" value="OracleDS"/>
  1. Installing the Oracle Driver in Karaf console
    install -s
    Note: Please make sure you’ve got the Oracle Driver in your local/remote maven repository. If you don’t have it please install with the following maven command –
    mvn install:install-file -Dfile=ojdbc6.jar 
     -DartifactId=ojdbc6 -Dversion=11.2.0 -Dpackaging=jar
  2. Deploy it on the Fuse ESB server

Copy the datasource-oracle.xml in the FUSE ESB deploy folder ( e.g. %FUSE_SERVER%/deploy )