title: Data Conversion Error H2 Database
body: <p>I am running a database query from Java Application.</p>
  
  <pre><code>String id = app.getVariable("Product Id"),
                  name = app.getVariable("Product Name"),
                  rate = app.getVariable("Rate"),
                  type = app.getVariable("Type"),
                  desc = app.getVariable("Description"),
                  qty = app.getVariable("Quantity"); // Returns String from TextFields
  
          type = type.equalsIgnoreCase("LIMITED") ? "TRUE" : "FALSE";
  
  
          try {
              String query = "UPDATE COUNTER.PRODUCTS SET TITLE = ? AND RATE = ? AND IS_LIMITED = ? AND DESCRIPTION = ? WHERE ID = ?";
              PreparedStatement stmt = MainApp.getConnection().prepareStatement(query);
  
              stmt.setString(1, name);
              stmt.setDouble(2, Double.parseDouble(rate));
              stmt.setBoolean(3, Boolean.parseBoolean(type));
              stmt.setString(4, desc);
              stmt.setInt(5, Integer.parseInt(id));
  
              stmt.executeUpdate();
          } catch(Exception ex1){
              System.out.println( ex1.toString() );
          }
  </code></pre>
  
  <p>But SQLException is encountered </p>
  
  <blockquote>
    <p>org.h2.jdbc.JdbcSQLException: Data conversion error converting "Scanning"; SQL statement:<br>
    UPDATE COUNTER.PRODUCTS SET TITLE = ? AND RATE = ? AND IS_LIMITED = ? AND DESCRIPTION = ? WHERE ID = ? [22018-187]</p>
  </blockquote>
  
  <p>Insert data query works fine but I am unable to execute the update query.</p>