title: Importing JDBC into Android Studio errors
body: <p>I am currently working on an Android app and I am attempting to retrieve information from a MySQL database. I am trying to use JDBC as instructed by my professors, but I keep running into problems.</p>
  
  <p>I have installed the MySQL Connector/ODBC 5.3, set a CLASSPATH environment variable for the driver I am attempting to use, which is "mysql-connector-java-5.1.38-bin.jar", and I attempted to import that JAR into my project.</p>
  
  <p>I have attempted to import the JAR in two ways, which are the following:</p>
  
  <p>File > New Module > Import .JAR/.AAR Package > import the mysql connector JAR
  Then I proceeded to go to File > Project Structure > app > Dependencies > add module dependency</p>
  
  <p>The other way I have attempted to do this was by adding the JAR into the "libs" folder of my project and follow the Project structure path to add a dependency from file.</p>
  
  <p>I am running the latest version of Android Studio 2.0</p>
  
  <p>The build completes successfully when following either of the importing steps however when doing so I get the following error when attempting to run the app:</p>
  
  <pre><code>    Execution failed for task ':app:transformClassesWithInstantRunForDebug'.
      &gt; JSR/RET are not supported with computeFrames option
  </code></pre>
  
  <p>The only solution I found relevant to this was going to Android Studio Settings and turning the Instant Run option off.</p>
  
  <p>After doing so I received the following error instead:</p>
  
  <pre><code>    Execution failed for task ':app:transformClassesWithDexForDebug'.
      &gt; com.android.build.api.transform.TransformException: com.android.ide.common.process.ProcessException:  java.util.concurrent.ExecutionException: com.android.ide.common.process.ProcessException: org.gradle.process.internal.ExecException: Process 'command 'C:\Program Files\Java\jdk1.8.0_77\bin\java.exe'' finished with non-zero exit value 1
  </code></pre>
  
  <p>The following is my build.gradle(Module:app):</p>
  
  <pre><code>  apply plugin: 'com.android.application'
  
    android {
  compileSdkVersion 23
  buildToolsVersion '23.0.3'
  
  defaultConfig {
      applicationId "com.example.JohnDoe.myapp"  //This is not actually the name or the name of the app on there but I changed this for privacy.
      minSdkVersion 14
      targetSdkVersion 23
      versionCode 1
      versionName "1.0"
      multiDexEnabled true
  
  }
  
  buildTypes {
      release {
          minifyEnabled false
          proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'
      }
  }
  
  dexOptions {
      incremental true
      javaMaxHeapSize "2048M"
      jumboMode = true
  }
    }
  
    dependencies {
  compile fileTree(include: ['*.jar'], dir: 'libs')
  testCompile 'junit:junit:4.12'
  compile 'com.android.support:appcompat-v7:23.1.1'
  compile 'com.android.support:design:23.2.1'
  compile 'com.squareup.retrofit2:retrofit:2.0.0'
  compile 'com.squareup.retrofit2:converter-gson:2.0.0'
  compile 'com.squareup.okhttp3:logging-interceptor:3.2.0'
  compile 'com.android.support:multidex:1.0.1'
  compile project(':mysql-connector-java-5.1.38-bin')
    }
  </code></pre>
  
  <p>The following is a link to the whole gradle console output after turning "Instant Run" off: pastebin.com/5kj6Cgeb</p>
  
  <p>Please advise me where to go from here to get the JDBC driver working so I can finish this project. Thank you for your time.</p>
  
  <p>UPDATE 1: Apparently the latest JDBC driver is not fully compatible with Android and causes issues. I installed and imported the previous version (5.0.8) and so far the app at least runs. Will be attempting to implement the driver now and actually develop with it, at which time I will post another update on the outcome.</p>