Examples with JdbcTemplate org.springframework.jdbc.core.JdbcTemplate used on opensource projects

Example 91 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class QuartzSupportTests method schedulerWithHsqlDataSource.

/**
	 * SPR-6038: detect HSQL and stop illegal locks being taken.
	 * TODO: Against Quartz 2.2, this test's job doesn't actually execute anymore...
	 */
@Test
public void schedulerWithHsqlDataSource() throws Exception {
    // Assume.group(TestGroup.PERFORMANCE);
    DummyJob.param = 0;
    DummyJob.count = 0;
    ClassPathXmlApplicationContext ctx = context("databasePersistence.xml");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(ctx.getBean(DataSource.class));
    assertFalse("No triggers were persisted", jdbcTemplate.queryForList("SELECT * FROM qrtz_triggers").isEmpty());
/*
		Thread.sleep(3000);
		try {
			assertTrue("DummyJob should have been executed at least once.", DummyJob.count > 0);
		}
		finally {
			ctx.close();
		}
		*/
}

Example 92 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class InferredDataSourceSqlScriptsTests method database2.

@Test
@Sql(scripts = "data-add-catbert.sql", config = @SqlConfig(transactionManager = "txMgr2"))
public void database2() {
    assertInTransaction(false);
    assertUsers(new JdbcTemplate(dataSource2), "Dilbert", "Catbert");
}

Example 93 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class InferredDataSourceTransactionalSqlScriptsTests method database1.

@Test
@Transactional("txMgr1")
@Sql(scripts = "data-add-dogbert.sql", config = @SqlConfig(transactionManager = "txMgr1"))
public void database1() {
    assertInTransaction(true);
    assertUsers(new JdbcTemplate(dataSource1), "Dilbert", "Dogbert");
}

Example 94 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class NamedParameterJdbcTemplateTests method testBatchUpdateWithSqlParameterSourcePlusTypeInfo.

@Test
public void testBatchUpdateWithSqlParameterSourcePlusTypeInfo() throws Exception {
    SqlParameterSource[] ids = new SqlParameterSource[2];
    ids[0] = new MapSqlParameterSource().addValue("id", 100, Types.NUMERIC);
    ids[1] = new MapSqlParameterSource().addValue("id", 200, Types.NUMERIC);
    final int[] rowsAffected = new int[] { 1, 2 };
    given(preparedStatement.executeBatch()).willReturn(rowsAffected);
    given(connection.getMetaData()).willReturn(databaseMetaData);
    JdbcTemplate template = new JdbcTemplate(dataSource, false);
    namedParameterTemplate = new NamedParameterJdbcTemplate(template);
    int[] actualRowsAffected = namedParameterTemplate.batchUpdate("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = :id", ids);
    assertTrue("executed 2 updates", actualRowsAffected.length == 2);
    assertEquals(rowsAffected[0], actualRowsAffected[0]);
    assertEquals(rowsAffected[1], actualRowsAffected[1]);
    verify(connection).prepareStatement("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = ?");
    verify(preparedStatement).setObject(1, 100, Types.NUMERIC);
    verify(preparedStatement).setObject(1, 200, Types.NUMERIC);
    verify(preparedStatement, times(2)).addBatch();
    verify(preparedStatement, atLeastOnce()).close();
    verify(connection, atLeastOnce()).close();
}

Example 95 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class NamedParameterJdbcTemplateTests method testBatchUpdateWithSqlParameterSource.

@Test
public void testBatchUpdateWithSqlParameterSource() throws Exception {
    SqlParameterSource[] ids = new SqlParameterSource[2];
    ids[0] = new MapSqlParameterSource("id", 100);
    ids[1] = new MapSqlParameterSource("id", 200);
    final int[] rowsAffected = new int[] { 1, 2 };
    given(preparedStatement.executeBatch()).willReturn(rowsAffected);
    given(connection.getMetaData()).willReturn(databaseMetaData);
    JdbcTemplate template = new JdbcTemplate(dataSource, false);
    namedParameterTemplate = new NamedParameterJdbcTemplate(template);
    int[] actualRowsAffected = namedParameterTemplate.batchUpdate("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = :id", ids);
    assertTrue("executed 2 updates", actualRowsAffected.length == 2);
    assertEquals(rowsAffected[0], actualRowsAffected[0]);
    assertEquals(rowsAffected[1], actualRowsAffected[1]);
    verify(connection).prepareStatement("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = ?");
    verify(preparedStatement).setObject(1, 100);
    verify(preparedStatement).setObject(1, 200);
    verify(preparedStatement, times(2)).addBatch();
    verify(preparedStatement, atLeastOnce()).close();
    verify(connection, atLeastOnce()).close();
}