title: MySql too many connections
body: <p>I hate to bring up a question which is widely asked on the web, but I cant seem to solve it.</p>
  
  <p>I started a project a while back and after a month of testing, I hit a "Too many connections" error. I looked into it, and "Solved" it by increasing the max_connections. This then worked.</p>
  
  <p>Since then more and more people started to use it, and it hit again. When I am the only user on the site, i type "show processlist" and it comes up with about 50 connections which are still open (saying "Sleep" in the command). Now, I dont know enough to speculate why these are open, but in my code I tripple checked and every connection I open, I close.</p>
  
  <p>ie.</p>
  
  <pre><code>public int getSiteIdFromName(String name, String company)throws DataAccessException,java.sql.SQLException{
  
  Connection conn = this.getSession().connection();
  Statement smt = conn.createStatement();
  ResultSet rs=null;
  String query="SELECT id FROM site WHERE name='"+name+"' and company_id='"+company+"'";
  
  rs=smt.executeQuery(query);
  rs.next();
  
  int id=rs.getInt("id");
  
  rs.close();
  smt.close();
  conn.close();
  return id;
  }
  </code></pre>
  
  <p>Every time I do something else on the site, another load of connections are opened and not closed.
  Is there something wrong with my code? and if not, what could be the problem?</p>