Package org.springframework.jdbc.core.simple

Examples of org.springframework.jdbc.core.simple.SimpleJdbcTemplate

40
41
42
43
44
45
46
47
    {
        Connection connection = dataSource.getConnection();
        strategy.enableVersioning(DatabaseType.H2, connection);
        connection.close();

        SimpleJdbcTemplate jdbcTemplate = new SimpleJdbcTemplate(dataSource);
        jdbcTemplate.queryForInt("select count(*)" + VERSION_COLUMN + " from " + TABLE_NAME); // Throws exception is table doesn't exist.
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
        Connection connection = dataSource.getConnection();
        strategy.enableVersioning(DatabaseType.H2, connection);
        strategy.recordMigration(DatabaseType.H2, connection, v1, new Date(), 768);
        connection.close();

        SimpleJdbcTemplate jdbcTemplate = new SimpleJdbcTemplate(dataSource);
        assertThat(jdbcTemplate.queryForInt("select count(*) from " + TABLE_NAME), is(1));
        assertThat(jdbcTemplate.queryForObject("select " + VERSION_COLUMN + " from " + TABLE_NAME, String.class), is(v1));

        connection = dataSource.getConnection();
        strategy.recordMigration(DatabaseType.H2, connection, v2, new Date(), 231);
        connection.close();

        assertThat(jdbcTemplate.queryForInt("select count(*) from " + TABLE_NAME), is(2));

        connection = dataSource.getConnection();
        Set<String> appliedMigrations = strategy.appliedMigrations(DatabaseType.H2, connection);
        assertThat(appliedMigrations, hasSize(2));
        assertThat(appliedMigrations, hasItems(v1, v2));
View Full Code Here
67
68
69
70
71
72
73
74
 
  protected void checkDaoConfig() {
    super.checkDaoConfig();
    if(dialect == null) throw new IllegalStateException("'dialect' property must be not null");
    log.info("use jdbc dialect:"+dialect);
    simpleJdbcTemplate = new SimpleJdbcTemplate(getJdbcTemplate());
    namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(getJdbcTemplate());
  }
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
286
        }
        else {
          throw new IOException("Cannot save sample - invalid field:" + sample.toString());
        }
      }
      SimpleJdbcTemplate sTemplate = new SimpleJdbcTemplate(template);
      return sTemplate.batchUpdate(SAMPLE_UPDATE, batch.toArray(new SqlParameterSource[samples.size()]));
    }
    catch (MisoNamingException e) {
      throw new IOException("Cannot save sample - issue with naming scheme", e);
    }
  }
View Full Code Here
30
31
32
33
34
35
36
  @Override
  public void setDataSource(DataSource dataSource) {
    super.setDataSource(dataSource);
    // JdbcTemplate will be identically configured
    this.simpleJdbcTemplate = new SimpleJdbcTemplate(this.jdbcTemplate);
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
   private SimpleJdbcInsert bookInsert;

   @Autowired(required = true)
   public void initialize(final DataSource dataSource) {
      this.jdbcTemplate = new SimpleJdbcTemplate(dataSource);
      this.bookInsert = new SimpleJdbcInsert(dataSource).withTableName("books")
            .usingGeneratedKeyColumns("id");
   }
View Full Code Here
103
104
105
106
107
108
109
110
111
    private SimpleJdbcTemplate simpleJdbcTemplate;
    private int counter = 0;
   
    protected void runSql(final String sql) {
        if (simpleJdbcTemplate == null) {
            simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
        }
        SimpleJdbcTestUtils.executeSqlScript(simpleJdbcTemplate, new ByteArrayResource(sql.getBytes()), false);
    }
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
      try {
        conn = this.dataSource.getConnection();
        //The order of these tests is IMPORTANT, each may depend on the
        //results of the previous tests.
        this.getMetaData(conn);
        final SimpleJdbcTemplate jdbcTemplate = new SimpleJdbcTemplate(this.dataSource);
       
        this.testDatabaseInitialized(jdbcTemplate);
        if (this.portalTablesExist) {
            this.testOuterJoins(jdbcTemplate);
            this.testTimeStamp(jdbcTemplate);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
    private SimpleJdbcTemplate simpleJdbcTemplate;
   

    @Before
    public void onSetUp() throws Exception {
        this.simpleJdbcTemplate = new SimpleJdbcTemplate(jdbcOperations);
       
        jdbcOperations.update("CREATE TABLE UP_SEQUENCE (SEQUENCE_NAME VARCHAR(1000), SEQUENCE_VALUE INTEGER)");
        assertEquals(0, SimpleJdbcTestUtils.countRowsInTable(this.simpleJdbcTemplate, "UP_SEQUENCE"));
    }
View Full Code Here
92
93
94
95
96
97
98
  /**
   * Set the DataSource, typically provided via Dependency Injection.
   */
  @Autowired
  public void setDataSource(DataSource dataSource) {
    this.simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
  }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.simple.SimpleJdbcTemplate

  • $.IndexAction
  • cn.org.rapid_framework.web.session.store.JdbcSessionStore
  • com.carbonfive.db.jdbc.datasource.RoutingDataSourceSpringTest
  • com.carbonfive.db.migration.DataSourceMigrationManagerTest
  • com.carbonfive.db.migration.GroovyMigrationTest
  • com.carbonfive.db.migration.H2MigrationTest
  • com.carbonfive.db.migration.HSQLMigrationTest
  • com.carbonfive.db.migration.MySQLMigrationTest
  • com.carbonfive.db.migration.PostgreSQLMigrationTest
  • com.carbonfive.db.migration.SimpleVersionStrategyTest
    • Copyright © 2018 www.massapicom. 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.