title: Oozie + Sqoop: JDBC Driver Jar Location
body: <p>I have a 6 node cloudera based hadoop cluster and I'm trying to connect to an oracle database from a sqoop action in oozie.</p>
  
  <p>I have copied my ojdbc6.jar into the sqoop lib location (which for me happens to be at: /opt/cloudera/parcels/CDH-4.2.0-1.cdh4.2.0.p0.10/lib/sqoop/lib/ ) on all the nodes and have verified that I can run a simple 'sqoop eval' from all the 6 nodes.</p>
  
  <p>Now when I run the same command using Oozie's sqoop action, I get "Could not load db driver class: oracle.jdbc.OracleDriver"</p>
  
  <p>I have read <a href="http://blog.cloudera.com/blog/2012/12/how-to-use-the-sharelib-in-apache-oozie/">this article</a> about using shared libs and it makes sense to me when we're talking about my task/action/workflow specific dependencies. But I see a JDBC driver installation as an extention to sqoop and so I think it belongs in the sqoop installation lib.</p>
  
  <p>Now the question is, while sqoop sees this ojdbc6 jar I have put into it's lib folder, how come my Oozie workflow doesn't see it?</p>
  
  <p>Is this something expected or am I missing something?</p>
  
  <p>As an aside, what do you guy think about where is the appropriate location for a JDBC driver jar?</p>
  
  <p>Thanks in advance!</p>