title: Hue Hive -- Beeswax Server Can't Find JDBC Driver for MySQL
body: <p>We're using the Cloudera 3.7.5 and having a tough time configuring the Beeswax server such that the Hue can access the Hive databases.  I followed all the instructions from the Cloudera documentation that to setup MySQL to serve as Hive's metastore, but when I restart the Hue services and check Beeswax server's StdErr logs, I still see the painful "javax.jdo.JDOFatalInternalException: Error creating transactional connection factory" which is caused by </p>
  
  <pre><code>org.datanucleus.exceptions.NucleusException: Attempt to invoke the "DBCP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
  </code></pre>
  
  <p>This is bizzare to me, because the logs also indicate that the environment variable HIVE_HOME is equal to "/usr/lib/hive", and sure enough I have copied the "mysql-connector-java-5.1.15-bin.jar" into the /usr/lib/hive/lib directory, as the documents dictate.</p>
  
  <p>I have also tried the instructions on the blog post <a href="http://hadoopchallenges.blogspot.com/2011/03/hue-120-upgrade-and-beeswax.html" rel="nofollow">http://hadoopchallenges.blogspot.com/2011/03/hue-120-upgrade-and-beeswax.html</a>, which involved copying the the mysql-connector jar into "/usr/share/hue/apps/beeswax/hive/lib/".  Unfortunately I did not have a hive/lib subdirectory in the beeswax folder, so I attempted to make one.  This also did not work.</p>
  
  <p>Any advice how I can get the MySQL JDBC library onto Beeswax's classpath?</p>