Bonsoir,

je débute en programmation et j'essaie de trouver comment on se connecte à une base de données PostgreSql avec Kotlin mais pas de résultat positif.

J'ai trouvé des codes en Java que j'ai converti en Kotlin avec Intelli J mais cela ne fonctionne pas...

Merci d'avance du temps investi...

NOM DE LA BASE: VillesFrance
USER: postgre
PASSWORD: qwerty
LOCALHOST

dans la partie du code ci dessous j'ai rajouté pour information ce que Intelli J m'indique (les HINTS): url: user: password:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
try {
            Class.forName("org.postgresql.Driver")
            c = DriverManager.getConnection( url: "jdbc:postgresql://localhost:5432/VillesFrance",
                   user: "postgres", password: "qwerty")


Code Kotlin (Converti depuis code Java):

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import java.sql.Connection
import java.sql.DriverManager
 
object PostgreSQLJDBC {
    @JvmStatic
    fun main(args: Array<String>) {
        var c: Connection? = null
        try {
            Class.forName("org.postgresql.Driver")
            c = DriverManager
                .getConnection(
                    "jdbc:postgresql://localhost:5432/VillesFrance",
                    "postgres", "qwerty"
                )
        } catch (e: Exception) {
            e.printStackTrace()
            System.err.println(e.javaClass.name + ": " + e.message)
            System.exit(0)
        }
 
        println("Opened database successfully")
    }
}
Message d'erreurs:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/bin/java "-javaagent:/Applications/IntelliJ IDEA CE.app/Contents/lib/idea_rt.jar=59504:/Applications/IntelliJ IDEA CE.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath "/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/packager.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home/lib/tools.jar:/Users/jcmac/IdeaProjects/Apprentissage Kotlin/out/production/Geolocalisation:/Users/jcmac/Library/Application Support/IdeaIC2018.3/Kotlin/kotlinc/lib/kotlin-stdlib.jar:/Users/jcmac/Library/Application Support/IdeaIC2018.3/Kotlin/kotlinc/lib/kotlin-reflect.jar:/Users/jcmac/Library/Application Support/IdeaIC2018.3/Kotlin/kotlinc/lib/kotlin-test.jar:/Users/jcmac/Library/Application Support/IdeaIC2018.3/Kotlin/kotlinc/lib/kotlin-stdlib-jdk7.jar:/Users/jcmac/Library/Application Support/IdeaIC2018.3/Kotlin/kotlinc/lib/kotlin-stdlib-jdk8.jar" fr.jcboussiquet.geo.PostgreSQLJDBC
java.lang.ClassNotFoundException: org.postgresql.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at fr.jcboussiquet.geo.PostgreSQLJDBC.main(PostgreSQLJDBC.kt:11)
java.lang.ClassNotFoundException: org.postgresql.Driver
 
Process finished with exit code 0