releaseDBconnection();
closeConnection();
  private void regionList()   {    String regionName;    ResultSet rs = null;     // get the list of regions    try    {      conn = getConnection();      // conn.setAutoCommit(false);	// faster if made inside a Tx      stmt = conn.prepareStatement("SELECT name, id FROM regions");      rs = stmt.executeQuery();    }    catch (Exception e)    {      sp.printHTML("Failed to executeQuery for the list of regions" +e);      releaseDBconnection();      return;    }    try     {      if (!rs.first())      {        sp.printHTML("<h2>Sorry, but there is no region available at this time. Database table is empty</h2><br>");        releaseDBconnection();        return;      }      else        sp.printHTML("<h2>Currently available regions</h2><br>");        do      {        regionName = rs.getString("name");        sp.printRegion(regionName);      }      while (rs.next());       //conn.commit();    }     catch (Exception e)     {      sp.printHTML("Exception getting region list: " + e +"<br>");      //       try      //       {      //         conn.rollback();      //       }      //       catch (Exception se)       //       {      //         sp.printHTML("Transaction rollback failed: " + e +"<br>");      //       }    }  }