title: JDBC driver not found error in monkeyrunner/jython
body: <p>I need to Insert something in the <code>DB</code>. im using <code>JDBC</code> as a <code>connector, jython the script</code>, <code>mysql</code> the DB and the script is running in <code>CentOS</code>. </p>
  
  <p>my code looks something like this:</p>
  
  <blockquote>
    <p>from <code>com.android.monkeyrunner import MonkeyRunner, MonkeyDevice, MonkeyImage</code> </p>
    
    <p>from <code>com.ziclix.python.sql import zxJDBC</code></p>
  
  <pre><code>  db=zxJDBC.connect("jdbc:mysql://XXX.XXX.XXX.XXX:3306/dbname","USER","PASSWORD","org.gjt.mm.mysql.Driver")
  </code></pre>
  </blockquote>
  
  <p><code>c=db.cursor() c.execute("INSERT INTO tablename values ('X','X','X')")</code></p>
  
  <p>before that, I downloaded and decompressed the file from <a href="http://dev.mysql.com/downloads/connector/j/" rel="nofollow">here</a> (in the desktop)</p>
  
  <p>I added the path to classpath by doing this</p>
  
  <pre><code> export PATH=/home/XX/Desktop/mysql-connector-java-5.1.22
  </code></pre>
  
  <p>and when I ran the script, it gave me this error </p>
  
  <blockquote>
    <p><code>zxJDBC.DatabaseError.driver [org.gjt.mm.mysql.Driver]</code> not found</p>
  </blockquote>
  
  <p>what have I done wrong? is the name of the driver name correct? because I just copied it in one of the tutorials that I've seen. or probably did I install the driver correctly?</p>
  
  <p>Thanks.</p>