s.setString(11, l.conveyanceUID); s.setString(12, l.routeUID); s.setString(13, l.missionUID);
s.setString(11, l.conveyanceUID.toString()); s.setString(12, (l.routeUID != null) ? l.routeUID.toString() : "null"); s.setString(13, l.missionUID.toString());
  protected boolean updateConveyedLeg(PreparedStatement s, Leg l){    boolean ret=false;    try{      s.setString(1, l.UID);      s.setString(2, dbConfig.dateToSQL(l.startTime));      s.setString(3, dbConfig.dateToSQL(l.endTime));      s.setString(4, dbConfig.dateToSQL(l.readyAtTime));      s.setString(5, dbConfig.dateToSQL(l.earliestEndTime));      s.setString(6, dbConfig.dateToSQL(l.bestEndTime));      s.setString(7, dbConfig.dateToSQL(l.latestEndTime));      s.setString(8, l.startLoc);      s.setString(9, l.endLoc);      s.setInt(10, pspToDBLegType(l.legType));      s.setString(11, l.conveyanceUID);      s.setString(12, l.routeUID);      s.setString(13, l.missionUID);      s.addBatch();    }catch(SQLException e){      haltForError(Logger.DB_WRITE,"Could not add batch to table("+		   getTableName(CONVEYED_LEG_TABLE)+")",e);      return false;    }    return true;  }