title: android.database.sqlite.SQLiteException: near "?": syntax error (code 1):
body: <p>I'm using Room library (MVVM Pattern), and one of the Dao functions returns this error message:</p>
  
  <pre><code>android.database.sqlite.SQLiteException: near "?": syntax error (code 1): , while compiling: UPDATE parcel_table SET possibleDeliveryPersonsList = ?,? WHERE id = ?
  </code></pre>
  
  <p>This is the Dao code:</p>
  
  <pre><code>@Dao
  public interface ParcelDao {
      @Insert
      void insert(Parcel parcel);
  
      @Delete
      void delete(Parcel parcel);
  
      @Query("UPDATE parcel_table SET shippingDate=:shippingDate WHERE id = :id")
      void updateShippingDate(String shippingDate, int id);
  
      @Query("UPDATE parcel_table SET parcelStatus=:status WHERE id = :id")
      void updatePackageStatus(Enums.ParcelStatus status, int id);
  
      @Query("UPDATE parcel_table SET deliveryPersonName=:deliveryPersonName WHERE id = :id")
      void updateDeliveryPersonName(String deliveryPersonName, int id);
  
      @Query("UPDATE parcel_table SET possibleDeliveryPersonsList = :possibleList WHERE id = :tid")
      void updatePossibleDeliveryPersonsList(List&lt;String&gt; possibleList, int tid);
  
      @Query("DELETE FROM parcel_table")
      void deleteAllParcels();
  
      @Query("SELECT * from parcel_table")
      LiveData&lt;List&lt;Parcel&gt;&gt; getParcels();
  }
  </code></pre>
  
  <p>And this is part of the Parcel class:</p>
  
  <pre><code>@Entity(tableName = "parcel_table")
  public class Parcel {
      private Enums.ParcelType parcelType;
      private boolean isFragile;
      private Enums.ParcelWeight parcelWeight;
      private LatLng warehouseLocation;
      private String recipientName;
      private LatLng recipientAddress;
      private String recipientEmail;
      private String recipientPhone;
      private String dateReceived;
      private String shippingDate;
      private Enums.ParcelStatus parcelStatus;
      private String deliveryPersonName;
      private String fireBasePushId;
      private List&lt;String&gt; possibleDeliveryPersonsList;
  @PrimaryKey(autoGenerate = true)
      @NonNull
      private int id;
          //and more...
  }
  </code></pre>
  
  <p>The <code>List&lt;String&gt;</code> Type Converter:</p>
  
  <pre><code>@TypeConverter
      public String listToString(List&lt;String&gt; list) {
          String joined = TextUtils.join(", ", list);
          return joined;
      }
  
      @TypeConverter
      public List&lt;String&gt; stringToList(String string) {
          List&lt;String&gt; myList = new ArrayList&lt;String&gt;(Arrays.asList(string.split(",")));
          return myList;
      }
  </code></pre>
  
  <p>I have no idea what to do, because the SQLite code is supposedly automatically generated by the Dao and I have no effect on it ...</p>