RE: Vaadin + jdbc sqlite connection problem.

Vaadin 6 / 7 / 8
1

Hi,

the JDBC URL looks fine to me. Could it be that the sqlite jar is somehow not present in the classpath? Please try to build the WAR file, to see whether the sqlite.jar file will be present in the WAR file, in the libs/ folder.

2

Hi,

I’ve created a basic login form in Vaadin designer. I’ve added the jdbc.sqlite.jar file to the libraries, but IntelliJ still can’t find the “suitable” driver. I don’t know why it is happens, because in my JavaFX application it works well. What should I do? Are there any ideas?

“java.sql.SQLException: No suitable driver found for jdbc:sqlite:/Users…” Using the 3.2.1 version.

Thanks.

Zsolt Gomori

3

I don’t understand what you mean exactly, I’m not a professional yet. :slight_smile: Could you explain it, or any guide that helps me?

Thanks.

4

Yes, I think it’s not in the class path. How to add to this path?

5

It really depends on whether you use Maven, Gradle or whether it is just plain Intellij project. If you’re using Maven or Gradle, it’s easy to add the dependency to pom.xml and/or build.gradle respectively, there are great tutorials on how to do that. In Intellij you have to press F4 on the module, then there is the Libraries section and you just add the jdbc driver there.

6

Thanks for you help, now it works … I didn’t know that I also have to add the dependency to the pom.xml file … thanks again!