title: How to increase the DB connection Timeout
body: <p>I have got the connection Timeout in DB. Already I have set connection Timeout to '60sec' in DB.  I got the below error. After connecting with DB people ,have found that. The below error is not query command timeout and mostly of connection establishing  Mule to DB timeout. I have a doubt
       Here Connection Time= 60sec ( means once it reached DB, time to wait to execute the query). Is it correct.</p>
  
  <p>But then how to increase the connection Time out ?,  Going through the link
  <a href="http://www.mulesoft.org/documentation/display/current/Database+Connector+Examples" rel="nofollow">http://www.mulesoft.org/documentation/display/current/Database+Connector+Examples</a>. </p>
  
  <p>Thought to provide maxWaitMillis = 20000 as below. But not sure this is correct ( Because document talks about connection polling and cache, but I dont want cache all over here).</p>
  
  <p>Is it fine, without giving any other value inside connection polling. Just by giving maxWaitMilli timeout is correct for my case or I'm wrong. All I need is need to resolve the below error. Please suggest.</p>
  
  <pre><code>   Error:java.sql.SQLException: Cannot get connection for URL jdbc:sqlserver://c01.company.com;database=**;user=***;password=***** :    The TCP/IP connection to the host 01.company.com, port 022 has failed. Error: &amp;quot;connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.&amp;quot;. (org.mule.module.db.internal.domain.connection.ConnectionCreationException). Message payload is of type: String        
  
  
    &lt;db:generic-config name="DB" url="${db}"
      driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
      doc:name="Generic Database Configuration" connectionTimeout="60"&gt;
      &lt;db:pooling-profile maxWaitMillis="20000"/&gt;
  &lt;/db:generic-config&gt;
  
   &lt;db:stored-procedure config-ref="DB" doc:name="GetOrderXML"&gt;
          &lt;db:parameterized-query&gt;&lt;![CDATA[{call GetDetailXML('10', ?)}]]&gt;&lt;/db:parameterized-query&gt;
          &lt;db:in-param name="ln" type="CHAR" value="#[flowVars['ID']]"/&gt;
  
      &lt;/db:stored-procedure&gt;
  </code></pre>
  
  <p>Thanks in advance.</p>