java.sql.SQLException: No suitable Driver for

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

Dalkeith00
Posts: 2
Joined: Wed Aug 12, 2020 9:54 pm

java.sql.SQLException: No suitable Driver for

Thu Aug 13, 2020 8:44 pm

I cannot connect to logicaldoc post installation, http://localhost:8080 returns a 404. Note that I have bounced tomcat and tried again after that. The interesting thing is that catalina.out has:

Cannot create JDBC driver of class 'com.mysql.cj.jdbc.Driver' for connect URL ''
java.sql.SQLException: No suitable driver

sprinkled throughout.

I went back to the install log and noticed essentially the same error:

[echo] java.sql.SQLException: No suitable Driver for

With regards to the install, the jar file for mysql (mysql-connector-java-8.0.18.jar) is installed in tomcat/webapps/ROOT/WEB-INF/lib which is properly set in the classpath in build.xml:

<path id="class.path">
<pathelement path="${classpath}" />
<fileset dir="${lib.dir}">
<include name="**/*.jar" />
</fileset>
<pathelement location="${lib.dir}" />
<fileset dir="${webapp.dir}/WEB-INF/lib">
<include name="*.jar" />
</fileset>
</path>

But it seems that the path can't be found or something.

Anyone got any ideas? BTW, I'm attempting this on macos 10.15.6
teeraw22
Posts: 2
Joined: Wed Jul 14, 2021 6:04 am

Re: java.sql.SQLException: No suitable Driver for

Wed Jul 14, 2021 6:11 am

Dalkeith00 wrote:
Thu Aug 13, 2020 8:44 pm
I cannot connect to logicaldoc post installation, http://localhost:8080 returns a 404. Note that I have bounced tomcat and tried again after that. The interesting thing is that catalina.out has:

Cannot create JDBC driver of class 'com.mysql.cj.jdbc.Driver' for connect URL ''
java.sql.SQLException: No suitable driver

sprinkled throughout.

I went back to the install log and noticed essentially the same error:

[echo] java.sql.SQLException: No suitable Driver for

With regards to the install, the jar file for mysql (mysql-connector-java-8.0.18.jar) is installed in tomcat/webapps/ROOT/WEB-INF/lib which is properly set in the classpath in build.xml:

<path id="class.path">
<pathelement path="${classpath}" />
<fileset dir="${lib.dir}">
<include name="**/*.jar" />
</fileset>
<pathelement location="${lib.dir}" />
<fileset dir="${webapp.dir}/WEB-INF/lib">
<include name="*.jar" />
</fileset>
</path>

But it seems that the path can't be found or something.

Anyone got any ideas? BTW, I'm attempting this on macos 10.15.6
Did you can access MySQL prompt and show databases correctly?
AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

Re: java.sql.SQLException: No suitable Driver for

Mon Sep 06, 2021 10:04 am

Hello
Please have you here any answer?

have the same issue.... localhost:8080 no connetion to Database

Connection check on Debian/Console/Mysql are running without any issue

Thanks meny time for any possible answer
Regards

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 5 guests