Hi Everyone, Today we are going to see how we can execute a Select statement in Hadoop Hive data base using oracle soa DB adapter. Before going into configuration & deployment steps, One thing oracle SOA/Weblogic does not have default built in support to connect over HIVE DB, to full fill same we have to use external JAR's of hadoop hive which will be configured in oracle weblogic. Following is list of JAR's which will be used inside configuration. hive-jdbc-1.2.1-standalone.jar hadoop-common.jar JDev configuration for Data base connection: Click on Driver Class "Add button". Driver class:org.apache.hive.jdbc.HiveDriver Libaray: Add Jar "Hive-jdbc-1.2.1-standalone" Add class path for both jar. Check Connection Status, If you have configured JAR correctly with exact version number of DB. It will work. SOA Project configuration: Create one SOA application. Drag & Drop DB adapter You can't use standard impl