Copy pasta from Hello I m new to Kotlin

Question

Copy pasta from < C0922A726|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 · Answer

Hi how is your exposed dependency set up in Gradle

rikusen0335 · Answer

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 · Answer

Ok Maybe you could try the newest 0 18 1 version

marstran · Answer

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

rikusen0335 · Answer

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 · Answer

Well I got error when trying to do this code `Database connect jdbc sqlite file test mode=memory amp cache=shared org sqlite JDBC `

rikusen0335 · Answer

import doesn t matter

Douglas KN · Answer

for your db path does it work if you use a file ` jdbc sqlite test sqlite `

marstran · Answer

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

marstran · Answer

You can use `gradle dependencies` do view your dependency tree

rikusen0335 · Answer

< Douglas KN> It doesn t work I tested it on 1 18 1 and also 1 17 7

rikusen0335 · Answer

< marstran> Okay let me try it

rikusen0335 · Answer

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 gt 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 gt 1 3 60 | + org jetbrains kotlinx kotlinx coroutines core 1 3 0 M1 | | + org jetbrains kotlin kotlin stdlib 1 3 31 gt 1 3 60 | | org jetbrains kotlin kotlin stdlib common 1 3 31 gt 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 · Answer

< rikusen0335> do you need to include one of the time modules exposed jodatime or exposed java time

Igor Dzichkovskii · Answer

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 · Answer

< Douglas KN> I don t need any time library for now Just I wanted to do is connect to DB

rikusen0335 · Answer

< Igor Dzichkovskii> Okay lemme show that

rikusen0335 · Answer

```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 gt 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 gt 1 3 60 | + org jetbrains kotlinx kotlinx coroutines core 1 3 0 M1 | | + org jetbrains kotlin kotlin stdlib 1 3 31 gt 1 3 60 | | org jetbrains kotlin kotlin stdlib common 1 3 31 gt 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 · Answer

Maybe this one is that

Igor Dzichkovskii · Answer

< 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 · Answer

if it means only `build gradle` I have only 1

rikusen0335 · Answer

Ahh also I m developing a minecraft spigot plugin probably you don t know

Igor Dzichkovskii · Answer

In Android it s like this

rikusen0335 · Answer

Mine is this

Igor Dzichkovskii · Answer

< rikusen0335> ok and if you comment the problematic part is Gradle building without errors How many libraries do you use

rikusen0335 · Answer

Yes gradle builds with no errors

rikusen0335 · Answer

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 = maven name = sonatype url = 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 · Answer

Sorry for too long

Igor Dzichkovskii · Answer

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 · Answer

they are not same core dao and jdbc

rikusen0335 · Answer

maybe I m talking about wrong

rikusen0335 · Answer

Like wiki says <https github com JetBrains Exposed wiki LibDocumentation>

Igor Dzichkovskii · Answer

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

Igor Dzichkovskii · Answer

< rikusen0335> Stackoverflow says you have to add ```Kotlin reflect``` as a dependency You can try to do it this way

rikusen0335 · Answer

but I don t have Module app is this affective

Igor Dzichkovskii · Answer

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

rikusen0335 · Answer

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 · Answer

I think you should make 2 files of Gradle bud disappointed

rikusen0335 · Answer

cry

rikusen0335 · Answer

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

rikusen0335 · Answer

Thank you al so much

Igor Dzichkovskii · Answer

< rikusen0335> yeah sorry for useless advices sweat smile

rikusen0335 · Answer

No problem Thanks anyway