title: Android + MySQL using com.mysql.jdbc.Driver
body: <p>I am writing an Android application that will connect to a MySQL server. For now, I am testing the MySQL server on my computer through XAMPP using <a href="http://localhost:3306/" rel="nofollow">http://localhost:3306/</a>.  The code below works fine when testing it strictly as a JAVA application.</p>
  
  <pre><code>import java.sql.*;
  
  public class MySQL{
    public static void main(String[] args) {
      System.out.println("MySQL Connect Example.");
      Connection conn = null;
      String url = "jdbc:mysql://localhost:3306/";
      String dbName = "database";
      String driver = "com.mysql.jdbc.Driver";
      String userName = "root"; 
      String password = "";
      try {
        Class.forName(driver).newInstance();
        conn = DriverManager.getConnection(url+dbName,userName,password);
        System.out.println("Connected to the database");
        conn.close();
        System.out.println("Disconnected from database");
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  </code></pre>
  
  <p>However when I add it to my Android application I get the Exception e error.</p>
  
  <pre><code>// interact with MySQL!!!
   private View.OnClickListener onSendRequest = new View.OnClickListener() {
    @Override
    public void onClick(View v) {
     EditText username = (EditText) findViewById(R.id.Huusername);
        //    String un = " " + username.getText().toString() + " ";
  
        System.out.println("MySQL Connect Example.");
        Connection conn = null;
        String url = "jdbc:mysql://localhost:3306/";
        String dbName = "database";
        String driver = "com.mysql.jdbc.Driver";
        String userName = "root"; 
        String password = "";
        try {
          Class.forName(driver).newInstance();
          conn = DriverManager.getConnection(url+dbName,userName,password);
          Toast.makeText(getBaseContext(),
        "Connected to the database.", Toast.LENGTH_LONG)
        .show();
          conn.close();
          Toast.makeText(getBaseContext(),
        "Disconnected form the database.", Toast.LENGTH_LONG)
        .show();
        } catch (Exception e) {
         Toast.makeText(getBaseContext(),
        "Exception e.", Toast.LENGTH_LONG)
        .show();
          e.printStackTrace();
        }
  
  
    }
   };
  </code></pre>
  
  <p>As I am compiling my Android application, I notice the following statement in the Console:</p>
  
  <pre><code>[2011-01-26 16:05:54 - hookup]: Dxwarning: Ignoring InnerClasses attribute for an anonymous inner class
  (com.mysql.jdbc.interceptors.ResultSetScannerInterceptor$1) that doesn't come with an
  associated EnclosingMethod attribute. This class was probably produced by a
  compiler that did not target the modern .class file format. The recommended
  solution is to recompile the class from source, using an up-to-date compiler
  and without specifying any "-target" type options. The consequence of ignoring
  this warning is that reflective operations on this class will incorrectly
  indicate that it is *not* an inner class.
  </code></pre>
  
  <p>I assume this statement has something to do with the Exception I am getting.  Has anyone worked with MySQL and Android that could lead me in the right direction?
  Thanks</p>