Getting 404 error when I changed my h2 database to mysql

[krishan_deo]

Hi,
When I changed my h2 database to mysql database in db.properties file then I am getting, HTTP Status 404 - /activiti-explorer when I open the activiti explorer.
Please help me I am using 5.19 version.

Thank You

[hari]

Hi Krishan,
Ideally it has to work. The community members here will not be able to help you with the information which you have provided. Please share the logs etc.
But clearly what I can say is that it could only be because of the db configurations being incorrect. Please verify them.

[krishan_deo]

Hello Sir
I have verified my db.properties, every thing is fine still I am getting error
Failed to load resource: http://localhost:8080/activiti-explorer the server responded with a status of 404 (Not Found)
My db.properties file
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=root
jdbc.password=root

[hari]

Hi Krishan,

Check if the mysql service is up and running in your system. And if it up, check the port and the user credentials by trying to connect to it with the db client. If everything works and not just here the look at the logs and see whats getting printed there.

[krishan_deo]

mysql service is up and running fine with other java example, I searched log in var/log directory but there is no log file.

[faizal-manan]

1. verify act_* table
2. reconfigure log4j

you should able to see the stacktrace during starting your webserver. It's should be there unless it turn off

[mahamuniraviraj]

mysql-connector-java-x.x.xx.jar is missing.  Download the jar from maven repository. If you  are deploying activiti-explorer war in Tomcat, then copy mysql connector jar to following folder  : {TOMCAT_HOME}/webapps/activiti-explorer/WEB-INF/lib.