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 -

datasource-oracle.xml




2. Installing the Oracle Driver in Karaf console

install -s wrap:mvn:com.oracle/ojdbc6/11.2.0

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 -DgroupId=com.oracle \
    -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 )

Oracle Import Statement

Oracle JDBC Driver

Oracle Note : The Java classes to connect to Oracle are contained in the Oracle JDBC driver jar file. For recent releases, these are numbered based on the Java version they are compiled for, such as ojdbc14.jar (for Java 1.4), ojdbc15.jar (for Java 1.5), etc.