as it can be seen on the below snap code below i changed server.xml of my tomcat server of the H2 database with this mysql code. i added the mysql JDBC driver Jar file to the tomcats server library folder. i even added the mysql dependency to the POM.XML. but it could not work for me. it works with the H2 database but not with mysql. so i was wondering if i have to install mysql server instead of using wamp server. any suggestions?
name=“jdbc/ProcessEngine”
auth=“Container”
type=“javax.sql.DataSource”
factory=“org.apache.tomcat.jdbc.pool.DataSourceFactory”
uniqueResourceName=“process-engine”
driverClassName=“com.mysql.jdbc.Driver”
url=“jdbc:mysql://127.0.0.1:3306/n?useSSL=false&autoReconnect=true”
defaultTransactionIsolation=“READ_COMMITTED”
username=“sa”
password=“sa”
maxActive=“20”
minIdle=“5”
maxIdle=“20”