title: Update on Insert HSQLDB
body: <p>I am trying to rewrite code, that was using MySQL database, to use HSQLDB. I have an <code>INSERT INTO ... ON DUPLICATE KEY UPDATE</code> query. Is there an alternative of this method for HSQLDB.</p>
  
  <p>Code:</p>
  
  <pre><code>PreparedStatement ps = conn.prepareStatement("INSERT INTO user_stats "
      + "(user, balance, kills, level)"
      + " VALUES(?, ?, ?, ?) ON DUPLICATE KEY "
      + "UPDATE balance=VALUES(balance), kills=VALUES(kills), level=VALUES(level)");
  
  ps.setString(1, playername);
  ps.setDouble(2, PluginInterract.getESSBalance(playername));
  ps.setInt(3, PluginInterract.getKills(playername));
  ps.setDouble(4, PluginInterract.getPluginLevel(playername));
  </code></pre>