Copy-pasta from <#C0922A726|general> Hello, I'm ne...

# getting-started

[rikusen0335]

Copy-pasta from #general
Hello, I'm new to Kotlin, and I want to use Exposed with it, but I'm getting java.lang.NoClassDefFoundError: org/jetbrains/exposed/sql/Database.
Does anyone know how this happen and a solution for this? Thanks.
This project using Gradle, JVM.

[marstran]

Hi, how is your exposed dependency set up in Gradle?

[rikusen0335]

Thanks for replying.
in build.gradle ,

repositories {
    jcenter()
}
dependencies {
    compile "org.jetbrains.exposed:exposed:0.17.7"
    compile "org.xerial:sqlite-jdbc:3.21.0.1"
}

[marstran]

Ok. Maybe you could try the newest 0.18.1 version.
https://github.com/JetBrains/Exposed/wiki/Getting-Started#gradle

https://github.com/JetBrains/Exposed/wiki/LibDocumentation#gradle-groovy-1

[marstran]

Not sure if it would solve your problem, but worth a try.

[rikusen0335]

I'm sorry I tried that.
like this. isn't worked:

repositories {
    jcenter()
}
dependencies {
    compile 'org.jetbrains.exposed:exposed-core:0.18.1'
    compile 'org.jetbrains.exposed:exposed-dao:0.18.1'
    compile 'org.jetbrains.exposed:exposed-jdbc:0.18.1'
    compile "org.xerial:sqlite-jdbc:3.21.0.1"
}

[rikusen0335]

Well I got error when trying to do this code: Database.connect("jdbc:sqlite:file:test?mode=memory&cache=shared", "org.sqlite.JDBC")

[rikusen0335]

import doesn't matter

[Douglas KN]

for your db path does it work if you use a file? "jdbc:sqlite:test.sqlite"

[marstran]

Could it be that you also have an older version of exposed on your classpath? Some version where Database doesn't exist.

[marstran]

You can use gradle dependencies do view your dependency tree.

[rikusen0335]

@Douglas KN It doesn't work. I tested it on 1.18.1 and also 1.17.7.

[rikusen0335]

@marstran Okay, let me try it

[rikusen0335]

result output:

testRuntimeClasspath - Runtime classpath of compilation 'test' (target  (jvm)).
+--- org.jetbrains.exposed:exposed-core:0.18.1
|    +--- org.jetbrains.kotlin:kotlin-stdlib:1.3.50 -> 1.3.60
|    |    +--- org.jetbrains.kotlin:kotlin-stdlib-common:1.3.60
|    |    \--- org.jetbrains:annotations:13.0
|    +--- org.jetbrains.kotlin:kotlin-reflect:1.3.50
|    |    \--- org.jetbrains.kotlin:kotlin-stdlib:1.3.50 -> 1.3.60 (*)
|    +--- org.jetbrains.kotlinx:kotlinx-coroutines-core:1.3.0-M1
|    |    +--- org.jetbrains.kotlin:kotlin-stdlib:1.3.31 -> 1.3.60 (*)
|    |    \--- org.jetbrains.kotlin:kotlin-stdlib-common:1.3.31 -> 1.3.60
|    \--- org.slf4j:slf4j-api:1.7.25
+--- org.jetbrains.exposed:exposed-dao:0.18.1
|    \--- org.jetbrains.exposed:exposed-core:0.18.1 (*)
+--- org.jetbrains.exposed:exposed-jdbc:0.18.1
|    \--- org.jetbrains.exposed:exposed-core:0.18.1 (*)
+--- org.xerial:sqlite-jdbc:3.21.0.1
+--- org.jetbrains.kotlin:kotlin-stdlib:1.3.60 (*)
\--- junit:junit:4.12
     \--- org.hamcrest:hamcrest-core:1.3

[Douglas KN]

@rikusen0335 do you need to include one of the time modules? exposed-jodatime or exposed-java-time

[Igor Dzichkovskii]

You shouldn’t repeat the libraries in dependencies and isn’t it “implementation” instead of “compile”? Im a newbie too, so I’m not sure but try to change your compile word to implementation.

[rikusen0335]

@Douglas KN I don't need any time library for now. Just I wanted to do is connect to DB.

[rikusen0335]

@Igor Dzichkovskii Okay lemme show that

[rikusen0335]

implementation - Implementation only dependencies for compilation 'main' (target  (jvm)). (n)
\--- org.jetbrains.kotlin:kotlin-stdlib:1.3.60 (n)

implementationDependenciesMetadata
+--- org.jetbrains.exposed:exposed-core:0.18.1
|    +--- org.jetbrains.kotlin:kotlin-stdlib:1.3.50 -> 1.3.60
|    |    +--- org.jetbrains.kotlin:kotlin-stdlib-common:1.3.60
|    |    \--- org.jetbrains:annotations:13.0
|    +--- org.jetbrains.kotlin:kotlin-reflect:1.3.50
|    |    \--- org.jetbrains.kotlin:kotlin-stdlib:1.3.50 -> 1.3.60 (*)
|    +--- org.jetbrains.kotlinx:kotlinx-coroutines-core:1.3.0-M1
|    |    +--- org.jetbrains.kotlin:kotlin-stdlib:1.3.31 -> 1.3.60 (*)
|    |    \--- org.jetbrains.kotlin:kotlin-stdlib-common:1.3.31 -> 1.3.60
|    \--- org.slf4j:slf4j-api:1.7.25
+--- org.jetbrains.exposed:exposed-dao:0.18.1
|    \--- org.jetbrains.exposed:exposed-core:0.18.1 (*)
+--- org.jetbrains.exposed:exposed-jdbc:0.18.1
|    \--- org.jetbrains.exposed:exposed-core:0.18.1 (*)
+--- org.xerial:sqlite-jdbc:3.21.0.1
\--- org.jetbrains.kotlin:kotlin-stdlib:1.3.60 (*)

[rikusen0335]

Maybe this one is that?

[Igor Dzichkovskii]

@rikusen0335 How many Gradle files do you have? In Android there are 2, And it seems like you are trying to do implementation in the wrong Gradle file

[rikusen0335]

if it means only build.gradle , I have only 1

[rikusen0335]

Ahh also, I'm developing a minecraft spigot plugin (probably you don't know)

[Igor Dzichkovskii]

In Android it’s like this

[rikusen0335]

Mine is this

[Igor Dzichkovskii]

@rikusen0335 ok, and if you comment the problematic part, is Gradle building without errors? How many libraries do you use?

[rikusen0335]

Yes, gradle builds with no errors.

[rikusen0335]

I don't completely know, but I can show you build.gradle :

apply plugin: 'java'
apply plugin: 'kotlin'

group = pluginGroup
version = pluginVersion

sourceCompatibility = '1.8'
targetCompatibility = '1.8'

repositories {
    mavenCentral()
    jcenter()
    maven {
        name = 'papermc-repo'
        url = '<https://papermc.io/repo/repository/maven-public/>'
    }
    maven {
        name = 'sonatype'
        url = '<https://oss.sonatype.org/content/groups/public/>'
    }
}

dependencies {
    testCompile group: 'junit', name: 'junit', version: '4.12'
    compileOnly 'org.spigotmc:spigot-api:1.14.4-R0.1-SNAPSHOT'
    implementation "org.jetbrains.kotlin:kotlin-stdlib:$kotlin_version"

    compile 'org.jetbrains.exposed:exposed-core:0.18.1'
    compile 'org.jetbrains.exposed:exposed-dao:0.18.1'
    compile 'org.jetbrains.exposed:exposed-jdbc:0.18.1'
    compile 'org.xerial:sqlite-jdbc:3.21.0.1'
}

import org.apache.tools.ant.filters.ReplaceTokens

processResources {
    from(sourceSets.main.resources.srcDirs) {
        filter ReplaceTokens, tokens: [version: version]
    }
}
buildscript {
    ext {
        kotlin_version = '1.3.60'
        junit_version = '4.12'
        spigot_version = '1.14.1-R0.1-SNAPSHOT'
    }
    repositories {
        mavenCentral()
    }
    dependencies {
        classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version"
    }
}

[rikusen0335]

Sorry for too long

[Igor Dzichkovskii]

You put ‘exposed’ 3 times. I’m sure it leads to errors. I can advice you delete the redundant lines and let’s see what will happen

[rikusen0335]

they are not same, core, dao, and jdbc.

[rikusen0335]

maybe I'm talking about wrong?

[rikusen0335]

Like wiki says: https://github.com/JetBrains/Exposed/wiki/LibDocumentation

[Igor Dzichkovskii]

yeah, for real, I didn't notice they aren't the same, haha

[Igor Dzichkovskii]

@rikusen0335 Stackoverflow says you have to add

Kotlin-reflect

as a dependency. You can try to do it this way: https://stackoverflow.com/questions/48742377/kotlin-gradle-make-sure-you-have-kotlin-reflect-jar-in-the-classpath

[rikusen0335]

but I don't have Module:app, is this affective?

[Igor Dzichkovskii]

I saw in Stackoverflow that somebody put reflect only in build. I’m not sure about it, give it a try

[rikusen0335]

adding like this isn't affect:

dependencies {
    testCompile group: 'junit', name: 'junit', version: '4.12'
    compileOnly 'org.spigotmc:spigot-api:1.14.4-R0.1-SNAPSHOT'
    implementation "org.jetbrains.kotlin:kotlin-stdlib:$kotlin_version"
    implementation "org.jetbrains.kotlin:kotlin-reflect:$kotlin_version"

    compile 'org.jetbrains.exposed:exposed-core:0.18.1'
    compile 'org.jetbrains.exposed:exposed-dao:0.18.1'
    compile 'org.jetbrains.exposed:exposed-jdbc:0.18.1'
    compile 'org.xerial:sqlite-jdbc:3.21.0.1'
}

[Igor Dzichkovskii]

I think you should make 2 files of Gradle, bud 😞

[rikusen0335]

😢

[rikusen0335]

I figured it out! The cause is, the plugin Jar file doesn't include exposed libs.

[rikusen0335]

Thank you al so much!!

[Igor Dzichkovskii]

@rikusen0335 yeah, sorry for useless advices 😅

[rikusen0335]

No problem! Thanks anyway