Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.MapSqlParameterSource.addValue()

118
119
120
121
122
123
124
125
126
127
128
        byte[] rbytes = LimsUtils.objectToByteArray(printJob.getQueuedElements());
        barcodeBlob = new SerialBlob(rbytes);
        params.addValue("printedElements", barcodeBlob);
      }
      else {
        params.addValue("printedElements", null);
      }
    }
    catch (SerialException e) {
      e.printStackTrace();
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
              .usingGeneratedKeyColumns("jobId");
      Number newId = insert.executeAndReturnKey(params);
      printJob.setJobId(newId.longValue());
    }
    else {
      params.addValue("jobId", printJob.getJobId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(PRINT_JOB_UPDATE, params);
    }
    return printJob.getJobId();
  }
View Full Code Here
358
359
360
361
362
363
364
365
366
367
368
    else {
      log.warn("No status available to save for run: " + run.getAlias());
    }

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("accession", run.getAccession())
            .addValue("alias", run.getAlias())
            .addValue("description", run.getDescription())
            .addValue("platformRunId", run.getPlatformRunId())
            .addValue("pairedEnd", run.getPairedEnd())
            .addValue("cycles", run.getCycles())
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
        String name = namingScheme.generateNameFor("name", run);
        run.setName(name);

        if (namingScheme.validateField("name", run.getName())) {
          params.addValue("name", name);

          Number newId = insert.executeAndReturnKey(params);
          if (newId.longValue() != run.getId()) {
            log.error("Expected Run ID doesn't match returned value from database insert: rolling back...");
            new NamedParameterJdbcTemplate(template).update(RUN_DELETE, new MapSqlParameterSource().addValue("runId", newId.longValue()));
View Full Code Here
408
409
410
411
412
413
414
415
416
417
418
      */
    }
    else {
      try {
        if (namingScheme.validateField("name", run.getName())) {
          params.addValue("runId", run.getId())
                .addValue("name", run.getName());
          NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
          namedTemplate.update(RUN_UPDATE, params);
        }
        else {
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
          }
          long containerId = sequencerPartitionContainerDAO.save(l);

          SimpleJdbcInsert fInsert = new SimpleJdbcInsert(template).withTableName("Run_SequencerPartitionContainer");
          MapSqlParameterSource fcParams = new MapSqlParameterSource();
          fcParams.addValue("Run_runId", run.getId())
                  .addValue("containers_containerId", containerId);

          try {
            fInsert.execute(fcParams);
          }
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
        log.warn("No status available to save for run: " + run.getAlias());
      }

      try {
        MapSqlParameterSource params = new MapSqlParameterSource();
        params.addValue("accession", run.getAccession())
                .addValue("alias", run.getAlias())
                .addValue("description", run.getDescription())
                .addValue("platformRunId", run.getPlatformRunId())
                .addValue("pairedEnd", run.getPairedEnd())
                .addValue("cycles", run.getCycles())
View Full Code Here
530
531
532
533
534
535
536
537
538
539
540
            String name = namingScheme.generateNameFor("name", run);
            run.setName(name);

            if (namingScheme.validateField("name", run.getName())) {
              params.addValue("name", name);

              Number newId = insert.executeAndReturnKey(params);
              if (newId.longValue() != run.getId()) {
                log.error("Expected Run ID doesn't match returned value from database insert: rolling back...");
                new NamedParameterJdbcTemplate(template).update(RUN_DELETE, new MapSqlParameterSource().addValue("runId", newId.longValue()));
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
          */
        }
        else {
          try {
            if (namingScheme.validateField("name", run.getName())) {
              params.addValue("runId", run.getId())
                    .addValue("name", run.getName());
              log.debug(run.getName() + ":: Updating as ID " + run.getId());
              batch.add(params);
            }
            else {
View Full Code Here
593
594
595
596
597
598
599
600
601
602
603
              }
              long containerId = sequencerPartitionContainerDAO.save(l);

              SimpleJdbcInsert fInsert = new SimpleJdbcInsert(template).withTableName("Run_SequencerPartitionContainer");
              MapSqlParameterSource fcParams = new MapSqlParameterSource();
              fcParams.addValue("Run_runId", run.getId())
                      .addValue("containers_containerId", containerId);

              try {
                fInsert.execute(fcParams);
              }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.