Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

EjikeAlfie — Tue, 20 Aug 2024 17:39:37 GMT

Good day Folks,

Can anyone please help me with this error below, any time I run :

a. sudo systemctl start tomcat and I check the logs: tail -f tomcat/logs/catalina.out. I get the following error below:

ejike@BlueFlame:~$ sudo systemctl start tomcat
ejike@BlueFlame:~$ tail -f tomcat/logs/catalina.out
20-Aug-2024 18:31:36.234 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/ejike/tomcat
20-Aug-2024 18:31:36.234 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/ejike/tomcat
20-Aug-2024 18:31:36.234 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/ejike/tomcat/temp
20-Aug-2024 18:31:36.235 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib]
20-Aug-2024 18:31:36.485 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
20-Aug-2024 18:31:36.507 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [450] milliseconds
20-Aug-2024 18:31:36.553 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
20-Aug-2024 18:31:36.553 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/10.1.28]
20-Aug-2024 18:31:36.564 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/ejike/tomcat/conf/Catalina/localhost/share.xml]
20-Aug-2024 18:31:42.497 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2024-08-20T18:31:48,162 [] INFO [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor freemarker for extension ftl
2024-08-20T18:31:48,173 [] INFO [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor javascript for extension js
2024-08-20T18:31:48,174 [] INFO [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor freemarker for extension ftl
2024-08-20T18:31:48,175 [] INFO [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor javascript for extension js
2024-08-20T18:31:49,393 [] INFO [extensions.webscripts.DeclarativeRegistry] [main] Registered 383 Web Scripts (+0 failed), 401 URLs
2024-08-20T18:31:49,394 [] INFO [extensions.webscripts.DeclarativeRegistry] [main] Registered 8 Package Description Documents (+0 failed)
2024-08-20T18:31:49,395 [] INFO [extensions.webscripts.DeclarativeRegistry] [main] Registered 0 Schema Description Documents (+0 failed)
2024-08-20T18:31:49,466 [] INFO [extensions.webscripts.AbstractRuntimeContainer] [main] Initialised Surf Container Web Script Container (in 1281.1036ms)
2024-08-20T18:31:49,467 [] INFO [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor freemarker for extension ftl
2024-08-20T18:31:49,468 [] INFO [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor javascript for extension js
2024-08-20T18:31:49,522 [] INFO [site.servlet.AIMSFilter] [main] Initializing the AIMS filter.
2024-08-20T18:31:49,522 [] INFO [site.servlet.AIMSFilter] [main] AIMS filter initialized.
20-Aug-2024 18:31:49.609 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of deployment descriptor [/home/ejike/tomcat/conf/Catalina/localhost/share.xml] has finished in [13,044] ms
20-Aug-2024 18:31:49.610 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [/home/ejike/tomcat/conf/Catalina/localhost/alfresco.xml]
Aug 20, 2024 6:31:55 PM org.apache.jasper.servlet.TldScanner scanJars
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Aug 20, 2024 6:31:55 PM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Aug 20, 2024 6:31:55 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1332)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1144)
at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:49)
at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:459)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:525)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160)

I look forward to any assistance given.

@angelborroy

Thanks

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

sp2 — Wed, 21 Aug 2024 09:33:41 GMT

Which DB you have configured?

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

EjikeAlfie — Wed, 21 Aug 2024 10:43:27 GMT

Hi @sanjaybandhniya ,

I have configured postgresql.

Thanks

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

sp2 — Thu, 22 Aug 2024 12:15:10 GMT

Have you deployed postgresql jar?

Refer https://javaworld-abhinav.blogspot.com/2021/06/setup-acs70-ass201-and-transformation-service.html

From this , you will get idea about configuration.

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

EjikeAlfie — Mon, 26 Aug 2024 12:12:09 GMT

Good day @sanjaybandhniya ,

The link you posted is not opening the page, does the link still exists?

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

fedorow — Wed, 04 Sep 2024 17:58:31 GMT

yes, it is

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Mus_FEK — Wed, 09 Apr 2025 14:06:15 GMT

Hello,

I have the same issue , i dont use mysql but postgresql in alfresco-global :

db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://localhost:5432/alfresco

topic Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver' in Alfresco Forum

Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'