Problem with MySQL Connector on Appian installed locally
Greetings,
My coworkers and I are trying to install Appian 21.3 locally. We have follow the guide step by step and when we are launching tomcat it doesn't launch properly and when we read the logs it says this:
2021-09-23 15:13:27 INFORMACIÓN [main] org.apache.catalina.startup.Catalina.load Initialization processed in 808 ms
2021-09-23 15:13:27 INFORMACIÓN [main] org.apache.catalina.core.StandardService.startInternal Arrancando servicio [Catalina]
2021-09-23 15:13:27 INFORMACIÓN [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/8.5.70]
2021-09-23 15:13:27 INFORMACIÓN [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Desplieque del descriptor de configuración [C:\appian213\appian\tomcat\apache-tomcat\conf\Catalina\localhost\suite.xml]
Tomcat Cache Archive Entries [true]
2021-09-23 15:13:37 GRAVE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
java.sql.SQLException: Unable to load class: org.mysql.jdbc.Driver from ClassLoader:java.net.URLClassLoader@19469ea2;ClassLoader:AppianWebappClassLoader
context: suite
delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@19469ea2
We have followed the quick instalation guide for Windows. We have created the hashed password.
We have currently setup the path with the following values:
APPIAN_HOME: C:\appian213\appian
REPO_HOME: C:\appian213\repo\appian
JAVA_HOME: %APPIAN_HOME%\java
And the configuration in the tomcatResources.xml.dev is:
<Resource name="jdbc/AppianDS"
factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/appian213_primary?useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=utf8"
username="root"
password="<HASHED PASSWORD>"
initialSize="5"
maxActive="100"
defaultTransactionIsolation="READ_COMMITTED"
maxWait="30000"
minIdle="5"
minEvictableIdleTimeMillis="90000"
timeBetweenEvictionRunsMillis="450000"
validationQuery="SELECT 1"
testOnBorrow="true"
/>
The password field has another value in the real file. It has been changed for this.
We have put the mysql-connector-java-5.1.49-bin.jar in the %REPO_HOME%/tomcat/apache-tomcat/lib/ folder. And throws the same error. Even we have tried to put the file in %APPIAN_HOME%/tomcat/apache-tomcat/lib/ folder.
Any idea why it is not loading the jar file?