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

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

avtor — Wed, 13 Aug 2014 13:42:19 GMT

Alfresco 4.2 whith PostgreSQL database.OS: Ubuntu 14.04 server.When i try to invoke export/import tools, for example:java -cp "/mnt/4TB/DST/alfresco/alfresco-4.2/tomcat/lib/servlet-api.jar:classes/alfresco/module:classes:lib/*" org.alfresco.tools.Import -user admin -pwd admin -store workspace://Spac

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

jpotts — Thu, 14 Aug 2014 01:51:41 GMT

Alfresco is configured to use MySQL by default so if you've got it configured for PostgreSQL in your alfresco-global.properties file but the error message is complaining about MySQL it means your alfresco-global.properties file isn't being read.

Jeff

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

avtor — Thu, 14 Aug 2014 07:36:09 GMT

Thanks a lot. I've copied alfresco-global.properties to tomcat/webapps/alfresco/WEB-INF/classes and and have got connected sucessfully.

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

mrogers — Thu, 14 Aug 2014 13:53:10 GMT

That's the wrong place. Should you redeploy for some reason your changes will get lost.

The correct place is tomcat/shared/classes

If you are using a version of tomcat that you have installed yourself then you also need to configure the shared.loader in catalina.properties.

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

avtor — Thu, 14 Aug 2014 15:57:10 GMT

When location is tomcat/shared/classes It get error I wrote above.

In catalina.properties :
shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar

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

mrogers — Thu, 14 Aug 2014 17:49:21 GMT

very strange.

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

avtor — Fri, 15 Aug 2014 08:59:49 GMT

If add to classpath tomcat/shared/classes it works fine. it's my mistake.

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

jonvargas — Mon, 20 Oct 2014 17:02:25 GMT

Nice to know you solved it. Alfresco's bundled Tomcat is configured to use 'shared/classes' as part of the ClassPath, but newer Tomcat versions doesn't have it.

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

tgebeyehu — Sun, 28 Dec 2014 22:06:00 GMT

i am using alfresco 5 and alfresco maven sdk 2.0. when i update to alfresco 5 and alfresco sdk to 2.0.0 i keep seeing this error as a newbie i got stacked on my project and couldn't figure out how to solve it. any help.

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

sercama — Wed, 30 Jan 2019 15:37:59 GMT

Hi AVTOR _,

You should have the mysql library connector into tomcat/lib folder.

Regards,

Sergio.

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

sp2 — Thu, 30 May 2019 07:02:41 GMT

Is this issue resolved?

I have also same issue.