Examples of executeAndReturnKey()

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

132
133
134
135
136
137
138
139
140
141
142
    if (printJob.getJobId() == AbstractPrintJob.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
              .withTableName(TABLE_NAME)
              .usingGeneratedKeyColumns("jobId");
      Number newId = insert.executeAndReturnKey(params);
      printJob.setJobId(newId.longValue());
    }
    else {
      params.addValue("jobId", printJob.getJobId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

383
384
385
386
387
388
389
390
391
392
393
        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()));
            throw new IOException("Something bad happened. Expected Run ID doesn't match returned value from DB insert");
          }
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

532
533
534
535
536
537
538
539
540
541
542
            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()));
                throw new IOException("Something bad happened. Expected Run ID doesn't match returned value from DB insert");
              }
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

193
194
195
196
197
198
199
200
201
202
203
        pcr.setName(name);

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

          Number newId = insert.executeAndReturnKey(params);
          if (newId.longValue() != pcr.getId()) {
            log.error("Expected emPCR ID doesn't match returned value from database insert: rolling back...");
            new NamedParameterJdbcTemplate(template).update(EMPCR_DELETE, new MapSqlParameterSource().addValue("pcrId", newId.longValue()));
            throw new IOException("Something bad happened. Expected emPCR ID doesn't match returned value from DB insert");
          }
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

167
168
169
170
171
172
173
174
175
176
177
    if (alert.getAlertId() == DefaultAlert.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
                            .withTableName(TABLE_NAME)
                            .usingGeneratedKeyColumns("alertId");
      Number newId = insert.executeAndReturnKey(params);
      alert.setAlertId(newId.longValue());
    }
    else {
      params.addValue("alertId", alert.getAlertId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

294
295
296
297
298
299
300
301
302
303
304
        experiment.setName(name);

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

          Number newId = insert.executeAndReturnKey(params);
          if (newId.longValue() != experiment.getId()) {
            log.error("Expected Experiment ID doesn't match returned value from database insert: rolling back...");
            new NamedParameterJdbcTemplate(template).update(EXPERIMENT_DELETE, new MapSqlParameterSource().addValue("experimentId", newId.longValue()));
            throw new IOException("Something bad happened. Expected Experiment ID doesn't match returned value from DB insert");
          }
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

124
125
126
127
128
129
130
131
132
133
134
    if (sequencerReference.getId() == AbstractSequencerReference.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
                            .withTableName(TABLE_NAME)
                            .usingGeneratedKeyColumns("referenceId");

      Number newId = insert.executeAndReturnKey(params);
      sequencerReference.setId(newId.longValue());
    }
    else {
      params.addValue("referenceId", sequencerReference.getId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

328
329
330
331
332
333
334
335
336
337
338
        project.setName(name);

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

          Number newId = insert.executeAndReturnKey(params);
          if (newId.longValue() != project.getId()) {
            log.error("Expected Project ID ('"+project.getId()+"') doesn't match returned value ('"+newId.longValue()+"') from database insert: rolling back...");
            new NamedParameterJdbcTemplate(template).update(PROJECT_DELETE, new MapSqlParameterSource().addValue("projectId", newId.longValue()));
            throw new IOException("Something bad happened. Expected Project ID doesn't match returned value from DB insert");
          }
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

434
435
436
437
438
439
440
441
442
443
444
    if (overview.getOverviewId() == ProjectOverview.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
              .withTableName("ProjectOverview")
              .usingGeneratedKeyColumns("overviewId");
      Number newId = insert.executeAndReturnKey(params);
      overview.setOverviewId(newId.longValue());

      Project p = overview.getProject();

      SimpleJdbcInsert pInsert = new SimpleJdbcInsert(template)
View Full Code Here

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey()

141
142
143
144
145
146
147
148
149
150
151
    if (libraryQC.getId() == AbstractLibraryQC.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
                              .withTableName(TABLE_NAME)
                              .usingGeneratedKeyColumns("qcId");
      Number newId = insert.executeAndReturnKey(params);
      libraryQC.setId(newId.longValue());
    }
    else {
      params.addValue("qcId", libraryQC.getId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
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.