Page 1 of 1

java.sql.SQLException: No suitable Driver for

Posted: Thu Aug 13, 2020 8:44 pm
by Dalkeith00
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

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

Posted: Wed Jul 14, 2021 6:11 am
by teeraw22
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?

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

Posted: Mon Sep 06, 2021 10:04 am
by AlfaRomeo
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