Hi everyone, This might be a very specific proble...

# exposed

[Hasan]

Hi everyone,

This might be a very specific problem, or I might be doing something wrong. I am playing around with Exposed and trying to use it with postgresql. I imported the latest verison of the postgresql jdbc driver using the maven dependency:

maven
<dependency>
	<groupId>org.postgresql</groupId>
	<artifactId>postgresql</artifactId>
	<version>42.2.5.jre7</version>
	<type>bundle</type>
</dependency>

And I attempted to connect to the database using:

kotlin
Database.connect(
	"jdbc:<postgresql://localhost:5432/my_db>", 
	driver = "org.postgresql.Driver", 
	user = "postgres", 
	password = "welcome")

And this is the error I'm getting:

Exception in thread "main" java.lang.ClassNotFoundException: org.postgresql.Driver at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:582) at 
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:190) at 
java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:499) at 
java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:291) at 
org.jetbrains.exposed.sql.Database$Companion.connect(Database.kt:112) at 
org.jetbrains.exposed.sql.Database$Companion.connect$default(Database.kt:111) at 
com.example.test.ExposedTest.connect(ExposedTest.kt:30) at com.example.test.HelloKt.main(Hello.kt:5)

Can you spot what I might be doing wrong? Thanks in advance!

[tapac]

What java version do you use?

[tjb]

i get this same error when trying to connect to mysql

[tjb]

@Hasan hey this worked for me https://stackoverflow.com/questions/23771129/cant-test-connection-to-mysql-using-intellij. it fixed the issue

[tjb]

specifically this comment

Go to Itellij IDEA menue: File-->project structure-->Modules-->choose your module-->Dependencies-->Click + to add Library-->Choose mysql-connector-java-->Apply & OK