SQLDelight: Unresolved reference AndroidSqliteDriver in Kotlin Multiplatform App

Question

I try add sqldelight to my Kotlin Multiplatform App, but AndroidSqliteDriver unresolved reference. I dont understand why. I clear cache and regenerate all, but it dont work too.

AndroidSqliteDriver:

package com.rompos.deactivator

import com.squareup.sqldelight.android.AndroidSqliteDriver
import android.content.Context

lateinit var appContext: Context

actual fun createDB() : Server {
val driver = AndroidSqliteDriver(Server.Schema, appContext, "Server.db")
return Server(driver)
}

build.gradle(common):

import org.jetbrains.kotlin.gradle.plugin.mpp.KotlinNativeTarget

plugins {
kotlin("multiplatform")
id("com.squareup.sqldelight")
}

kotlin {
//select iOS target platform depending on the Xcode environment variables
val iOSTarget: (String, KotlinNativeTarget.() -> Unit) -> KotlinNativeTarget =
    if (System.getenv("SDK_NAME")?.startsWith("iphoneos") == true)
        ::iosArm64
    else
        ::iosX64

iOSTarget("ios") {
    binaries {
        framework {
            baseName = "SharedCode"
        }
    }
}

jvm("android")

// Common Main
sourceSets["commonMain"].dependencies {
    implementation("org.jetbrains.kotlin:kotlin-stdlib-common")
    implementation("io.ktor:ktor-client-core:1.3.2")
    implementation("com.squareup.sqldelight:runtime:1.4.0")
}

// Android Main
sourceSets["androidMain"].dependencies {
    implementation("org.jetbrains.kotlin:kotlin-stdlib")
    implementation("com.squareup.sqldelight:android-driver:1.4.0") {
        exclude(group = "com.squareup.sqldelight", module = "runtime-jdk")
    }
}

// iOS Main
sourceSets["iosMain"].dependencies {
    implementation("com.squareup.sqldelight:native-driver:1.4.0")
}
}

build.gradle(android):

apply plugin: 'com.android.application'
apply plugin: 'kotlin-android'
apply plugin: 'kotlin-android-extensions'
apply plugin: 'kotlin-kapt'
apply plugin: 'kotlinx-serialization'
apply plugin: 'com.squareup.sqldelight'

android {
compileSdkVersion 30
buildToolsVersion "30.0.1"
defaultConfig {
    applicationId "com.rompos.deactivator"
    minSdkVersion 26
    targetSdkVersion 30
    versionCode 1
    versionName "1.0"
    testInstrumentationRunner 
"androidx.test.runner.AndroidJUnitRunner"
}
buildTypes {
    release {
        minifyEnabled false
        proguardFiles getDefaultProguardFile('proguard-android- 
optimize.txt'), 'proguard-rules.pro'
    }
}
packagingOptions {
    exclude 'META-INF/*.kotlin_module'
}

buildFeatures {
    dataBinding true
}
}

dependencies {
implementation project(':SharedCode')
implementation fileTree(dir: 'libs', include: ['*.jar'])

implementation "org.jetbrains.kotlin:kotlin-stdlib:$kotlin_version"
implementation "androidx.core:core-ktx:1.3.1"
implementation "androidx.appcompat:appcompat:1.2.0"
implementation "com.google.android.material:material:1.2.0"
implementation "androidx.constraintlayout:constraintlayout:1.1.3"
implementation 
"androidx.swiperefreshlayout:swiperefreshlayout:1.1.0"
implementation "androidx.navigation:navigation-fragment-ktx:2.3.0"
implementation "androidx.navigation:navigation-ui-ktx:2.3.0"
implementation "org.jetbrains.kotlinx:kotlinx-coroutines- 
android:1.3.7"
implementation "androidx.lifecycle:lifecycle-runtime-ktx:2.2.0"
implementation "org.jetbrains.kotlinx:kotlinx-serialization- 
runtime:0.20.0"
implementation "io.ktor:ktor-client-android:1.3.2"
implementation "com.squareup.sqldelight:android- 
driver:$sqldelight_version"

testImplementation 'junit:junit:4.13'
androidTestImplementation 'androidx.test:runner:1.2.0'
androidTestImplementation 'androidx.test.espresso:espresso- 
core:3.2.0'
}

build.gradle(project):

buildscript {
ext {
    ext.kotlin_version = '1.3.72'
    sqldelight_version = "1.4.0"
}
repositories {
    google()
    jcenter()
    mavenCentral()
}
dependencies {
    classpath 'com.android.tools.build:gradle:4.0.1'
    classpath "org.jetbrains.kotlin:kotlin-gradle- 
    plugin:$kotlin_version"
    classpath "org.jetbrains.kotlin:kotlin- 
    serialization:$kotlin_version"
    classpath "com.squareup.sqldelight:gradle- 
    plugin:$sqldelight_version"
}
}

allprojects {
repositories {
    google()
    jcenter()
    maven { url "https://kotlin.bintray.com/kotlinx" }
}
}

task clean(type: Delete) {
delete rootProject.buildDir
}

I use: gradle: 6.1.1 gradle plugin: 4.0.1 kotlin: 1.3.72 upd: Add code

Answer 1

you only have a jvm target jvm("android") and not an android target. you need an android library or application target to use the android library.

EDIT: To add an android target:

//build.gradle(common)
plugins {
    ...
    // assuming your building a library. use application otherwise
    id("com.android.library") 
    id("kotlin-android")
}
...
android {
     // fill in your library or app info here
}

kotlin {
    android { // creates androidMain/Test source sets
        // ex: publishLibraryVariants("release", "debug")
    }

    ios() { ... } 

    val commonMain by getting { ... }
    val androidMain by getting { ... }
    ...
}

Answer 2

Make sure you're using at least Android Studio 4.1. You should only need to include the SQLDelight plugin in your common build.gradle.

build.gradle

...
apply plugin: "com.squareup.sqldelight" in the common build.gradle
...

sourceSets {
    commonMain.dependencies {
        ...
        // SQL Delight
        implementation "com.squareup.sqldelight:runtime:${Versions.sqlDelight}"
        implementation "com.squareup.sqldelight:coroutines-extensions:${Versions.sqlDelight}"
    }

    androidMain.dependencies {
        ...
        // SQL Delight
        implementation "com.squareup.sqldelight:android-driver:${Versions.sqlDelight}"
        implementation "com.squareup.sqldelight:coroutines-extensions-jvm:${Versions.sqlDelight}"
    }

    iOSMain.dependencies {
        ...
        // SQL Delight
        implementation "com.squareup.sqldelight:ios-driver:${Versions.sqlDelight}"
    }
}