nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

avtor

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://SpacesStore -path sys:system -verbose Zone.xml

i get following message: [alfresco.repo.admin] [main] Using database URL 'jdbc:mysql:///alfresco' with user 'alfresco'.
then: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

Alfresco-global.properties contain :
### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=${password}
db.name=alfresco
db.url=jdbc

ostgresql://localhost:5432/${db.name}

Please, help me find out, how to correct invoke export/import tools.

Find more posts tagged with

Comments

jpotts

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

avtor

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

mrogers

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.

avtor

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

mrogers

very strange.

avtor

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

jonvargas

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.

tgebeyehu

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.

sercama

Hi AVTOR _,

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

Regards,

Sergio.

sp2

Is this issue resolved?

I have also same issue.