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):
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
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") } }
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
Partager