topic mysql DB Connection problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mysql-db-connection-problem/m-p/171893#M125127 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>i'm encountering a problem during mysql database connection.</SPAN><BR /><SPAN>below the sequence steps i followed:</SPAN><BR /><BR /><SPAN>1) creation of "Activiti" database and user into mysql server</SPAN><BR /><SPAN>2) deploying of mysql connector to tomcat Lib folder (mysql-connector-java-5.1.21.jar)</SPAN><BR /><SPAN>3) modification of db.properties file in order to connect to Activiti database</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />db=activiti<BR />jdbc.driver=com.mysql.jdbc.Driver<BR />jdbc.url=jdbc:mysql://localhost:3306/activiti?autoReconnect=true<BR />jdbc.username=activiti<BR />jdbc.password=*<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>4) reboot of tomcat</SPAN><BR /><SPAN>5) creation of an "activiti.cfg.xml" file placed on src/main/resources path of my eclipse project</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>" <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>&nbsp;&nbsp; <A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A>"&gt;<BR /><BR />&lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" &gt;<BR />&nbsp; &lt;property name="driverClassName" value="com.mysql.jdbc.Driver" /&gt;<BR />&nbsp; &lt;property name="url" value="jdbc:mysql://localhost:3306/activiti" /&gt;<BR />&nbsp; &lt;property name="username" value="activiti" /&gt;<BR />&nbsp; &lt;property name="password" value="*" /&gt;<BR />&nbsp; &lt;property name="defaultAutoCommit" value="false" /&gt;<BR />&lt;/bean&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /><BR />&lt;bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;<BR />&lt;/bean&gt; <BR />&lt;/beans&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>6) Maven refresh of the project (mvn eclipse:eclipse)</SPAN><BR /><BR /><SPAN>My App contains only the following test code:</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp; public static void main(String[] args) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineConfiguration pec = ProcessEngineConfiguration.createProcessEngineConfigurationFromResourceDefault();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(pec.getDataSourceJndiName());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(pec.getJdbcDriver());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(pec.getJdbcUrl());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(pec.getJdbcUsername());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(pec.getJdbcPassword());<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>but the result is the following:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />null<BR />org.h2.Driver<BR />jdbc:h2:tcp://localhost/activiti<BR />sa<BR /> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Point of attention: the schema was created on db 'activiti' when i restarted.</SPAN><BR /><BR /><SPAN>My activiti version is 5.14</SPAN><BR /><SPAN>My tomcat version is 7.0.42</SPAN><BR /><SPAN>My mysql version is 5.6.11</SPAN><BR /><BR /><SPAN>Please tell me if you need more information or if you already discussed about the solution in other threads </SPAN><BR /><SPAN>(i have searched in forum from top to bottom but unsuccessfully).</SPAN><BR /><BR /><SPAN>Thank you in advance!</SPAN><BR /><SPAN>Andrea</SPAN></BODY></HTML> Thu, 05 Dec 2013 11:40:19 GMT andreanucifora 2013-12-05T11:40:19Z mysql DB Connection problem https://connect.hyland.com/t5/alfresco-archive/mysql-db-connection-problem/m-p/171893#M125127 Hi All,i'm encountering a problem during mysql database connection.below the sequence steps i followed:1) creation of "Activiti" database and user into mysql server2) deploying of mysql connector to tomcat Lib folder (mysql-connector-java-5.1.21.jar)3) modification of db.properties file in order to Thu, 05 Dec 2013 11:40:19 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-db-connection-problem/m-p/171893#M125127 andreanucifora 2013-12-05T11:40:19Z Re: mysql DB Connection problem https://connect.hyland.com/t5/alfresco-archive/mysql-db-connection-problem/m-p/171894#M125128 <HTML><HEAD></HEAD><BODY><SPAN>Printing out the values of pec.getJdbcDriver() will always return the "defaults" (being H2) unless you override those settings. I see you're using a datasource. Activiti will IGNORE the jdbc-properties on the PEConfiguration and will use the datasource instread to get connections from. Try logging/syso'ing the datasource and it's parameters to check what DB is actually used, instead of looking at the raw (unused) properties.</SPAN></BODY></HTML> Fri, 06 Dec 2013 09:56:36 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-db-connection-problem/m-p/171894#M125128 frederikherema1 2013-12-06T09:56:36Z