title: c3p0 maxIdleTime is same as wait_timeout of mysql?
body: <p>I am having an Spring MVC + Mysql (JDBC 4) + c3p0 0.9.2 project.</p>
  
  <p>In c3p0 <code>maxIdleTime</code> value is 240 (i.e 4 mins.) and <code>wait_timeout</code> in my.ini of Mysql to 30 seconds.</p>
  
  <p>According to c3p0</p>
  
  <blockquote>
    <p>maxIdleTime:
        (Default: 0)
        Seconds a Connection can remain pooled but unused before being discarded. Zero means idle connections never expire.</p>
  </blockquote>
  
  <p>According to Mysql</p>
  
  <blockquote>
    <p>wait_timeout: The number of seconds the server waits for activity on a
    noninteractive connection before closing it.</p>
  </blockquote>
  
  <p>Now i am having some douts on this:(some answers are known to me,Just wated to be sure I am correct or not)</p>
  
  <ol>
  <li>unused connection means the connection which are in <code>sleep</code> state according to mysql(?)</li>
  <li>What is interactive and noninteractive connections?</li>
  <li>Is unused connections and noninteractive coonections are same? because my DBA set <code>wait_timeout</code> to 30 seconds (he come to this value by observing DB server so that very less amount of connections be in sleep mode) this means an connection can be in <code>sleep</code> mode for 30 seconds after that it will be closed but at the otherhand c3p0's <code>maxIdleTime</code> is set to 240 seconds so whats this <code>maxIdleTime</code> setting playing role in this case.</li>
  <li>What is <code>interactive_timeout</code>?</li>
  </ol>