ClassNotFoundException:找不到类"java.sql.SQLType"；在路径上:DexPathList [英] ClassNotFoundException: Didn't find class "java.sql.SQLType" on path: DexPathList

问题描述

当我尝试将MySQL数据库直接与Android上的JDBC连接时，出现如下异常:

When I try to connect a MySQL database directly with JDBC on Android, I got the Exception like this:

Caused by: java.lang.ClassNotFoundException: Didn't find class "java.sql.SQLType" on path: DexPathList[[zip file "/system/framework/org.apache.http.legacy.boot.jar",...

我的测试代码在这里:

package com.kurosei.app.test;

import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        try {
            Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
            Connection conn = DriverManager.getConnection(URL,USER,PWD);
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

和我的 build.gradle 在这里:

apply plugin: 'com.android.application'

android {
    compileSdkVersion 26
    defaultConfig {
        applicationId "com.kurosei.app.test"
        minSdkVersion 15
        targetSdkVersion 26
        versionCode 1
        versionName "1.0"
        testInstrumentationRunner "android.support.test.runner.AndroidJUnitRunner"
    }
    buildTypes {
        release {
            minifyEnabled false
            proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'
        }
    }
    compileOptions {
        targetCompatibility 1.8
        sourceCompatibility 1.8
    }

}

dependencies {
    implementation fileTree(dir: 'libs', include: ['*.jar'])
    implementation 'com.android.support:appcompat-v7:26.1.0'
    implementation 'com.android.support.constraint:constraint-layout:1.1.1'
    testImplementation 'junit:junit:4.12'
    androidTestImplementation 'com.android.support.test:runner:1.0.2'
    androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2'
    implementation 'mysql:mysql-connector-java:8.0.11'

}

• JDK的版本是1.8.0_152

  • The version of JDK is 1.8.0_152

    Gradle插件的版本为3.1.3

    The version of Gradle Plugin is 3.1.3

    Android Studio的版本为3.1.2

    The version of Android Studio is 3.1.2

    不要问我为什么选择这种方式来访问数据库...

    Don't ask why I choose this way to access the database...

    推荐答案

    您可能要包括JBoss JDBC Wrapper，下面在gradle中添加了它

    You may want to include JBoss JDBC Wrapper, added below in gradle

    implementation files('libs/jboss-common-jdbc-wrapper.jar')
    

    这篇关于ClassNotFoundException:找不到类"java.sql.SQLType"；在路径上:DexPathList的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！